Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How can I calculate average for multiple columns?

I have 100+ columns and need an average for each one but don't want to create 100+ measures to compute the average for each one. Is there a faster way to do this, e.g. can I make just one measure and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

ryan_mayu ,

If I filter by attribute value_00 then I want the average for value_00, i.e. 25, and the same for value_01. Right now if I take average it will just average the entire column and give 37.5

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

Anonymous 

pls see the attachment below