Forum Discussion

lokeshb31's avatar
lokeshb31
Icon for Helper II rankHelper II
5 years ago
Solved

Create group from multiple columns for funnel chart

Hello Experts,   We have a requirement to display Applicants, Interviewed candidated, offered and Hired ones in funnel chart in our organization.  All Hired candidates are interviewed and of...
  • amitchandak's avatar
    amitchandak
    5 years ago

    lokeshb31 , In funnel visual you can use all measures. Do not add group

     

    examples

    Applicants = count(Table[candidate_id])

    Hired= calculate(count(Table[candidate_id]), filter(Table , Table[Hired] ="Yes"))

    Interviewed = calculate(count(Table[candidate_id]), filter(Table , Table[Interviewed] ="Yes"))

    offered = calculate(count(Table[candidate_id]), filter(Table , Table[Interviewed] ="offered"))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

lokeshb31 , In funnel visual you can use all measures. Do not add group

 

examples

Applicants = count(Table[candidate_id])

Hired= calculate(count(Table[candidate_id]), filter(Table , Table[Hired] ="Yes"))

Interviewed = calculate(count(Table[candidate_id]), filter(Table , Table[Interviewed] ="Yes"))

offered = calculate(count(Table[candidate_id]), filter(Table , Table[Interviewed] ="offered"))

  • lokeshb31's avatar
    lokeshb31
    Icon for Helper II rankHelper II
    5 years ago

    Thanks Amit. I did not think of that we can use all values and group can be blank for funnel. It worked.