Sorting Month In Charts 4.0

[former_member203850]

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

Step 2:

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 :smile:

Regards,

Pranay