1 2 Previous Next 28 Replies Latest reply on Feb 14, 2018 1:34 PM by Sherzodbek Ibragimov

Funnel chart - color

I have created the funnel chart with negative dimension But I need to put colors on the measure, But its still showing one color, I am lookng for something like this

Any way to do that.

Thanks

• 1. Re: Funnel chart - color

YEs it is possible. Can you please post your workbook /mock data as twbx or excel file So we can show you how to achieve that.

• 2. Re: Funnel chart - color

let me try without your data. first try to bring your dimension that contains all your phases in funnel chart To colors and change it accordingly. If it doesn't help then i need your mock data

• 3. Re: Funnel chart - color

No still its in blue color but the legent shows I have no idea?

• 4. Re: Funnel chart - color

if it doesn't work can you please post your mock data so we can look at it it

• 5. Re: Funnel chart - color

Hi Biju,

Not all as requested but find my approach below depicted and stored in a workbook at Tableau Public here.

Find directions here

Colourcoding:

IF [Number of Prospects]>=0 and [Number of Prospects]<=20 then 1

ELSEIF [Number of Prospects]> 20 and [Number of Prospects]<=40 then 2

ELSEIF [Number of Prospects]> 40 and [Number of Prospects]<=60 then 3

ELSEIF [Number of Prospects]> 60 and [Number of Prospects]<=80 then 4

else 5 END

Hope it helps...

1 of 1 people found this helpful
• 6. Re: Funnel chart - color

Norbert,

Very nice workaround, but since numbers change all the time, user has to adjust those threshold numbers manually. So, is there any other way around instead of threshold approach. Thank you

• 7. Re: Funnel chart - color

Good morning Sherzo,

From the "Top of my head" I think the "bounderies" of the threshold could be defined "dynamically" instead of "hardcoded" numbers as depicted above.

Let's wait for first feedback from Biju J

Have a nice one.

• 8. Re: Funnel chart - color

Norbert Maijoor , I have attached  a twbx. let me know you thoughts. Also note I am trying to achieve this using a area graph. And I am having only 9.2 version of tableau. So if you all attach version 10 file. I won't be able to open it.

• 9. Re: Funnel chart - color

Sherzodbek Ibragimov attached sample twbx

• 10. Re: Funnel chart - color

I don't see it. Can you re attach it. Thank you

• 11. Re: Funnel chart - color

Attached is a sample. Simply, you have to make your all phases as the separate measure values, along with their negative measure values and bring them to Column as the Measure Value (one field) and bring phases name (one field) to row as seen below.

1 of 1 people found this helpful
• 12. Re: Funnel chart - color

@Sherzodbek Ibragimov Sorry for late reply, I have attached a sample which I worked on.But still didn't reach anywhere.

• 13. Re: Funnel chart - color

Biju J

or see formula you should use for each step as seen below:

1 of 1 people found this helpful
• 14. Re: Funnel chart - color

Biju,