I would like to get a maximum queue size across multiple splits for multiple days
E.G.
split 101 - queue over the week 2 4 5 5 7 4 2
split 102 - queue over the week 4 5 3 3 3 4 5
Report maximum queue size is 10 (the 7 and 3 on day 5)
Report already reports averages, max, and sum, so the only way I can see would be to grab the data from elsewhere or get CMS to accept a nested query.
e.g. max(selelct sum(maxqueue) group by starttime where split in [Splits/Skills]).
Any ideas?
E.G.
split 101 - queue over the week 2 4 5 5 7 4 2
split 102 - queue over the week 4 5 3 3 3 4 5
Report maximum queue size is 10 (the 7 and 3 on day 5)
Report already reports averages, max, and sum, so the only way I can see would be to grab the data from elsewhere or get CMS to accept a nested query.
e.g. max(selelct sum(maxqueue) group by starttime where split in [Splits/Skills]).
Any ideas?