Chart display sort order in adhoc chart view

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

While creating ad-hoc chart views in Advanced reporting the sort order for the charts displayed appears to be controlled by the system in some alphabetical order and not finding an option to control that in the ad-hoc view creation window. 

Is there some option to customize the sort order?

Environment

Clarity PPM 15.8.1 and Jaspersoft Server 7.1

 

Resolution

There is no configuration/setting to adjust the sort order on chart displayed on adhoc views created in chart view. This is a limitation in Jaspersoft ad-hoc view editor interface.

Because charts and crosstabs both work with summarized data, one can sometimes change the chart display by switching to crosstab view and making the correct selection there. For example, one can often change the sort order in a chart by switching the view to crosstab, making the sort selection that is desired, and then switching back to chart view.

Additional Information

Jaspersoft documentation reference.