Create expression which counts values in year range

[Anonymous]

Hello ,

I am trying to calculate the count employees who joined between the range of two years such as Min year and Max year.

Below image contains the range selection so from this I want to select min year as 1946 and Max year 1955 and calculate count in between them. Can any body suggest me approach how to get that selected range values of year in expression as well as using Rangecount() is feasible here or not?

[sunny_talwar]

Are you trying to get the Min year or the value associated with Min Year? and same for max? If it is the value associated with min year... would you be able to share the expression you are using?

[rahulpawarb · Accepted solution]

Hello Jayesh,

If I understood your requirement then you can add one KPI chart to your application with expression as COUNT([EmployeeId])

When you do the range selection on your other chart then the KPI chart will show Total Employees within that selected range.

Please correct me if I misinterpreted.

Regards!

Rahul

[Anonymous]

     I needed count in between that range. With help of KPI object i was able to do it. Thank you for your help

[Anonymous]

Thank you for your help.