I want to do a date slider for non-standard date fields. Tableau makes 2001-2002 and Fall 2001 a string. I converted the dimensions to continuous measures and try to make them range values so the user can choose multiple Academic Years or multiple Fall <Year>s without having to check and uncheck them, but only get Null.
The closest I got: I made a calculated field to convert the string to digits -- IF [Academic Year]="2001-2002" THEN 1 ELSEIF [Academic Year]="2002-2003" THEN 2 END -- and I got a slider, but now I need to have the strings be an alias for the digits, because the slider is from values 1 to 2 not 2001-2002 to 2002-2003.
Can I put aliases on the slider, or is there a better way to make a calculated field that will convert the string to a continuous field for the range but will still show the string values?
Using Tableau 9.something
Where did you get 9.something? I've been waiting for that version!
Can you attach a sample of what you are working with and figure out what version you have? It would be nice if you can open the workbook when someone helps you out. It says which version right when you launch the software.