Daily Average of Houly Sum of Data

[Roveqz]

Hi! Im a newbie to QS. May data is composed of the following Columns below.

Location

YEAR

YEAR2

MONTH

WEEK

DAY

DATE

HOUR

RESOURCE_ID

FUEL_TYPE

TYPE

PARTICIPANT

GRID

MAX_OFFER

SCHEDULE

SUPPLY

What formula should I use to display the Daily Average of Sum of SCHEDULE... I'm using the formula

Avg(Sum(DATE,HOUR) SCHEDULE)

it says nested aggregation not supported...

Would love to hear from you. Thanks in advance.

[hic]

Try

Avg(Aggr(Sum(SCHEDULE),DATE,HOUR) )

The Aggr() is necessary for all nested aggregations. Here, it will calculate the Sum(SCHEDULE) for each combination of DATE and HOUR, and then calculate the average of the result.

If you want to display this per Date, you should create a chart (pivot table, bar chart, etc.) with Date as dimension and the above expression as measure.