Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys im find something that should be fairly straightforward to be causing some issues.
I am trying to get the max value of a sum of a time interval from the following table.
Category | sum(TimeTaken) |
A | 55:50:00 |
B | 2:22:00 |
C | 18:00:00 |
D | 4:26:00 |
E | 0:58:00 |
F | 451:56:00 |
G | 7:19:00 |
H | 35:39:00 |
I | 28:45:00 |
J | 23:28:00 |
K | 6:12:00 |
L | 61:13:00 |
M | 28:27:00 |
N | 0:40:00 |
The value im expecting should be 451:56:00.
What I want to achieve is to set a "Static Max" value of a Y axis on a Chart table, reason is that I have one chart over the other, one of the charts is transparent and the user changes and filters values the Chart moves around on the max values.
So With this I would hope that I always have both charts showing the max possible value and thus they are always showing correct values.
Many Thanks
Try like:
=Max(Aggr(sum({1}TimeTaken),Category)) // {1} makes it selection irrespective thus making it static.
That does work, but the problem is now that if the user selects 2 or 3 months the chart bars become very small due to the scale of the whole chart.
Strangely if I replace the ignore selections os the set analysis with a $ it does not give me the correct value for my selections.
Confused.
Ok it was under my nose all along, the correct is
=interval(max(aggr(sum(interval(TimeTaken,'hh:mm')), Category)),'hh:mm')