Hi 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

Hi Tracy, why did you wrap them in STR()? I usually just use Tableau's built-in formatting.

You can do it either way. I just did it that way to combine steps.

-Tracy

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

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

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

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

Well that seems simple enough - thanks!

Tim

You're welcome!