2 Replies Latest reply: Nov 25, 2014 8:41 AM by Kash Jani RSS

    Sorting by a different column on bar chart

    Kash Jani

      Hello

       

      I have a bar chart which shows a count of a number (some issues that we have in business) on Y Axis by Month and Year on X Axis.

       

      The month & year is derived by a date (Issue start date) during the script load and this month & year is shown on x axis. I would like to sort the bar chart by the original column (Issue Start date) rather than the derived column (Month & Year).

       

      I have been trying to sort the chart using the Issue start date in the expression field of Sort tab but it doesn't seem to work. If I'm able to do this then the chart will be properly sorted by issue start date and so will be the derived column on the x axis.

       

      Any help will be great.

       

      Many Thanks