In my project, I have faced a requirement of sorting month in charts.
Let’s create a simple report to demonstrate this. For this example we will be using two objects. in report
1. Month Name
2. Number of incident
When we create the column chart using above objects as shown below :
Requirement : Sorting Month Name in Chart.
Create a variable in report.
Month_Number:- If[Month]=April Then “4” ElseIf[Month]=May Then “5” ElseIf[Month]=June Then “6” ElseIf[Month]=July Then “7” Else [Month]
Step 1: Assign Data in chart section
Select below values
Hide ‘Month Number’
Step 3: Right click on the chart and select ‘Sort‘ option
Sort -> Manage Sorts ->Add
Add Month Number and select order as Ascending
You can then see the chart output as shown below :
Hope this helps 🙂