Calculating Average

[#1]

Hi All

I have two fields, [Number of People in Building] (Numeric) and [Hour] (00:00 - 23:00) respectively.

I would now like to calculate which hour of the day has the most number of people in the building on an average.

How can I do this?

[MK_QSL]

=Max(Aggr(SUM( [Number of People in Building]),Hour))

This will give you Max Number of People on any hour

=FirstSortedValue(Hour, -Aggr(SUM( [Number of People in Building]),Hour))

This will give you Hour when the Number of People are Maximum compare to all Hour.

[#3]

Hi,

You can try like this.

Dimension: Hour

Expression:  Avg( [Number of People in Building])

[jyothish8807]

Hi Tumelo,

PFA.

Hope it helps.

Regards

KC