1 of 1 people found this helpful
Try combining the months and years into one column in Excel. So instead of a separate column for months and a separate column for years, create one column that reflects both the month and the year (10/2015, for example).
Tableau considers and reads the fields as separate as you understand it. So either you need to manipulate your source for tableau to read it or you would need to write a calculated field by combining the date and month.
Good Luck with data,
Could you give an example of a calculated field that would result in a date like you mention? I assume it's some sort of DATE() or MAKEDATE()
I have a table with combined month and year:
KPI 01-01-2017 01-02-2017 01-03-2017
KPI1 1 2 3
KPI2 1 2 3
KPI3 1 2 3
Excel converts view of 01-01-2017 into Jan-17 (but the value is 01-01-2017)
Tableau does not recognize names of the columns as dates but as text. Hence sorting chronologically is not working
How to set up excel dates so tableau recognizes or what to do in Tableau?
I would really appreciate answer.