# Calculate an average of the column

Solved!
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

Regards,

Hugo

Dataiku Table

1 Solution
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
• Click compute

I hope this helps

2 Replies
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
• Click compute

I hope this helps

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