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.
Define "bar chart". Different visualizations from the different libraries...
11.1 visualizations
11.0 visualizations
Legacy visualizations
Charts
...behave differently.
This is for a clustered bar chart in 11.1
Quote from: Quigwam2058 on 02 Feb 2023 07:48:14 AM
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.
It was 11.1 Visualizations
Clustered columns
And while I'm asking can these visualizations drill thru to a page within the report?