Swap a Field with a Parameter in Tableau
Вставка
- Опубліковано 23 лип 2024
- Connect with us:
•Upcoming Tableau Classes: www.eventbrite.com/o/onenumbe...
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
Parameters are a powerful tool in Tableau. They allow end users to customize the view that they're seeing by selecting pre-defined values.
But where do we begin when using parameters? Well, the "Swap-A-Field" Parameter is the perfect place!
We're going to build views that allow us to:
1. Swap a Measure with a parameter
2. Swap a Dimension with a parameter
3. Swap a Sort Order with a parameter.
While this video provides some of the basics for using parameters, it's by no means exhaustive. If you'd like a deep-dive into how to use parameters effectively and creatively in Tableau, why not come along to our Mastering Tableau Calculations 2 Class?
You can sign up here:
www.eventbrite.com/e/masterin...
Resources:
•Check out example workbook on Tableau Public here: public.tableau.com/app/profil...
Chapters:
0:00 Examples
1:00 Swap a Measure
6:20 Swap a Dimension
8:35 Dynamic Sorting
Need help swapping fields with a parameter? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Very helpful video. I was searching for exactly this !
Perfect! Thank you for letting us know and we're glad it helped!
Hi there, can you explain further why you made "Sort By" discrete? To get a heading...? So it could be a column that you could hide?
Hey Wendy, thanks for checking out the video! Correct, we wanted the field (which eventually became a rank) to be a label. Once it was a label, it would sort in ascending text order (e.g. 1,2,3) by default. If it were left as continuous, Tableau would try to plot the rank numbers against an axis and the visual would return a screwy looking scatter plot.
More on Discrete vs. Continuous here: onenumber.biz/blog-1/2022/5/2/discrete-vs-continous-in-tableau
How can we show all these measures side by side by providing the 'All' option in the parameter?
It might be best to use Measures Names and Measure Values if you want to show multiple measures at once. You can provide Measure Names to the end user as a filter option.
I've got a couple of button image .png's I created that I'd like to use as buttons to control the parameter I've created, on my dashboard.I know that in the paid version I can use custom buttons to control a parameter easily, but is there a way to do this on the free version? I'm having trouble finding a workaround. 😅
Hey! I'm actually not sure about the difference between the free and paid software... But here's a great post on how to create buttons for parameters in Tableau Desktop!
playfairdata.com/how-to-do-button-swapping-with-parameters-in-tableau/
@@onenumbertableau Wow, thank you so much!!! 😸👍👍