Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I want to display the count of New managers in the Current month but a not a manager in the previous month.
Addition of Manager in Current Month.
example: consider current month is Feb
Month Manager Id
Jan A 1
Jan B 2
Jan C 3
Month Manager Id
Feb A 1
Feb B 2
Feb D 5
Feb E 6
now count of new Managers in Current Month (Feb) is 2
Any Help would be appreciated.
Thanks,
Kavya
May be this:
=Count(DISTINCT {<MonthNum = {'$(=Max(MonthNum))'}, ID = e({<MonthNum = {'$(=Max(MonthNum) - 1)'}>})>}ID)
Hi Sunny
i want output in chart like this.
Month | New Manager count |
Jan | 0 |
Feb | 2 |
Thanks,
Kavya
Not sure how this would look if you have more than 2 months. But for two months the same expression seems to work:
I want to display for more than two months
hi,
Try this exp
=Count(DISTINCT {<MonthNum = {'$(=Max(MonthNum))'}, ID = e({<MonthNum = {'<$(=Max(MonthNum))'}>})>} ID)