Calculate an average of the column

[Hugo_Wsld]

Hello everyone,

Pease, could you let me know how to calculate the average of the column of this table below ?

I don't want to calculate the average of the rows, but the average of the column only

Many thanks, in advance

Regards,

Hugo

Dataiku Table

[Manuel · Accepted solution]

Hu Hugo,

You can use the metric functionality:

• on the dataset, select the Status tab > Edit > Column Statistics (see image)
• Define the AVG for the column you want
• Now go back to the Metrics tab and click 9/7 Metrics button
• Add your metric to display
• Click compute

More information here: 

• documentation: https://doc.dataiku.com/dss/latest/scenarios/metrics.html
• Video from academy: 

I hope this helps

[Tashhh]

Hello,

I tried to calculate the avg and sum of a column but I got "INFINITY" as an output value.

How can I solve this please?

You'll find attached the metrics values as well as a snippet of the dataframe that I'm working on.

Thanks