Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In one KPI i have Headcount
and i have a filter as Months
now what i want is when i select Feb it should give me the headcount for jan in a new KPI
the expression i am writing is
count( {$<[As_On link.autoCalendar.Month]={Jan}>} distinct EmployeeNo )
but i want to achieve this by not mentioning jan i want it to give me headcount for current selection - 1
Thanks
try the below expression:
count( {< [As_On link.autoCalendar.Month] = {"$(=Max([As_On link.autoCalendar.Month])-1)"} >} distinct EmployeeNo )
try the below expression:
count( {< [As_On link.autoCalendar.Month] = {"$(=Max([As_On link.autoCalendar.Month])-1)"} >} distinct EmployeeNo )
Your autocalender should contain a field named [MonthsAgo] and by using that instead you could have an expression like this:
Count( {$<[As_On link.autoCalendar.MonthsAgo]={1}>} DISTINCT EmployeeNo )
This also works for December/January where you can't just subtract one from January and get December.
count( {$<[As_On link.autoCalendar.Month]={'Jan'}>} distinct EmployeeNo )
thank you so much