Display a Single Dimension Across Multiple Columns in Tableau
Vložit
- čas přidán 4. 08. 2024
- Connect with us:
•Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
•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:
Sometimes, you have too many rows in your #Tableau worksheet and end up with a scroll bar. Annoying, right? Scroll bars mean your users are less likely to see the data at the bottom of your worksheet because it it out of sight and out of mind.
What if you could break the data into multiple columns? For example, instead of displaying 50 states as a single column of 50 rows, could you display it at 2 columns of 25 rows?
The way that Tableau works "out of the box", that's not possible. However, with a little creativity, it is possible! You can use a combination of RANK functions to split a single dimension into multiple columns.
Massive shoutout to Andy Kriebel and his "Watch me Viz" video from December 2022 where I picked up the concepts behind this solution ( • Watch Me Viz - #Makeov... .
Resources:
•Example Workbook: public.tableau.com/app/profil...
•State and Country Abbreviations Blog Post: onenumber.biz/blog-1/2023/6/1...
Chapters:
0:00 Scroll Bar Problems
1:50 Column RANK Calculation
5:10 Row RANK Calculation
7:28 Overall RANK Calculation
8:15 Building Multi-Column Bar Chart
12:03 Building Multi-Column Highlight Table
Need help implementing this? 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
Hi, great video as always, congratulations! Is it possible to do conditional with different rules in a single table? For example, each metric has a different lighthouse, the idea would be for each metric to have its own conditional formatting, I did an "if" but Tableau didn't understand, just a conditional. Was there an alternative? Your videos help a lot, thank you!
Can you upload an example of what you're trying to accomplish to Tableau Public and share it? I'd love to take a look but I think I need to see the actual example to help with the solution.
Thank you!
You bet!
Can we do this multi-column but for 3 dimensions? E.g. State date with 2 measures, then spilling across multiple columns.
I don't understand the use case you're describing. Feel free to shoot a lengthier description with screenshots to start@onenumber.biz and I'm happy to help more if possible!
Thanks for the video, do you know of any work around for mapping a link for multiple urls but when we click on one link after other it should open in a new window, basically if I have a Dashboard and i have multiple links on it, if i click on one link and then I click on another link it’s opening another link on the same page as the previous link, please let me know of any workaround for this one, Thanks 😊
Thank you! As far as I know, the only options are to open the URL links in the same tab or a new tab but every URL link will be a new tab. Here are a few resources on it: kb.tableau.com/articles/howto/opening-links-in-separate-browser-windows-or-tabs#:~:text=To%20workaround%20this%20issue%3A,open%20in%20a%20new%20tab. and community.tableau.com/s/question/0D54T00000C5cu5SAB/need-to-open-each-url-link-in-a-seperate-tab
You can check out our content about converting state and country names to abbreviations here: onenumber.biz/blog-1/2023/6/14/calculate-state-and-country-abbreviations-in-tableau
Can this be done on dashboard rather than worksheet
I'm not sure what you mean by that. You can certainly put a worksheet where you use this approach into a dashboard.
Scenario is that I have multiple sheets 49 to be precise each containing single stacked bar chart and wanted to align it in 20 20 side by side in dashboard.
@@kunalborge5474 I see. I don't think aligning worksheets like that will work since it's all based on calculation logic. If possible, I'd recommend doing that alignment of those 49 values in a single worksheet using rank functions.