1 Reply Latest reply: Aug 17, 2017 3:59 PM by Felip Drechsler RSS

    Help needed in writing function ?

    Santhoh Ashokkumar

      I need a help in writing a function. For example, this is my table which I took from SQL database.

       

       

      Candidate StatusCandidate id
      Selected05
      Rejected03
      Rejected07
      Rejected02

       

      I want to show a chart which should say number of candidates rejected & number of employees selected. Help me out.Thanks. Can someone explain with chart. Thanks

        • Re: Help needed in writing function ?
          Felip Drechsler

          Hi Santosh,

           

          After you load the data, you can use set analysis to check the both measures you want, something like.

           

          // For the selected candidates

          count({<[Candidate Status]={'Selected'}>}[Candidate id])

           

          // For the selected candidates

          count({<[Candidate Status]={'Rejected'}>}[Candidate id])

           

          The bolded part is the set analysis and will segment your data as stated on the equality.

           

          Felipe.