ryansleeper

About Ryan Sleeper

Ryan Sleeper is founder and principal of Playfair Data. He is a data visualization designer, author, speaker, trainer, and consultant specializing in Tableau. Ryan is a current Tableau Zen Master, 2013 Tableau Iron Viz Champion, author of the 2015 Tableau Public Visualization of the Year, and author of Practical Tableau (O'Reilly).

How to Use Tableau Set Actions to Compare the Top N vs Other

How to Use Tableau Set Actions to Compare the Top N vs Other FeatureTableau set actions are a new (as of version 2018.3) type of dashboard action that will unlock new user experiences by allowing you to dynamically control which dimension members are included in a set. Some of my favorites that have already been figured out include How to Highlight with Color by Matt Chambers, How to Change Dimensions by Lindsey Poulter,  How to Make a Cross-Highlight by Rody Zakovich, and How to Drilldown in a Single Sheet by Ann Jackson, just to name a few. A general thread that I’ve noticed between the innovative applications of set actions is they’re often used to make existing dashboards and tutorials better, and I am no exception. I’ve shown you before how to dynamically group the top N vs everything else using a parameter. This is a user experience I like because it reduces the cognitive load on my end user, making it easier for them to consume the view. In this post, I will make this experience even better by using set actions to allow my end user to choose the top N by simply clicking on the dimension members on a chart.

By | 2018-11-13T14:37:48+00:00 November 13th, 2018|Tableau Tips|

How to Use Tableau’s Parameter Actions Extension to Change Date Parts

How to Use Tableaus Parameter Actions Extension to Change Date Parts FeatureOne of the features announced at Tableau Conference 2018 that I am most excited about is parameter actions. This feature will unlock a lot of flexibility that will provide better opportunities to design your user experiences and transfer control of an analysis from yourself to your end users. But did you know this feature is already available in the form of a Tableau dashboard extension called Parameter Actions? In this post, I’ll be sharing one of my favorite ways to improve the user experience of a line graph by allowing users to choose which date part, or granularity, is being visualized (i.e. day, week, month, year). Then we’ll make that user experience even better by using Tableau’s Parameter Actions extension, which is available as of Tableau Desktop 2018.2. The dashboard extension will allow us to create a seamless, web-like experience that will allow our end users to change a date part by simply clicking on a letter!

By | 2018-11-07T14:37:54+00:00 November 5th, 2018|Tableau Tips|

Tableau Formatting Tip: How to Display Varying Decimal Places

Tableau Formatting Tip How to Display Varying Decimal Places for the Same Measure FeatureI recently received a great question from a Twitter connection, and I figured I would share the solution here in case it helps anybody else. They were trying to display four decimal places when the measure value on the view was less than one, but only two decimal places when the measure value was greater than one. This was a brainteaser because, by default, Tableau limits you to one number format per measure. I loved the concept though because I’m a big believer in maximizing the data-ink ratio and the extra decimal places could be considered redundant data ink. My first instinct was to dynamically format the numbers with parameters, but this technique only works for controlling the prefix and suffix of each different number type. Instead, this post will show you two alternative approaches that allow you to control the prefix, suffix, and/or the number of decimal places when you are trying to display two (or even three!) number formats for the same measure in Tableau.

By | 2018-10-31T13:53:50+00:00 October 30th, 2018|Tableau Tips|

How to Normalize Current and Prior Dates on the Same Axis in Tableau

How to Normalize Current and Prior Dates on the Same Axis in Tableau FeatureDates can be tricky to work with in Tableau. It’s no wonder there are six different chapters in Practical Tableau explaining different approaches to get the most out of this special data type. One of my favorite techniques, that doesn’t happen ‘out-of-the-box’ for us in Tableau, is to compare the performance of a selected date range to the performance of the date range immediately preceding it. For example, if I choose this week as the current date range, I want to see this week’s data in addition to last week’s data so I can do an easy period-over-period analysis. You can always set your date range filter to capture both time periods, but if you’re using a continuous axis, the dates will not be lined up on top of each other – making it difficult to compare dates. This post and video will show you how to compare any selected date range to the same number of days immediately preceding the selection – all on one axis so they’re lined up! While I’ve written about this topic before, I’ve found an even better approach to reduce the number of calculations required.

By | 2018-10-21T21:33:20+00:00 October 21st, 2018|Tableau Tips|

Announcing Tableau Conference 2018 Plans, Book Signing, and Giveaways

Tableau Conference 2018 Plans, Book Signing, and Giveaways FeatureHeaded to New Orleans next week? I’d love to say ‘Hi!’ in person, so I’m sharing my schedule and some announcements below:

Practical Tableau Tips Tuesday, 2:15 – 3:15 PM | New Orleans Theater B

It’s hard to believe this will be my eighth presentation across Tableau Conferences. While they’ve all been fun, this one is special because I’ll be discussing the data visualization values that help drive my decision-making process. I’ll be sharing personal stories that help shaped my style, show you how to make traditional chart types more engaging, and we’ll get innovative and talk about how color and spatial context help your audience understand your work. If you are interested in attending, please star the session (Practical Tableau Tips by Ryan Sleeper) in the TC18 app to ensure everybody will have an opportunity to attend.

By | 2018-10-16T10:39:05+00:00 October 16th, 2018|Announcements|