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
Quote from: CognosMarson on 07 May 2020 05:31:28 AM
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.
Great, yes I am, thanks for the help!
/CM
Quote from: MFGF on 07 May 2020 07:16:44 AM
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
Quote from: MFGF on 07 May 2020 07:16:44 AM
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.