Tableau - Tableau Functionalities :: Creating a Table
In my data, the period field is showing the year and month separately, how to fix it, as while applying the formula in the create calculated field it shows error.
Period showing like - 201,601 And in the Create Calculated Field - This Calculation Contains errors {LEFT is being called with (integer, integer), did you mean (string, float)?
Period showing like - 201,601 And in the Create Calculated Field - This Calculation Contains errors {LEFT is being called with (integer, integer), did you mean (string, float)?
3 answers ( 0 marked as helpful)
Hi!
I'd suggest you to make the fix in Excel. Format the data accordingly and then upload it in Tableau.
Best,
Ned
The LEFT function calls for a string as it's first parameter, thus you have to ensure that in the 'Data Source' tab, the 'Period' column properties are formatted as a string. I have encountered the error too because it was originally formatted as a value.
The LEFT function calls for a string as it's first parameter, thus you have to ensure that in the 'Data Source' tab, the 'Period' column properties are formatted as a string. I have encountered the error too because it was originally formatted as a value.