Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I hope you can assist me please.
I want to get the minimum and maximum value difference out of all time sections that build up a specific line.
The time is for hours in the day.
The sheet is grouped by Day.
So it should look something like this (using basic calculations):
Day | Outlet | Capacity | Quantity | Minimum | Maximum |
---|---|---|---|---|---|
Mon | Site A | 24 | 24 | 1 | 1 |
Mon | Site B | 24 | 25 | 1 | 2 |
Tue | Site A | 24 | 0 | 0 | 0 |
Tue | Site B | 24 | 49 | 2 | 3 |
The problem is with my current code, Minimum = 0 in all lines, and Maximum = 3 in all lines. This is the code i am using:
Min(total aggr(sum(DATA1_Qty / INTERVAL_Capacity1), Time))
*Replacing Min with Max in the next colum
The plan is to use this in a traffic light display, where if 1 hour has abnormal capacity vs usage to be different colors. But it needs to show combined by day.
Any assistance will be greatly appreciated.
Hi,
Did you tried without TOTAL
Min(aggr(sum(DATA1_Qty / INTERVAL_Capacity1), Time))
or
Min(total<Day,Outlet> aggr(sum(DATA1_Qty / INTERVAL_Capacity1), Time))
Celambarasan
Help file was quite insistant in using total in your code.
It seems to be working better at least. However -
There appears to be values of - (Null). But if i click on the Null then there is detail inside it. So surely can't be Null.