Have a look Here, You need a parameter and a calculated field to do that. Please see attached and Screenshots.
If This Helps, Pl mark it Helpful and CORRECT to close Thread
selected and Previous.twbx 20.8 KB
Your workbook example is showing blank worksheets for me, and I think it
has something to do with the Date dimension that you created... I tried
using that exact formula but Tableau is giving me an error.
Can you double-check on your Date parameter and let me know that is
correct? I could be doing something wrong with the data as well...
On Tue, Apr 17, 2018 at 12:33 PM, Deepak Rai <firstname.lastname@example.org>
Your date was in different format so I created another Calc to add The Day to it and thus it worked fine. What is your Datasource?
The main issue is that the calculated date fields in your workbook example
provide the incorrect date. I think it is syntax related. See below for
It adjusts the date to be 1/16/2001, when the intention is obviously to
make that 01/01/2016. I think if this can be adjusted, then the solution
My datasource is a much larger, complicated data set out of Redshift. But
for the sake of this exercise those are the two fields that are of concern.
thank you very much for your assistance with this!!
On Tue, Apr 17, 2018 at 1:46 PM, Deepak Rai <email@example.com>
image.png 95.1 KB
Haha I figured you probably did something write to get the correct solution!
I have to adjust the date code on my end to make it work, but the solution
should work at that point. Thank you for your time and assistance on this!
On Tue, Apr 17, 2018 at 1:56 PM, Deepak Rai <firstname.lastname@example.org>
Great!!! Please Close The Thread by marking my Reply as Helpful and CORRECT. The CORRECT button is in your main Thread under my Reply, not in email.