topic Age Range runtime in a chart in App Development

Age Range runtime in a chart

Riccardo — Mon, 20 Dec 2021 21:08:46 GMT

Hello,

I want to calculate the Customer Age runtime in a chart

"Max(Year)-[Year Customer]"

I have a range table:

Range Start, Range End, Range Result

0,25,<25

26,50,26-50

etc

Dim: if(Max(Year)-[Year Customer]<=[Range Start] and Max(Year)-[Year Customer] >= [Range End],[Range Result])

Measure: Count(Customer)

Is this correct? I have to use an aggr?

Usama — Tue, 06 Oct 2020 11:06:30 GMT

Hi,

What expected output you want to show?

Thanks

Riccardo — Tue, 06 Oct 2020 11:09:50 GMT

Count of Customers, grouped by Age Range.

(ps. I can't use intervalmatch on script, 'cause I have to calculate the Customers Age on runtime)