Calculate an average of the column

Solved!
Hugo_Wsld
Level 2
Calculate an average of the column

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 TableDataiku Table

 

 

0 Kudos
1 Solution
Manuel
Dataiker Alumni

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: 

I hope this helps

View solution in original post

2 Replies
Manuel
Dataiker Alumni

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: 

I hope this helps

Tashhh
Level 1

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

0 Kudos