Have you created a data module for the file that you are using?
If you have a data module you can apply a relative date calculation to your data and measures. The calculations are applied and you don't have calculate for each query or dashboard, you just drag the fields into the list, crosstab or visualization.
https://www.youtube.com/watch?v=4lDrF3jx98g------------------------------
Jo Marie Sellner
------------------------------
Original Message:
Sent: Tue January 07, 2020 06:28 AM
From: MONA KEDIA
Subject: YOY growth trend in Visulization
Hi
Have a base file in which I have revenue numbers for past 12 qtrs. I am trying to create a graphs showing historical trend YOY and QOQ growth.
In Cross tab and list I can add the formula and create the same. But not sure how to do same in graphical view ( Bar chart showing revenue by qtr and line graph showing YOY growth.
------------------------------
MONA KEDIA
------------------------------
#CognosAnalyticswithWatson