Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have below Bar chart with
Dimension=[Reporting Month]
1 Measures used like below
=Count({<[Hiring Month]={'$(=Max([Reporting Month]))'},Status={'Active'},[Reporting Month]=>}distinct ID)
Requirement is in the below bar chart i have to show all the Months i.e.Feb 2018,Mar 2018 and Apr 2018 and need to show count(distinct ID) where Hiring Month=Reporting Month.
Expected output
Feb 2018=2
Mar 2018=2
and Apr 2018=4
Hi Kumar,
Try like this:
Dimension=[Reporting Month]
2 Measures used like below
1. Joiners =Count({<[Status]={'Active'}>}distinct [ID])
2. Leavers =Count({<[Status]={'Left'}>}distinct [ID])
if you want the charts independent of selection on "[Reporting Month]", then try like this:
Dimension=[Reporting Month]
2 Measures used like below
1. Joiners =Count({<[Status]={'Active'},[Reporting Month]=>}distinct [ID])
2. Leavers =Count({<[Status]={'Left'},[Reporting Month]=>}distinct [ID])
Br,
KC
Hi Kumar,
Try like this:
Dimension=[Reporting Month]
2 Measures used like below
1. Joiners =Count({<[Status]={'Active'}>}distinct [ID])
2. Leavers =Count({<[Status]={'Left'}>}distinct [ID])
if you want the charts independent of selection on "[Reporting Month]", then try like this:
Dimension=[Reporting Month]
2 Measures used like below
1. Joiners =Count({<[Status]={'Active'},[Reporting Month]=>}distinct [ID])
2. Leavers =Count({<[Status]={'Left'},[Reporting Month]=>}distinct [ID])
Br,
KC
The whole thread just vanished in the wind.... good job pawwy1415 for making sure that all our efforts go in vain
Hi Sunny,
Please don't mind. I have shared some real time screen shots. I have tried to remove my reply but unfortunately the whole reply's were gone.