sum total of $ amounts in a column

UN

Hello,

I'm trying to get the sum total of all the dollar amounts in a particular column in one of the datasets on dataiku. But the dataset when explored only gives us the first x number of rows and not all the rows. So how to make sure that when I calculate the total amount, all the records are used and not just a snapshot of it?

In the SQL toad tool I use, once you run the query and pull the results, you can do a quick right click on the column to get the sum total value/count etc. I'm thinking if there is something like that here on dataiku.

Thanks!

Sarina

Hi @UN
,

You can use the "Status" tab of the dataset to add metrics that will compute after each build of the dataset. If you click on Status > Edit you can add metrics. For columns, you can select "Sum" as one of the metrics that is calculated:

If you return to the "Metrics" tab, you can then add this metric (and any other metric you are interested in calculating) and it will display on this screen:

You can also calculate SQL Probe metrics if you ever need to create a more complicated metric.  

Let me know if you have any questions about this approach!

Thanks,
Sarina