Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cumulative funnel chart not working

Hi all, I need to create a cumulative funnel of candidates throughout the status new applicant, candidates screen etc... (e.g. candidates in new applicant must also count candidates in later steps s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I managed to fix it partially 

1. The all was poiting to a column instead of a table only

2. The sign of the maximum was inverted

 

Funnel2 =

CALCULATE (
    COUNTROWS(LevOpportunityApp_applications),
    FILTER (
            ALL ( 'LeverStages_order/type'), 'LeverStages_order/type'[Stage order] >= MAX( 'LeverStages_order/type'[Stage order] )
))
 
 
Now the result is as follows which is ALMOST what I want. Now I have 2 issues;
1. The issue with very long values e.g. the Status= Business review is due to the fact that such status didn't have any Candidates at all. Do you have any suggestions on how to not show these status if their value is zero? I can't hide such status as depending on the Job position, these statuses MIGHT be populated.
2. The values inside the graphs are OK (%)
 
Any idea how to fix these?