-
1. Re: Show quick filter values in tooltips
Tracy RodgersJul 16, 2013 11:46 AM (in response to Jonathan Whiting)
1 of 1 people found this helpfulHi Jonathan,
You can do this by creating two calculated fields similar to the following: str(min(year([Date Field]))) and str(max(year([Date Field])))
Then, add these to the level of detail shelf. Edit the tool tip and use the Insert button to add these fields to the view, so that it looks similar to:
Date Range: <AGG(min year)>- <AGG(max year)>
Hope this helps!
-Tracy
-
2. Re: Show quick filter values in tooltips
Jonathan DrummeyJul 16, 2013 11:50 AM (in response to Tracy Rodgers)
Hi Tracy, why did you wrap them in STR()? I usually just use Tableau's built-in formatting.
-
3. Re: Show quick filter values in tooltips
Tracy RodgersJul 16, 2013 12:09 PM (in response to Jonathan Drummey)
You can do it either way. I just did it that way to combine steps.
-Tracy
-
4. Re: Show quick filter values in tooltips
Jonathan Whiting Jul 16, 2013 12:20 PM (in response to Tracy Rodgers)It worked like a charm, thank you very much!
-
5. Re: Show quick filter values in tooltips
Tim Quayle Mar 19, 2014 4:39 PM (in response to Tracy Rodgers)This is a nifty trick! I'm wondering why it works for tooltips but not for worksheet titles. When I include the same fields in my title, I get "All - All" rather than the actual date range.
-Tim
-
6. Re: Show quick filter values in tooltips
Jonathan DrummeyMar 20, 2014 4:31 AM (in response to Tim Quayle)
I'm making an educated guess here, since you didn't post a packaged workbook or screenshot of your Tableau window:
The level of detail aka granularity of the Tableau view is made up of the dimensions on Rows, Columns, Pages, and the Marks Card. When you are hovering over a mark, the tooltip has all that dimensionality available. The Title and Caption exist at a somewhat different level, and "see" all the values associated with those marks. When there are more than a few then Tableau shows "All" instead of a specific value, or "x, y, and # others".
You can use table calcs to make really specific labels, what are you wanting to show?
Jonatha
-
7. Re: Re: Show quick filter values in tooltips
Tim Quayle Mar 20, 2014 1:17 PM (in response to Jonathan Drummey)I'd like to depict a very simple bar chart with the filtered range of years dynamically included in the title. For instance, see attached. Thanks!
-Tim
-
Date Range Title.twbx 89.7 KB
-
-
8. Re: Re: Re: Show quick filter values in tooltips
Jonathan DrummeyMar 24, 2014 9:09 AM (in response to Tim Quayle)
Hi Tim,
See the attached. I used TOTAL(MIN(Year)) and TOTAL(MAX(Year)) with a default format of just the year, and a Compute Using of the TYPE. I also changed the Filter from Year to YEAR(Year), so it would explicitly display the year. When you have a filter on a date dimension at a finer granularity than the date format for the filter, you can end up with a situation where the filter will show something just outside the range, like this where the filter has selected a time in 2005 for which there is no data remaining in 2005, so there's only 2006 to 2013 selected and the Title shows that.
Using YEAR(Year) fixes that, so the filter is only selecting years:
Jonathan
-
Date Range Title jtd.twbx 89.4 KB
-
-
9. Re: Re: Re: Show quick filter values in tooltips
Tim Quayle Mar 24, 2014 10:26 AM (in response to Jonathan Drummey)Well that seems simple enough - thanks!
Tim
-
10. Re: Show quick filter values in tooltips
Jonathan DrummeyMar 24, 2014 10:40 AM (in response to Tim Quayle)
You're welcome!