Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
trying to sum the average amount for each branch as per below:
Sum(aggr(avg(Balance),Branch))
When selecting one time (ie 09:00) Im getting the correct value.
However, Problem is I cannot plot these values in a graph (hour as dimension), neither can I show these values per hour in a Pivot.
Im missing something here. Any clues?
Sample file attached.
Regards,
Olle
Hi,
Try sum(aggr(avg(Balance),Branch,Time))
BR
Ariel
thanks!