3 Replies Latest reply: Jul 25, 2018 9:20 AM by P Kumar RSS

    Bar chart help

    P Kumar

      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

      requirement.png

        • Re: Bar chart help
          Jyothish 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

          • Re: Bar chart help
            Sunny Talwar

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