Bar Chart column order

[Quigwam2058]

I have a bar chart in my report that shows data that has been grouped via a case statement that groups years of service

case when [Personnel Info].[Personnel Detail].[Years in District] <= 5 then '5 years or less'
when  [Personnel Info].[Personnel Detail].[Years in District] between 6 and 10 then '6 to 10 Years'
when  [Personnel Info].[Personnel Detail].[Years in District] between 16 and 20 then '16 to 20 Years'
when  [Personnel Info].[Personnel Detail].[Years in District] between 21 and 25 then '21 to 25 Years'
when  [Personnel Info].[Personnel Detail].[Years in District] between 26 and 30 then '26 to 30 Years'
when  [Personnel Info].[Personnel Detail].[Years in District] > 30 then '31 years and up'
end

I want my bar chart to show the data in chronological order.  Is there a way to sort the chart based on the Years in District field to get this to be chronological, but only show my groups as defined in the case statement?

I need to use the data in my package and not in a dashboard where a data set would be used.

[dougp]

Define "bar chart".  Different visualizations from the different libraries...

11.1 visualizations
11.0 visualizations
Legacy visualizations
Charts

...behave differently.

[Quigwam2058]

This is for a clustered bar chart in 11.1

[MFGF]

This is for a clustered bar chart in 11.1

Hi,

This isn't quite what Doug was asking. When you insert a visualization into your report, there is a dropdown list of visualization engines in the top right corner of the dialog. Cognos Analytics currently has four options you can choose from here - 11.1 visualizations, 11.0 visualizations, legacy visualizations and charts. Each of these charting engines has a clustered bar chart, but every one has different properties and different options in how you can configure it.

Cheers!

MF.

[Quigwam2058]

It was 11.1 Visualizations
Clustered columns

And while I'm asking can these visualizations drill thru to a page within the report?