6 Replies Latest reply on Dec 18, 2013 4:46 PM by ryan.gamble

    A calculated filed has been replaced by Calculation causing list of warnings

    katarzyna.kaczmarek.0

      Hi everyone,

      I have a strange problem. My calculated field has been replaced by Calculation_nnnn(numbers) which is giving me a list of warnings every time I open my workbook.

       

      I will describe my problem in details:

       

      I have a dimension describing data in a format YYYY-MM. I created a calculated date filed by:

      DATE

      (

      LEFT([YYYYMM], 4) + "-" +

      RIGHT ([YYYYMM], 2) + "-01"

      )

      This has been working for me for a couple of days. Today when I opened my Tableau workbook

      1) Firstly, I got a list of workings:

       

      Ignoring calculated field '[Calculation_3470704145357471]', field is already defined by data source.

      Ignoring bin '[FIELD2 (group)]', field is already defined by data source.

      Errors for 'FIELD1':

      Ignoring calculated field '[Calculation_3470704145357471]', field is already defined by data source.

      Errors for 'FIELD1':

      Ignoring calculated field '[Calculation_3470704145357471]', field is already defined by data source.

      Errors for 'FIELD2':

      Ignoring calculated field '[Calculation_3470704145357471]', field is already defined by data source.

      Ignoring bin '[FIELD2 (group)]', field is already defined by data source.

      Errors for 'FIELD2 legend':

      Ignoring bin '[FIELD2 (group)]', field is already defined by data source.

      Errors for 'FIELD3':

      Ignoring calculated field '[Calculation_3470704145357471]', field is already defined by data source.

       

      2) Secondly, I saw my DATE filed replaced with some strange Calculation_3470704145357471 field!

       

      My Questions:

      A) Do you can what the reasons for the warnings are?

      B) How I can get my DATE filed back and get rid of Calculation_3470704145357471?

      C) How can I avoid this problem in  the future?

       

      Thank you for your help in advance,

      Kate