Afternoon all,
I am working on establishing the data for a dashboard. When I bring my data into Tableau I have two separate fields - one for the year and one for the month.
Tableau interprets both of the fields as a "double-precision floating-point number"
I have tried to figure out a way to transform these fields into a date so that I can use them as an axis on a line chart.
The YEAR displays what looks like a normal year when it is unaltered = 2015, 2016, 2017, 2018. When I try to convert the YEAR into a DATE data type, Tableau shows me one column = 1905
The MONTH is based upon a fiscal month so it shows:
Month 1 = 2
Month 2 = 3
Month 3 = 4, etc.
Therefore I have to write a case statement that says:
CASE [MONTH]
WHEN 2 THEN 10 - This is the first month of our fiscal year or Oct
WHEN 3 THEN 11 - Nov
WHEN 4 THEN 12.... - Dec
END
I have also tried a DATEPARSE as well.
Any of you have any ideas on how I fix this so I can see = 10/2017, 11/2017, 12/2017
Thank you,
Scott
