Count by Age

[BrianDH]

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

[Vegar · Accepted solution]

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 . 

[BrianDH]

where do I place the Distinct Count ReportID

[BrianDH]

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') ) )