Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@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 , 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"))
Thanks Amit. I did not think of that we can use all values and group can be blank for funnel. It worked.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |