Skip to main content

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.

how to combine string and 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.

 

pastedImage_3.png

 

thanks for any help!

3 个回答
  1. 2018年2月5日 12:31

    Goedemorgen Inneke,

     

    Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread

     

    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.

     

    1. D1. Startdate adj.if [test Stid]="**" then today() else [startdate] END

     

    2. Drag the required objects to the indicated locations

     

    pastedImage_1.png

     

    Regards,

    Norbert