How to create a funnel visual bar chart in Tableau by creating a calculated field using an existing column in the data source

0 votes

A column called 'Pool' exists in my data source.

There are roughly three values in the column:

|  Pool  |
|   B    |
|   C    |
|   B    |
|   A    |


As you can see, there are three different values: A, B, and C. I'd want to make a funnel, which is simply a bar chart that will compute and count each of those three numbers in the entire column. I know I can't just put the column in the sheet since I also want a fourth bar that counts all of the values as a "All" category.

As a result, having a visual that says (but this is in tabular form to help illustrate what I mean)

All | 40
A   | 5
B   | 20
C   | 15
Mar 25 in Tableau by Neha
• 8,560 points
57 views

1 answer to this question.

0 votes

Please find a possible solution in fiddling.

You could combine two results to get the COUNT for each of your values and one COUNT for all of your samples by using UNION.

(SELECT Pool, COUNT(Pool) AS your_count
FROM your_table
GROUP BY Pool)
UNION
(SELECT 'ALL', COUNT(*) AS your_count
FROM your_table)
ORDER BY your_count DESC
answered Mar 29 by Vaani
• 7,020 points

Related Questions In Tableau

0 votes
1 answer

How to perform a calculation using one variable with an aggregation in calculated field?

Hi, You can use the calculative field and ...READ MORE

answered May 20, 2019 in Tableau by anonymous
• 33,010 points
227 views
0 votes
1 answer

How to fix spelling error in a field or column value using Tableau?

You should be able to use a ...READ MORE

answered Mar 10 in Tableau by Neha
• 8,560 points
73 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
8,054 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by sdfg
• 5,550 points
422 views
0 votes
1 answer

Tableau Bar Chart Using Multiple Pictures instead of Bar Charts

As a solution to your problem, Place the ...READ MORE

answered Mar 29 in Tableau by Vaani
• 7,020 points
26 views
0 votes
0 answers

How to exclude weekend (Sunday only) to DATEDIFF in Tableau?

My current formula is : DATEDIFF('day', MIN([Date]),MAX([Date])). How do ...READ MORE

Apr 7 in Tableau by Vaani
• 7,020 points
25 views
0 votes
1 answer

Tableau Public Background Images Not Working

The functionality you're talking about (Map -> ...READ MORE

answered Mar 3 in Tableau by Vaani
• 7,020 points
38 views
0 votes
1 answer

Tableau Public Background Images Not Working

The functionality you're talking about (Map -> ...READ MORE

answered Mar 3 in Tableau by Vaani
• 7,020 points
55 views
0 votes
1 answer

Tableau: How to create a filter based of 3 different columns?

The case you're using for filters is ...READ MORE

answered Mar 16 in Tableau by Vaani
• 7,020 points
387 views
0 votes
1 answer

Creating a stacked waterfall chart in tableau

You can try this as a solution: 1.) ...READ MORE

answered Apr 5 in Tableau by Vaani
• 7,020 points
135 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP