Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
0-2 | 3162 |
3-5 | 1748 |
6-10 | 1295 |
11-14 | 501 |
15+ | 962 |
this is what i am trying to do.
if aging >=0 and aging <= 2 then count ( distinct ReportID)
if aging >=3 and aging <= 5 then count ( distinct ReportID)
two questions: what object should I use and how is the best way to do this?
Thanks
B
I would probably go for a bar chart to visualise this. If you are to solve this issue front end only, then you will need to do nested if statement to solve this.
If( aging>=15, '15+',
If( aging<15, '11-14',
If( aging<11, '6-10', '<5') ) )
If you are allowed to work with the script then I would recommend you to look into intervalmatch to solve it .
I would probably go for a bar chart to visualise this. If you are to solve this issue front end only, then you will need to do nested if statement to solve this.
If( aging>=15, '15+',
If( aging<15, '11-14',
If( aging<11, '6-10', '<5') ) )
If you are allowed to work with the script then I would recommend you to look into intervalmatch to solve it .
where do I place the Distinct Count ReportID
Got it thanks!!
I used a table. It is what they wanted.
For values:
If(AGING>=15, count(distinct REPORTID),
If(AGING<15, count(distinct REPORTID),
If(AGING<11, '6-10', count(distinct REPORTID)) ) )
For Labels:
=If(AGING>=15, '15+',
If(AGING<15, '11-14',
If(AGING<11, '6-10', '<5') ) )