Hi everyone,
I need help to count active id on master calendar.
My expression is
=Count({<EffectiveDate={'='>=' & $({Tipo={"hire"}>}EffectiveDate) '<=' & $({<Tipo={"terminate"}>}EffectiveDate)'}>}distinct ID)
My expected result is:
MonthYear |
Active ID |
Jan-2015 |
1 |
Feb-2015 |
1 |
Mar-2015 |
1 |
Apr-2015 |
1 |
May-2015 |
1 |
Jun-2015 |
1 |
Jul-2015 |
2 |
Aug-2015 |
2 |
Sep-2015 |
2 |
Oct-2015 |
2 |
Nov-2015 |
2 |
Dec-2015 |
2 |
Jan-2016 |
2 |
Feb-2016 |
3 |
Mar-2016 |
3 |
Apr-2016 |
3 |
May-2016 |
3 |
Jun-2016 |
3 |
Jul-2016 |
3 |
Aug-2016 |
3 |
Sep-2016 |
3 |
Oct-2016 |
2 |
Nov-2016 |
2 |
Dec-2016 |
2 |