I want to calculate the Customer Age runtime in a chart
I have a range table:
Range Start, Range End, Range Result
Dim: if(Max(Year)-[Year Customer]<=[Range Start] and Max(Year)-[Year Customer] >= [Range End],[Range Result])
Is this correct? I have to use an aggr?
Hi,What expected output you want to show?Thanks
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)