Max Value based on Week

Anonymous — Tue, 03 Jul 2018 11:06:44 GMT

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!

Re: Max Value based on Week

Neymar_Jr — Tue, 03 Jul 2018 11:22:04 GMT

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,