I have created a query that shows the date of ticket activities but the results are not showing in chronological order. For example my x-axis on the bar graph shows December 2019 after January 2020. The dates and data are out of order.
For data to be presented in chronological order, date attributes must be listed from longest to shortest. The longest period of time, for example year, must be first in the list of attributes in the Columns or Rows list, above the shorter period of time, for example month.
The order should be : Years > Months > Weeks > Days.
As shown in the example below, the order in which Tickets created - Year and Tickets created - Months are listed in the in the Columns list affect how the data is displayed.
The Month attribute is listed first, above the Year attribute.
The Year attribute is listed first, above the Month attribute.