2 of 2 people found this helpful
I could not open your file because it references a data source that is not included - you would need to export a packaged workbook to include the data
That said - what I would suggest is to
- create a "Sort Field" like you did with semester order
- drag it to your rows shelf in the first position
- then hide it by right clicking the pill and clicking on hide
The data will remain sorted but the sorting field will not show
Let me know if that worked for you
Thank you for the quick response, that's exactly what I needed. I was missing the fact that I could hide the sorting field.
What you suggested worked for me but created another issue. Tableau isn't reading my data as time series data so I cannot use a line chart. Ideas on how to use a line chart? I tried converting some fields to date fields and that didn't seem to yield the results I wanted.
LERTS.twbx 75.8 KB
1 of 1 people found this helpful
Thanks - Glad to help
Joped to avoid making a date out of the data
The fields that you have are strings and not date fields - if you are pulling the field from another source (like excel or SQL) you could convert it to a date at the source in the form of mm/yyyy. If not you will need to convert it to a date field in Tableau - e.g., if your field name is date and the value is "Spring 2011" you could use a formula like for the year like Year= Year(right([date]),4) and for the month you could use Month= If Contains([date, 'Spring') Then 6 else 9 End
You then would make the date with Makedate(Year,Month,'01' )
Now you have a date field that you can use for sorting or other calculatons
Does that help?
Thanks Jim - both answers you provided were quite helpful. Thanks for the quick responses, the easy to follow directions and for helping me out - it is all very much appreciated!!!
You are welcome - my wife is a retired teacher so whenever I see anything that has to do with schools it get my attention