Aggregation on large scope than in dimension

[antonbb]

Hello,

I can't figure out QV behaviour, so could smbd help me understand

I have hourly data for power consumption. One hour in day is marked as peak hour.

In pivot table i've dimension:

Day

Expressions:

only({<PeakHourMark={1}>}POWER.VAL)  - power consumption for peak hour,

=MAX(aggr(max(POWER.VAL),%Date)) - maximum per day

=SUM(aggr(SUM(POWER.VAL),%Date)) - Total per day

=SUM(aggr(SUM(POWER.VAL),[Year Month])) - Monthly consumption

and i've a problem with monthly expression, QV show data for monthly only on first day of month and i don't understand why

I've attach excel file with example.

[Brett_Bleess]

You very likely need to attach the QVW file on this one, as going to be hard to troubleshoot without being able to see the data model and expressions in the chart etc.

Regards,
Brett