Cognos ver 11.2
I have a Line chart to show the trend by months.
X-Axis - Months
Y-Axis - Measure
Color - Business Units
So it creates 4 lines , one for each Business Unit and shows the trend by Months.
Here's the problem:
For the month of Feb, Mar, Apr, 3 Business Units have almost the same data.
Business Unit 1 - Value is 99.5
Business Unit 2 - Value is 98.9
Business Unit 3 - Value is 100
This results in 3 lines to be on top of each other and it's difficult to see them separately.
I want to create a separate Line chart for each Business Unit but I cannot do that individually because the upper level
for Business Unit has a drill down so when we drill down, that's when it should create 4 Line Charts dynamically. I remember
in version 10, you could create a Pie Chart which used to create a separate Pie for each category.
Is that possible for Line Chart?
Thanks a lot !
The combination chart seems to work for this but they show the bars also which is not ideal for this