How to customize/sort field on the Domain Axis in Sum Numeric Field in Data Plane Report?

[Teja]

Hi,

I have generated a report which will show Fix Version/s in X - axis but the list is not in chronological order how to do that using Customizer Script?

   Any help would be appreciated. 

Thanks in advance.

[Tarun Sapra · Accepted solution]

Hello @Teja

You have to customize the chart to have this feature, basically mention the "ordering" of the domain axis.

Please see here - http://www.arsenalesystems.com/docs/display/dataplane/Customizing+Charts+and+Data+Series

From the docs

In the following example, instead of ordering domain categories by default using the magnitude of the numeric result, issue types "Epic" and "Story" are moved to the top of the chart by explicitly specifying sort order:

customizeChart {    category "Epic" order 1    category "Story" order 2    category "Bug" order 3    category "Technical task" order 4    category "Task" order 5    category "Feature Request" order 6    category "Documentation" order 7}

[Tarun Sapra]

Since you are using "FixVersion" thus you can also use "regex" instead of actual hard-coded values.

[Teja]

Hi @Tarun Sapra,

I have been trying to find example using "regex" but could not able find any where.

customizeChart{

axis "domain" title "any text"

}

from the above script, I can able to change x -axis name but could able sort..

Do you know more examples on regex?

Thanks

Teju

[Tarun Sapra]

customizeChart {    category ANY order 999          // set the default order of all categories to a max value 
   categoryRegex ".*Task" order 1  // then order all issue types whose name includes "Task" first
}

[Tarun Sapra]

Please go through all the sample on the link which I have shared with you.

[Teja]

Sure, Thanks lot.

[Tarun Sapra]

If it works for you, then please upvote/accept answer so that others are helped as well.