If your date field is a true date datatype (I'm guessing maybe not with that formatting), then the graphs are simple because Tableau will default to Year for your dates.
So the steps are :
- check that your date field is a Date datatype (check just to the left of the field name - is there a calendar icon or a text icon ?)
- if it's Text, create a calculated field and use the DATE functions to make it a date.
- create the graph you're after
Let me know if you need more information on these steps, but attaching your data as an Excel/CSV file would really help
Thank you for your reply.
I had solved the date issue using this formula i found on one of the forums. date(left([Time Period],3)+"/1/"+right([Time Period],2)). and yes the new date column does have the calendar sign. So when I drag this col to rows it becomes year(Date) which is good but the bars below should not be below as the numbers were not equal in both years. Unfortunately it company data i cannot share, Do you have any recommendation why this would be inaccurate?
Check what measure you are using.
The data doesn't need to be your real company data, just a good example/proxy.
Sure I have created a sample data set for your reference. Could you please tell how to attach it here ?
1 of 1 people found this helpful
Sure, when replying click on the "Advanced editor and add an attachment" link on the top right of the reply box. Then you can add an attachment
Thanks a lot for replying. I redid all the calculation in excel manually to understand why the numbers were not changing, it turns out I need additional data sets from my end. My bad. Thanks a lot for your time!! Really appreciate the quick esponse.