How to Sort Graph Days and Months in order

Kristy shared this question 9 months ago
Answered

Hello

How do you within a graph get the dates to sort in order?

I've been unsuccessful in getting days of the week to display in order within 1 graph and days of the month to display in another graph.

we are on version 7.4.10

Comments (4)

photo
1

Hi Kristy,


There are 2 ways to do this. The first is to simply include the full date field in your report as the first column (which will control the sort order of the data) and then hide it. This should give you want you need quickly and works well if your data is a Date format. See the images below as an example:

1. Add date column at the start


173ba707b836f9b9c9d623bbb30faff2


2. Hide this date field from the table

4755b7d6d02e803cc674d284b4aae88a


3. Your dates should be sorted in order on your report


18898abf98cd865bef15f84a46cdb047


The other option if your Months/Days data are in varchar format, is to setup Org Ref Codes which allow you to create a custom sort list. This guide will help with setting these up and adding the custom sort. The Description is the name that will appear on the report so you can change January to Jan or similar if you wish as well.


Please let me know how you do with this and if there is anything else I can help with.


Cheers,

Neal

photo
1

Thank you Neal

photo
1

Hi Kristy,


Glad I could help. Is there anything I can do for you on this?


Cheers,

Neal

photo
1

no thank you that's all :)