Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All. I'm a beginner user trying to get a grip on expressions. I'm pretty sure what I need to accomplish is pretty simple but I'm definitely struggling. Any guides on expressions would also be appreciated.
I need a label to aggregate the max number of users at any time, summed across all values. I.e. In the example below, if Jun 5 was selected it would return 11. If June 6 was selected it would return 10. If nothing was selected it return 11. If Serv1 was selected, it would return 5. If Serv1 and June 6 were selected it would return 3, etc.
DateTime | Server | Max Users |
Jun 5 | Serv1 | 5 |
Jun 5 | Serv2 | 6 |
Jun 6 | Serv1 | 3 |
Jun 6 | Serv2 | 7 |
Thanks in advance for any guidance that can be provided.
Ah. Should've kept at it before posting.
Got the expression:
=sum(aggr(max([Max Users]),Server))
A useful page in the F1 help menu was 'Expression syntax for calculated formulas'
Ah. Should've kept at it before posting.
Got the expression:
=sum(aggr(max([Max Users]),Server))
A useful page in the F1 help menu was 'Expression syntax for calculated formulas'
Something like this:
='Max User = ' &
if(len(GetFieldSelections('DateTime')) and len(GetFieldSelections('Server')),
max(aggr(sum([Max Users]), DateTime, Server)),
if (len(GetFieldSelections('Server')) = 0, max(aggr(sum([Max Users]), DateTime)),
max(aggr(sum([Max Users]), Server))))
See attachment.