Sort Schedule Chart by Start Time (X Axis)

[rgreen33]

I using Viya Visual Analytics 8.5.2.  I am working with a Schedule Chart.  I have the following:

• Task:  processName
• Start:  startTime
• Finish:  endTime
• Group:  status
• Data tip values:  processName, startTime, endTime, duration
• Hidden:  startDate (I added this so that I can have a slider to look at data one day at a time)

By default, my Schedule Chart is being sorted by processName.  I would like to be able to sort by startTime.  However, when I attempt to change the sort, I only have the following options:  processName: Ascending; processName: Descending.

Does anyone know how I can accomplish this?

Thanks,

Ricky

[irinna · Accepted solution]

Hi

You can do it by modifying the XML (CTRL + ALT +B in the report). There you will find in the data definiton a line for Sort Items. Change the one from processName to the starttime one (use the name ref). The easiest way to identify where to change is if you create a new report, add only the schedule chart, go to the XML and look there for 'ascending'. That how you find the part that you need to modify. Change it to the name ref you need and reload the XML.