0 Replies Latest reply on Oct 12, 2018 2:17 AM by Patrick Weber

    Calculation with datepart works but exclamation mark on data source sheet?

    Patrick Weber

      Hi everyone,

      I am using a sql server connection and in one table there a log dates as string which are not automatically recognized if I try to change the data type into date or datetime.

      If I do so then nearly everything will be shown as null.

       

      I created an extract in order to get the function dateparse which is usually not supported by sql server.

       

      When I created the calculation "Calc1" there was no error inside the calculation but if I change to the sheet "data source" in Tableau I see an exclamation mark for "Calc1".

      The further description says that the status is invalid!?

       

      12-10-_2018_10-05-25.png

       

      Does this information occurs because I'm using dateparse? Or maybe because the column "Log" has a few entries which aren't dates?

       

      I tried to create a small example workbook but in this test case no problem occurs.

       

      It's strange because I can use "Calc1" as  filter without any issues so I don't understand why Tableau has a problem with this calculated field.

       

      Did anybody have this issue too?