9 Replies Latest reply on Dec 20, 2017 8:00 PM by Shinichiro Murakami

    Sorting a Date that is a string (from a parameter)

    Vikash Karra

      Hello - have a dashboard that lets a user select how they want to view a graph (i.e. at the year, quarter, week, month, day level). What is displayed is a calculated field (i.e. i had to format the dates based on the parameter value selected). My issue is that the sorting is out of whack. I.e. i don't want to sort a month alphabetically, etc. Attached is the dashboard and as always, any help would be appreciated

       

      if you take a look at the 'sessions' worksheet, you'll see that it's sorted by the day of the month (and not the month itself).