If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Add Multiple Categories in Line Chart

Started by karan27, 12 May 2015 10:51:40 PM

Previous topic - Next topic

karan27

Hi Guys,

Just look at the Snapshot.
I wants line chart in which Y1 as Job count and Series Year (In which Year in which month how many job counts with different colors)
X- axis Hire-date (Month).

Now can any one help me with how to add year in line chart with different style and color as shown in Snapshot1

Snapshot1. Scenario (Sample Image)

Snapsjhot2. I have tried the Task and Stuck here.

TheFrenchGuy

#1
Hello,

in which kind of data you base your report ? Relational package ? Dimensional one ?
I did a job like you need in dimensional, and I created 1 data item per Year in Y axis:
_Year N :
total([Net Sales (local curr.)] within set periodsToDate([Daily Cube].[Time].[Year-Month-Date].[Month],currentMember([Daily Cube].[Time].[Year-Month-Date])))

_Year N-1 :
total([Net Sales (local curr.)] within set periodsToDate([Daily Cube].[Time].[Year-Month-Date].[Month],parallelPeriod([Daily Cube].[Time].[Year-Month-Date].[Year],1,currentMember([Daily Cube].[Time].[Year-Month-Date]))))




Hope it will help you

karan27

Thanks for replying...

It is Relational package.

i have uploaded new edited snapshot, hope this will give you more clear picture what i am trying to do.

Thanks in Advance..



srmoure

I have a similar issue. In Cognos 10.2.1 I was able to add nested categories into the charts. e.g. Year and then Month.  In CA 11.1.2 I can only add the second category (e.g. month) next to the first one (year) , but not below.  Not sure if this is a bug or there is a trick to do it.
The only was is to create the chart in Cognos 10 and then import it into CA11