Skip to main content
Topics#Tableau Desktop & Web AuthoringPregunta de Rishi Saka
Rishi Saka (TCS) preguntó en #Tableau Desktop & Web Authoring
25 ene 2020, 07:52

string and date in a if function

Hi all,

 

I have a question regarding a conditional calculated field -

If I want to write

 

({Fixed [CASEID] : Min(if [Field_Name] ='resolution' and Date > 01-11-2011 then [New_Val] end ) }

 

The above docent work - since it has a string and a date function in a if statement - so I converted the date to a string and then added it in the calculation which worked.

 

I would like to know is that a correct approach?  Is there a alternate approach?

Please advise.

 

Regards,

RS

3 respuestas
  1. Soumitra Godbole
    25 ene 2020, 09:27

    Hi Rishi,

     

        I was able to do what you mentioned but had a very slight modification to what you have.

    I simply added a date formula before the value and formatted it as yyyy-mm-dd and it seems

    to work.

     

    { Fixed [CASEID] :

      Min ( if [Field_Name] ='resolution' and [Date] > Date ( "2011-11-01" )  then [New_Val] End ) }

     

    Let me know if the above formula works for you. Best Wishes !

     

    Sincerely,

     

    Soumitra

Escribir una respuesta...
0/9000