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

MattAllington's avatar
MattAllington
Community Champion
9 years ago

 2 things

 

1. there is a funnel visual you can use in the visuals menu

2. If you write your own measures, you can call them what you like. Select new measure and then type something like this

 

Total Seen = countrows(table)

 

or what ever you need. 

FrederikHJ's avatar
FrederikHJ
Regular Visitor
9 years ago

Many thanks for your reply.

I am aware of the funnel visual (as shown by the picture).
The problem with this chart is, that it is not a subset chart, i.e. every layer is separate from the others.
Using the funnel as is will let each line item show up in only one layer of the funnel. 

What I am seeking to do is at funnel where I can see e.g. how many bids are won out of all the bids made.

 

Example: 

We have seen 200 opportunities in the market

of these 200, we have made bids for 100

of these 100, we have won 50.

 

This should give a funnel of:

200 'seen'

100 'bid'

50 'won'

 

However, just plugging this data-set into the visual will show this funnel:

100 'seen'

50 'bid'

50 'won'

as the top layer of the funnel will only show those opportunities that are marked 'seen' even though all the 200 obviously have been 'seen' 

 

So I guess my question is, how do I create a data-set where a line item can show up in more than one layer of the funnel when applicable?

 

Hope that makes sense. 
Thanks and regards

  • 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: