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, 2022 in Tableau by Neha
• 9,060 points
474 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, 2022 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,030 points
473 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, 2022 in Tableau by Neha
• 9,060 points
570 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,240 points
9,420 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 ffdfd
• 5,550 points
989 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, 2022 in Tableau by Vaani
• 7,020 points
575 views
0 votes
1 answer

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

To exclude Sundays from the DATEDIFF calculation ...READ MORE

answered Jul 3, 2023 in Tableau by anonymous
• 1,180 points
566 views
0 votes
1 answer

Tableau Public Background Images Not Working

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

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

Tableau Public Background Images Not Working

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

answered Mar 3, 2022 in Tableau by Vaani
• 7,020 points
692 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, 2022 in Tableau by Vaani
• 7,020 points
2,298 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, 2022 in Tableau by Vaani
• 7,020 points
1,050 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP