I have a solution that is more of a workaround. Since the titles can reference only the fields on the dashboard, you need the date in the Viz in order for you to reference it. However, if you put the Date field on the tooltip shelf in the worksheet, you can then reference the field in the title of the dashboard. I've made those changes to the attached workbook - take a look and see if it makes sense.
Thanks and hope that helps!
Book1.twbx 10.9 KB
Great job !
It works fine.
how may I change Date format (i.e. instead 3 feb I'd like 03/02/2016) ?
1 of 1 people found this helpful
However, this breaks part of the last workaround. I was able to get something similar by expanding the date field to show Year, Month and Day in the worksheet and then changing the title of the dashboard to use the terms: <MONTH(Date)> <DAY(Date)>, <YEAR(Date)>
You can probably play around with the formatting to get it to display what you want.
Hope this gets you on the right path!
Hi Nathan !
A little upgrade on this issue.
As I saw, your workaround works right if all dates are the same.
But if in the Data column there is even one value different from others like this :
In the dashboard title isn't showed any date (i.e the first (05 Feb) or the last (12 mar) but this:
"All" is showed even if I choose in the Tooltip shelf the min or max value of Date.
You can see the issue in the attached workbook.
Thanks in advance
Book1.twbx 6.4 KB