2 of 2 people found this helpful
Create a new sheet to show on your dashboard. Then create a calcuated field with the following inside
Then drag to your rows shelf. Right click and "Hide field labels for rows". Then right click and Format sheet. Click Borders and select None on both Rows and Columns.
Then drag to your dashboard. Hope this helps.
You could also drag it to a level of detail - then you can use it in the title.
Thank you Derek and Alex!
I added TODAY() into a worksheet and I drag it into the rows shelf. Where am I right clicking afterward?
1 of 1 people found this helpful
Right click above the actual date in the worksheet, where it says Month, Day, Year of Today. Then select Hide Field Labels for Rows.
Also if you didn't know how to get the date to show "November, 9, 2012" follow the steps below.
When you drag "Today" to the Rows shelf it should automatically be set to YEAR(Today) which is why only "2012" appears.
Hover your pointer over the YEAR(Today) blue pill until you set the little drop down arrow. Click it then navigate to "Custom" like is show in the image above and click.
A pop-up dialog box will present you with some options. Just click the drop down and click on the Month / Day / Year option.
You probably already knew this though. Let me know if this helps or not.
Cool... I'm updating some dashboards with that little tip right now.
You're actually kidding me, right? I can't just plug the today() function directly into a title, text box, caption, etc? Like every other language, BI tool, etc? Why does Tableau have to involve quantum physics to solve a simple addition problem?
Its not; you just have to create a date parameter on a new worksheet or the worksheet you are using to create the dashboard and use that parameter in the text box on the dashboard. If you want the parameter to show today's date leave it be or you can show the parameter on the worksheet and change the date there.