7 Replies Latest reply on Sep 26, 2016 9:36 AM by Michael Hesser

# How to Create a funnel chart with non balanced value

Hi Guys,

I have an issue with doing a funnel chart. I have values that are to far from each other .

I would like to have it proportionnally.

To create that I use 4 measures :

My ISSUE :

To do that I think about creating calculated fields for each measure. and doing a weighted value.

So it gives me this

MY HALF-RESOLVE :

Notice that I created new calculated fields for weighted the value.

But my issue is to display the real value inside of each square....

I'm still thinking on the best way to display that.

Thank you very much for your help

Kevin

• ###### 1. Re: How to Create a funnel chart with non balanced value

Hello Kevin;

Have you seen this video?

Funnel Charts | Tableau Software

If your values are greatly different from each other, perhaps you can change to a logarithmic scale?

I hope this will do what you want.

• ###### 2. Re: How to Create a funnel chart with non balanced value

Hi Michael,

I already saw this video. I inspire myself with it but I met other issue to built it, as you see on my pictures the values are very different so I can't make it like the video..

Kevin

• ###### 3. Re: How to Create a funnel chart with non balanced value

Have you tried a logarithmic scale?

• ###### 4. Re: How to Create a funnel chart with non balanced value

Yes I tried...

So I created a dataset to show you my problematic

You will see the .twbx attached

• ###### 5. Re: How to Create a funnel chart with non balanced value

Hi Kevin Monges ;

The difference between your largest and next-largest value is so very great, I don't think you'll be very effective presenting this to an audience (unless that's your point: to show  them this needle in a haystack).

I have a few suggestions:

1) Keep the view you have about, only edit the axes so only a fraction of it is view-able. I've not worked with funnel charts much, so don't know if this is a plausible action.

2) Create a secondary graph using more reasonable values, then label the boxes with the values from the original data. This means you'll be creating a static (non-dynamic) picture, which is a downside if you want to visually chart improvement over time.

3) Manually reduce the size of Visitors

4) Reconsider if a funnel chart is the best method for relaying this data.

I'll watch the thread closely and see if others have other solutions!

--Michael

• ###### 6. Re: How to Create a funnel chart with non balanced value

Michael,

Finally, I kept the second chart and put annotations in the squares.

I guess that the way I did this chart is limited if I want to include some filters action..

Thank you for your help Michael.

Kevin

• ###### 7. Re: How to Create a funnel chart with non balanced value

No problem!

I was actually able to get some much better results by changing your data into a PIVOT table. This tied all your many-named fields together.

I didn't go much further than this (adding the values, erasing the axes, etc). Sounds like you got it figured out!