Paxata Compute Formula

Highlighted
Image Sensor

Hi all,

Need help in Paxata for the below input field. Request someone help to get the output as mentioned below.

Paxata Input FieldPaxata Output 
15.415.400
8888.000
999.22999.220
10.44410.444
97.2386097.238
0.10000.100

 

Please let me know if you have any questions

Regards,

Praveen

3 Replies
Highlighted
DataRobot Employee
DataRobot Employee

You need to do a ROUND in order to get the numbers to round to 3 decimal places. 

Round(@price@, 3) 

 

0 Kudos
Highlighted
Image Sensor

No. Round function is not working. Example : 12.4 => 12.400 , 1=> 1.000 , 1.38=> 1.380 

Praveen_0-1599146021924.png

 

0 Kudos
Highlighted
DataRobot Employee
DataRobot Employee

@Praveen 

If I understand your question correctly, when you do round(12.4, 3) you expect the output to display 12.400. 

Paxata operates on the data accurately, but our visual data prep interface provides users with visual cues as well as reduces visual noise. Some of the visual noise-reduction that Paxata does is by having an insignificant part of a date-time be greyed out, or not displaying trailing zeroes. However, Paxata stores the data in the expected format, and this would become quite apparent if one were to operate on the data. 

 

Take the below set of steps: 

  • I rounded the price column to 3 digits using Round(@price@, 3) to create a new column new_price

shyam_0-1599147993740.png

 

  • I added 0.001 to the new_price column to see that my values are being stored accurately. 

shyam_1-1599148089626.png


In the below example with dates, Paxata intelligently highlights only the significant parts of the timestamp so that the user can gain insights from it. 

shyam_2-1599148197922.png

I hope this explains the behavior. If you are facing issues, feel free to reach out to your customer success representative or send an email to support@datarobot.com with details of the issue so that we could resolve it at the earliest.