Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

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
Dataiker

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

1 Reply
Manuel
Dataiker
Dataiker

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

A banner prompting to get Dataiku DSS