COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 18 May 2014 06:19:01 PM

Title: Showing the Last Month's Data on a Line Graph X-AXIS (Dim. H.) Report 10.1.2
Post by: gosoccer on 18 May 2014 06:19:01 PM
Folks,
I have a line graph and it is working based on a Query that returns the last month's fact table. I was curious what would be the best DATE item to drop for the X-AXIS of the line item that shows a month as date X-AXIS Listing?
For example, the following is what I'm dropping in the X-AXIS and the entire
Quarter,

Quote[great_outdoors_company].[Years].[Years].[Quarter]

Is there a better way to do this?

If you have any examples, I would greatly appreciate it.