I have tried to create a calculated filed as mentioned in the article but I am not getting TRUE to select. I have only FALSE.
Please advice why I am not getting
“Days to Show” field shows false when the date is more than 7 days from the last date.
You can obtain the "True" option by reducing the days from the last date.
Is is what you were looking for?
My date field name is RaisedDate. So as per article I tried creating
calculated field as RaisedDate = Today()-1
Then I added this to filter shelf to select True as per article. But I am
having only False there and no true to select. What should I do. Please
On Feb 22, 2016 5:09 PM, "Lénaïc RIÉDINGER" <firstname.lastname@example.org>
Friends any suggestions please
Hi Vijay, I have an idea:
In your image, I see that you have full dates written out ("February 1, 2016" etc). It could be that Tableau is treating these as strings (you can check by right clicking on your RaisedDate field, and choosing "Change Data Type" to see what's checked).
If so, then the calculation evaluating whether a given string is equal to Today() - 1 is likely not going to be true, which may be why you're seeing only False as an option in the filter for your calc. I'm guessing that in the calc you wrote date([RaisedDate]) to get it to work because it was a string.
If this is the case, you can convert the field to a date, possibly with dateparse(). Then you should start to see a Relative format for the filter, and the Today() - 1 filter should start showing True.
Hoping that helps, it's just a guess!