
Hi all,
I am very new to Tableau and after searching all morning, I still can;t figure what to do. So some tricks and hints would be very helpful!
Issue:
I have for certain activities a start and end date.
For 1 specific activity, for which I made a calculation, that returns me ** for the top level. The other activities fall under that top level
Now, I want to be able to filter out of my start dates the activity where the value is **. Even better, the start date should show TODAY because if I take a time window to return me all activities within the last 3 years, the false one would not be shown as there start date fall out of 3 year date while other activities are still ongoing.
And this calculation gives me true instead of giving me today if there is a ** value.
thanks for any help!
Goedemorgen Inneke,
Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread
1. D1. Startdate adj.if [test Stid]="**" then today() else [startdate] END
2. Drag the required objects to the indicated locations
Regards,
Norbert