Totals for Tableau Text Tables Tips and Tricks
Вставка
- Опубліковано 23 лип 2024
- Connect with us:
•Upcoming Tableau Classes: onenumber.biz/onenumber-table...
•Book an Office Hour with Eric: www.eventbrite.com/e/tableau-...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Eric on LinkedIn: / eric-parker-37513249
Description:
Text tables can be overwhelming because they contain a lot of information without using many pre-attentive attributes to draw the users' attention toward areas of interest. One of the best ways to add value to a text table in Tableau is to add totals!
There are numerous types of totals you can add to a Tableau worksheet. You can add totals for Rows, Columns, and can even choose which dimension-level you want sub-totals to display at. In addition, there are some workarounds you can use to display multiple types of totals at the same time.
Ready to add the full arsenal of Tableau totals to your skillset? Check out this video!
Resources:
•Example Tableau Workbook: public.tableau.com/app/profil...
Chapters:
0:00 Intro
0:23 Totals for Multiple Measure Text Tables
1:52 Totals for Single Measure Text Tables
3:47 Remove Totals
4:18 Subtotals
6:20 Aggregations of Totals
8:35 Upcoming Classes
9:00 Formatting Totals
9:47 Totals for Highlight Tables
11:06 Add Multiple Totals to Text Tables
Need help with your totals in Tableau? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 | Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Really like your videos, they are incredibly helpful. Wouldn't have been able to deliver the reporting hub I built for my Operation Unit without them. Have gotten tons of positive feedback.
Thank you so much Ryan, we love feedback like this!!
Thanks! Please look at your 4:42 time of your video, I don't have these options. I can double click on Totals but I don't see these horizontal icons you are showing. Am I need to make some ajustments? Thanks
Those options should display when you click and drag the Totals options and hover over your worksheet. As a backup plan you can always select the Analysis dropdown on your toolbar, hover over the Totals breakout menu, and then show totals from there instead.
@@onenumbertableau Thank You! I used the backup plan.
Very Nice, thanks! Can you please tell me how would you remove "NULLS" if you see below "GRAND TOTAL" a new row with the title "NULLS". Do you have any videos on this issue? Thanks
Can you right-click on the Null label and hide it?
@@onenumbertableau Thanks! I can exclude them but it is not a single NULL row, it is the sum of let us 30 rows. I can't hide 30 rows because there is important information in some other columns. Thanks
@@shoppersdream I wonder if you could hack it with a LOOKUP Table Calc filter?
Something like ISNULL(LOOKUP(MAX([Value]))) = FALSE
General ideas about LOOKUP filters here: onenumber.biz/blog-1/2023/11/1/how-to-hide-data-with-a-filter-in-tableau