Max Value based on Week

[Anonymous]

Hello,

I have a graph with the Dimension as

=WeekStart

and Measure as

=sum({<UNIT = {'PALLET STORAGE'}>}Value)

The max value we get is on the 5th January around the 20,000 mark.

Is it possible to show the Highest Figure and Lowest Figures in KPI's?

Hopefully you understand, please ask if not!

[Neymar_Jr · Accepted solution]

Hi callan.dooley,

Yes it is possible. You need to use the following exp. -

For max - max(aggr(sum({<UNIT = {'PALLET STORAGE'}>}Value),WeekStart))

For min - min(aggr(sum({<UNIT = {'PALLET STORAGE'}>}Value),WeekStart))

Thanks,

RT