Forum Discussion

FrederikHJ's avatar
FrederikHJ
Regular Visitor
9 years ago
Solved

Subset Funnel

Hi, I am trying to create a funnel where each layer is a subset of the previous. But I run into an issue with the category names. I would very much like, that the names did not include 'Count of'....
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi FrederikHJ,

     

    Based on test, I guess your records status may like below:

     


     

    Result:

     


     

    If as I said, you can use measures to calculate the current value, then drag them to funnel visual.

     

    Formulas:
    isSeen = COUNTROWS(FILTER(ALL(Sheet1),ISERROR(SEARCH("Seen",Sheet1[Status]))=FALSE()))
    isBid = COUNTROWS(FILTER(ALL(Sheet1),ISERROR(SEARCH("Bid",Sheet1[Status]))=FALSE()))
    isWon = COUNTROWS(FILTER(ALL(Sheet1),ISERROR(SEARCH("Won",Sheet1[Status]))=FALSE()))

     

    Funnel visual:

     


     

    If above is not help, can you provide a sample to reproduce your issue?

     

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi FrederikHJ,

 

Based on test, I guess your records status may like below:

 


 

Result:

 


 

If as I said, you can use measures to calculate the current value, then drag them to funnel visual.

 

Formulas:
isSeen = COUNTROWS(FILTER(ALL(Sheet1),ISERROR(SEARCH("Seen",Sheet1[Status]))=FALSE()))
isBid = COUNTROWS(FILTER(ALL(Sheet1),ISERROR(SEARCH("Bid",Sheet1[Status]))=FALSE()))
isWon = COUNTROWS(FILTER(ALL(Sheet1),ISERROR(SEARCH("Won",Sheet1[Status]))=FALSE()))

 

Funnel visual:

 


 

If above is not help, can you provide a sample to reproduce your issue?

 

Regards,
Xiaoxin Sheng

FrederikHJ's avatar
FrederikHJ
Regular Visitor
9 years ago

That is perfect!

Many thanks :manhappy: