Forum Discussion
Helper IICreate 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 offered, all offered candidates are interviewed but may not be hired and all interviewed candidates may or may not be offered/hired. This data need to be grouped in funnel chart. Please help to achieve this.
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"))
2 Replies
- amitchandak
Super User
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"))
lokeshb31Thanks Amit. I did not think of that we can use all values and group can be blank for funnel. It worked.