Cognos 10 Report Studio: Add more series to a chart

How to add more series to a chart? This is something I didn't remember and couldn't find right away, therefore I share it here.

In this example I have combination line chart and some dummy data (pics 1, 2 & 3). I want to compare number of errors (m_errorcount) in different years and months to the target line.

Pic. 1. Combination chart.

Pic. 2. Measure, categories and series added.

Pic. 3. Chart with data.

Generally there is only one series box where to drop item. I need to add another for target line data item. (See pink spots in the next pictures.)

[1] Click combination chart object and go to Properties > General. In a Combination line click three dots to see options.

Pic4. Combination chart properties.

[2] Click Add-icon and choose type of element you want to add.

Pic. 5. Combinations options, add new.

Pic. 6. Types of combination element.

[3] After couple Ok clicks, you have another element in the series box where you can add second data item (Pic.7). Last picture (Pic. 8) shows result of the example chart.

Pic. 7. Additional series.

Pic. 8. Result.

Cognos 10 Report Studio: Every second axis label missing

I made a simple vertical bar chart that I changed it to horizontal so that axis labels would be easier to read. Some of the labels were quite long and I had manually set break after 200 characters. That way whole label would be shown. But changing chart to horizontal, I lost every second axis label!

I read cognos help troubleshoot about labels but it wasn't so clear what I need to do with my report. I share my solution here if somebody has same problems with the labels. Again, texts in the pictures are in Finnish but I wrote instructions also in English.

[1] Go to axis labels properties and set options so that you don't allow skipping but either rotation or stagger is allowed. I chose to allow stagger:
Allow 45 Degree Rotation / Salli 45 asteen kierto --> No / Ei
Allow 90 Degree Rotation / Salli 90 asteen kierto --> No / Ei
Allow Stagger / Salli porrastus --> Yes / Kyllä
Allow Skip / Salli ohitus --> No / Ei

Axis properties - labels options

In my case this wasn't enough because I had set size to the chart and there wasn't enough space for the labels. First I tested it so that I took away all the chart size settings but it didn't help. (I didn't make any changes to the report page settings.) But I find the solution:

[2] If the first step didn't help yet, set the size of the chart big enough for the labels. I needed to set chart height to 600px and after that all the labels appeared.

Size and overflow / Koko ja ylivuoto

Cognos 10 Report Studio - Adding secondary value axis to the chart

This example shows, how to add secondary value axis to the chart in C10 Report Studio. For example in this bar chart 'revenue' and 'profit margin %' measures can't use same axis (Pic.1.)




Pic.1

Cognos 10 Report Studio - Format tooltip values

I show tooltip in a chart but measure value is too precise, like 1,629387. I want to show only one decimal. So, here are steps how to modify that tooltip value:

[ 1 ] On the chart Series / Sarja box, click measure text
[ 2 ] Go to  Properties - Chart Node Member / Ominaisuudet - Kaavion solmujäsen
[ 3 ] Click ellipsis (...) in the Data Format / Tietomuoto section to open properties and modify format of the measure as you like.

MS SSRS - Sorting chart axis labels

In the beginning I had difficulties to remember where to find sorting options for the chart axis labels. Clicking around chart area and checking properties got to my nerves but then I decided to write it down for the future and then I begin to remember. I thought this would be useful post to some others too. In this example I add sorting to x-axis "finished_month".

[ 1 ]   Click over x-axis labels so that x-axis category field is seen
[ 2 ]   Right-mouse click open  Category Group Properties and add sorting.
 

x-axis labels - sorting

Notice...

[ 3 ]   It doesn't show anything at Chart Member Properties: SortExpression box. You have to click it open to see the sorting options for that Chart Member.