Average of n amount of columns

[YBob23]

Hi All, 

I would like to create an average of value of all columns. For example I would like to know the average on 0-1 which will be average (57+60+58+54+75) = 60.8
my issue is, I cannot just do sum((T1_Count) + (T2_Count)+(T3_Count)+(T4_Count)+(T5_Count))/5, as the number of columns will get larger everyday therefore if I just type 5 the next day it will give me the wrong average.
Thanks.

[davehus · Accepted solution]

Hi @YBob23 ,

Your best option would be to normalize the data and unpivot on the hour column. Then you could apply an average much easier.

Did I help you today? Please accept my solution and hit the Kudos button.