Multiple lines in visualizations

[CognosMarson]

Hi,

I want to display multiple moving averages in the same line visualization, e.g. 3, 6 and 12 months.
The only way I know how to calculate moving average is by creating a calculated measure like this average(currentMeasure within set(lastPeriods(6;currentMember([DateHierarchy])))).
But there is a limit to 1 measure/line viz, with my approach I cannot achieve what I want.

Do anyone have a solotion to my problem?

/CM

[MFGF]

Hi,

I want to display multiple moving averages in the same line visualization, e.g. 3, 6 and 12 months.
The only way I know how to calculate moving average is by creating a calculated measure like this average(currentMeasure within set(lastPeriods(6;currentMember([DateHierarchy])))).
But there is a limit to 1 measure/line viz, with my approach I cannot achieve what I want.

Do anyone have a solotion to my problem?

/CM

Hi,

Version 11.1.6 allows you to add multiple measures to a visualization - it sounds like this is what you need. Are you in a position to upgrade?

MF.

[CognosMarson]

Great, yes I am, thanks for the help!

/CM

[CognosMarson]

Hi,

Version 11.1.6 allows you to add multiple measures to a visualization - it sounds like this is what you need. Are you in a position to upgrade?

MF.

Hi,

Is this something you have tried? I've upgraded to 11.1.6, but I'am not able to add multiple measures to a line chart.

/CM

[MFGF]

Hi,

Version 11.1.6 allows you to add multiple measures to a visualization - it sounds like this is what you need. Are you in a position to upgrade?

MF.

Hi,

Sorry - it looks like you can only do this in bar and column visualizations. I hadn't realised there was a limited set of visualizations that support this - my mistake.

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_new.doc/c_ca_nf_11_1_6_reporting.html#c_ca_nf_11_1_6_reporting

Could you use a column visualization instead or does it have to be line?

MF.