Sometimes you really need to see the top n values in different categories, which is surprisingly tricky in Tableau! Here's a quick guide to doing that with index(). For Compute Using select Specific Dimensions For this example, check all field names under Specific Dimensions to avoid partitioning the data. Unchecking [Abilities] at … Continue reading Index Sort Order
Suppose you have a chart like this, and someone asks you to make the panes two different colors. You could add the dividing measure (State here) to color, but that would remove the measure already there. What to do? Make a combined field! Add the new field to color, adjust your table calculations, and you're … Continue reading Quick tip – Combined fields
Really happy with a dashboard I built at work this week. Can't share the actual version with you, but created a mock-up with fake data. This data is significantly simpler than the real data source - I've cut unused fields, decimated the number of users, and condensed multiple complex processes into a single straightforward one. … Continue reading Auto-Selecting Users on Tableau Server
Hey! I threw together a quick tutorial on pivoting data for Reddit. If you're interested you can see the Imgur album here: Pivoting Data
I have this standard, boring dashboard that shows details for 1-5 IDs at a time. The data source is HUGE (it takes ~10 seconds to query) and the query would run every time I selected an ID. So, if I needed to look at 100, 101, and 201 the process would look like this: Open … Continue reading How to keep your filters from immediately resetting your query!
This edition of Excel tips I could have used years ago is…...Alt+Enter!