Category: Tips

Index Sort Order

Index Sort Order

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

Advertisements
Quick tip – Combined fields

Quick tip – Combined fields

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

Auto-Selecting Users on Tableau Server

Auto-Selecting Users on Tableau Server

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

How to keep your filters from immediately resetting your query!

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!