Forum Discussion

Sweet-T's avatar
Sweet-T
Icon for Helper III rankHelper III
8 years ago
Solved

Funnel: Show Categories with Zero

Hi everyone! 

I'm trying to get my Funnel visual to display categories with counts of zero. I have tried adding "+0" to my function with no success: 

Opportunity Count = 
// Literally just assigning an integer of 1 to each opportunity. 
//This is so you may sum the number of opportunities, instead of using the "Count" function. 
//This is important for calculating the conversion ratio. 
IF(
    'BD Opportunity'[Milestone] = "Stage 1", 
    1+0,
        IF('BD Opportunity'[Milestone] = "Stage 2", 
    1+0,
            IF('BD Opportunity'[Milestone] = "Stage 3",
                1+0,
                    IF('BD Opportunity'[Milestone] = "Stage 4", 
                        1+0,
                            IF('BD Opportunity'[Milestone] = "Stage 5",
                                1+0,
                                    IF('BD Opportunity'[Milestone] = "Stage 6",
                                        1+0,
                                        +0))))))

Currently, when I filter by Account Manager, if that Account Manager has no opportunities at a given stage, it will fall out of the funnel. 

Thanks in advance!

 

T

 

Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Sweet-T

     

    Create a Table with:

     

    Stages  Order

    One         1

    Two         2

    Three      3

     

    ( Replace One, Two, Three with your Stages Names)

     

    Select the Order to the Stages Column (Modeling - Sort by column)

     

    Use this column in your funnel.

     

    Let me know if works in your scenario

     

    Victor

     

    Let me know if W

     

     

     

4 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Sweet-T

     

    Hi, Try creating a New Table With Stages and use this field in your Funnel

     

    Regards

     

    Victor

    • Sweet-T's avatar
      Sweet-T
      Icon for Helper III rankHelper III
      8 years ago

      Hey Vvelarde, 

       

      Stages as the rows or columns? Currently I have a master table with them as rows. 

       

      Thinking ahead, I will want to filter this funnel with the Account Managers, and some Date metrics. Won't I lose this ability as they won't be in the same table anymore? 

       

      Thanks for helping, 

      T

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Sweet-T

         

        Create a Table with:

         

        Stages  Order

        One         1

        Two         2

        Three      3

         

        ( Replace One, Two, Three with your Stages Names)

         

        Select the Order to the Stages Column (Modeling - Sort by column)

         

        Use this column in your funnel.

         

        Let me know if works in your scenario

         

        Victor

         

        Let me know if W