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.
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]))))
(http://i62.tinypic.com/68ei68.jpg)
Hope it will help you
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..
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