Print Page - Filter Year -> Display Year & Prev Year

Title: Filter Year -> Display Year & Prev Year
Post by: Chamopak on 23 Dec 2015 01:36:46 PM

Hi Guys,

I am trying to make an Active report wit Line Chart Visualization.
As Filter component I want to use the Data Discrete Values Slider.

Is there a way that I can let this Display the Year that I have chosen plus the Previous Year into the same Line Chart?

e.g. If I choose 2015, it must display the line for 2015 but also the line for 2014.

Thank you in Advance!!!

Title: Re: Filter Year -> Display Year & Prev Year
Post by: sliptnock on 07 Jan 2016 02:12:21 PM

I have created a measure with the amounts of the previous year.

Title: Re: Filter Year -> Display Year & Prev Year
Post by: b737 on 09 Jan 2016 06:13:54 AM

I have created 2 tuples, first using function member(Year) and second using prevMember(Year) with measure. So when you connect your chart with Data Discrete Values Slider, position on 2015 will be current member and previous will automatically be 2014, that second tuple.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Chamopak on 23 Dec 2015 01:36:46 PM