Months displaying in the wrong order on dashboard.

473
1
10-24-2018 12:48 PM
CharlesQuadrini
New Contributor II

How do I order dates by chronological month and not alphabetical month?

So, we have a dashboard, where I track when my truck crosses a boarder. We have a report that tracks crossings per month. I can filer my report by start date and by end date. I then represent that data in a bar chart by months.

However, the data is graphically show with April first and September last, instead of January to December. How do I fix this?

Tags (1)
0 Kudos
1 Reply
EricShreve
Occasional Contributor II

Charles,

You could change the domain to represent a numerical value and then change the alias to represent each month, such as (1 = January, 2 = February, etc).

0 Kudos