Hello,

I am working on a dashboard in Cognos 11.1.4 to display active student statistics for a specific date as chosen by the user.

I would like to display two graphs side by side with one graph displaying the stats for a date as chosen by the user and then the second graph would automatically update with the same day but one year earlier.

Currently I have two graphs each with their own date filter that the user would have to chose the date for each graph separately.

I have used the following calculation to calculate the date for the previous year, but I am unsure how to pass the calculated date to the second graph to be filtered.

_add_years ([Foundation Objects View].[SY_ACTIVE_STUDENT_STATS_TA].[RUN_DATE], -1)

Does anyone know of a way for doing this?

Thanks.

------------------------------
Roxane Meachem
------------------------------

#CognosAnalyticswithWatson

Hi Roxane. If you have access to the data module, you can use  the calender/relative time functionality. Once you added this to  a measure, it automatcally creates a data item for priorYear, priorMonth and so on.  

Records Jens

------------------------------
Jens Bäumler
Senior Consultant and Trainer
Apparo Group
------------------------------

Hello, 
as Jens mentioned in previous comment - relative time dimension Is the solution. IBM released a good tutorial how to work with this feature in data modules on YouTube - https://youtu.be/4lDrF3jx98g

------------------------------
Jiri Smrz
------------------------------