Subset Funnel

[FrederikHJ]

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'.

I wouldn't be at all surprised if the way I've set it up is wrong, so a few pointers would be much appreciated.

Thanks

[MattAllington]

 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]

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 · Accepted solution]

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]

That is perfect!

Many thanks