Bar chart help

[pawwy1415]

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

[jyothish8807 · Accepted solution]

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

[sunny_talwar]

The whole thread just vanished in the wind.... good job pawwy1415‌‌ for making sure that all our efforts go in vain

[pawwy1415]

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.