CODEWITHSUNDEEP
tableau-api
hamsy
hamsy

Reputation: 369

Max date available in data to title

I wanna put the latest date available in my data to the title. I created a calculated fild max(date). However, it's stuck in measures and not available in the menu when I choose insert in the Title menu. Any other ideas how to handle this? Thanks!

Upvotes: 1

Views: 5678

Answers (5)

Robert Crocker
Robert Crocker

Reputation: 678

To get the max date from your dataset you'll want to avoid using FIXED, INCLUDE, or EXCLUDE. The curly braces by themselves will get you what you're after.

enter image description here

Add that calculation to the detail shelf of the marks card so it's available to you in the title.

<example>

Once selected you'll see the max date of your dataset in the title.

enter image description here

Remember, it won't be available until you add it to your view.

Hope that helps!

Upvotes: 1

scmz
scmz

Reputation: 187

In my case this issue came up when working on a dashboard and none of the other answers helped.

Create a new worksheet to use as the title in your dashboard.

In the new worksheet, create a new calculation Max([Date]) and drag it to the Text mark. Then click the Text mark and then click the ellipses, and insert the Max([Date]) into your title. Then make sure to hide your worksheet's title by clicking the 'More Options' arrow and clicking 'Title'.

Here is a tutorial to help illustrate.

Upvotes: 0

hamsy
hamsy

Reputation: 369

What actually helped to solve the problem is to use LOD. So my calculated field now looks like: {FIXED: MAX(date) }

Upvotes: 1

Prem
Prem

Reputation: 11955

With this approach I assume that you wanted to add last refreshed datetime to Title. If yes, then you just need to double click on Title and then in Edit Title window click on 'Insert' to select Data Update Time. Content of Edit Title box can be like -

<Sheet Name> refreshed at <Data Update Time>


Now to answer your specific question - I would recommend to create a calculated field max_date as lookup(max([Date]),0) and drag it to 'Detail' Marks. Right click it and select MDY format. After this you should have max_date field in 'Insert' option of Edit Title box. Hope this helps!


Don't forget to let us know if it solved your problem :)

Upvotes: 1

Ben P
Ben P

Reputation: 3369

Make another calculated field to convert your MAX date into a string: STR([Calculation1])

Then you'll be able to add this field to your worksheet title.

Upvotes: 0

Related Questions