Using FIXED Level of Detail expressions to convert the aggregate measure into a dimension.Converting the discrete KPI into numbers that can be used as a continuous filter like IF SUM() > 10000 THEN 1 ELSE 0 END, then filtering for 1.Using a LOOKUP() calculation as described in the table calc section above.Brushing/highlighting via the Color Legend.There have been a few workarounds for this by: In version 9.1 and earlier if I try to filter to see only the Arrr! circles to find the money-losing stores, I can’t drop the KPI pill onto the Filters Shelf: I’ve set up a KPI with the following formula: IF SUM() > 5000 THEN Here’s an example where I’m looking at Sales & Profit in my pirate-themed shops in New England. Discrete pills based on table calculations such as LOOKUP(SUM() >10000, 0) are supported.Discrete pills based on regular aggregates such as SUM() > 10000 have not been supported.Discrete pills based on dimensions and record-level calculations like > 10000 are supported.Up through v9.1 Tableau will happily put any continuous (green) pill on the Filters Shelf, but when it comes to discrete (blue) pills Tableau’s behavior has been inconsistent. ( Francois told me I’d get pie charts for Christmas if I didn’t put this warning here.) The Problem NOTICE: This is a discussion of beta software and as such the described features and functionality are subject to change or complete removal prior to actual release. Feature Geek: Filtering by Discrete Regular Aggregate Pills in v9.2 This entry was posted in Feature Geek, Tips and Techniques and tagged 9.2, color, colors, label, labels, mark labels on Novemby Jonathan Drummey. Let me know about the Tableau 9.2 New Features training with Jonathan Drummey and DataBlick Sign up below to get more info when the course is available! Roughly two weeks after the public release of Tableau 9.2 I’ll be doing an online training on all the new features in Tableau 9.2 Desktop – this post is a sample of what you’ll be seeing in the course, a combination of how the feature works, where the edges are and how you might use it. Here’s the coloring labels workbook on Tableau Public so you can see it out for yourself, and download if you have the 9.2 beta (if you want it check with your Tableau sales rep). I regularly have line charts where there are a few reporting units with the group performance, this will help users make the connection between the labels and the lines. The algorithm isn’t perfect, Chamomile & Decaf Irish Cream in particular are too light on the Area chart, there’s a bug with transparency and Area marks in the beta, and this is essentially v1.0 of this new feature so we can look forward to some improvements over time. Here are some additional charts, notice how the Darjeeling label is a lighter green on a white background and a darker green when it’s over the light green Darjeeling mark: For legibility Tableau is applying an algorithm to alter the label color based on where the label is in relation to the mark. In the scatterplot view above the mark colors and labels pretty much look like they match, but they aren’t quite exact. To turn this on, check “Match Mark Color” in the Label Shelf->Font options: This is the second in a series on new features in Tableau 9.2, if you’re really into this I’ll be doing a training on Tableau 9.2 a few weeks after the software is released, more information below!Ī new feature in Tableau 9.2 is to make label colors similar to mark colors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |