Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: shivani_cog on 03 Dec 2011 10:06:18 PM

Title: weeks display by selected date start and date end
Post by: shivani_cog on 03 Dec 2011 10:06:18 PM
Hi,
How do you display weeks by selecting start date and end date?
I know about _week_of_year works for this one.
I have created ?Begin_Date? and ?End_Date? prompts.
This is for the bar graph.
When users select start date and end date then week1 or week 2... should display in an x-axis of a bar graph.
Revenue should be aggregated by given week by selected item.

Thanks.
Title: Re: weeks display by selected date start and date end
Post by: blom0344 on 02 Jan 2012 01:58:18 AM
What exactly do you need to know further? By using the calculated dataitem (using _week_of_year) and the revenue measure you can build your graph no problem..
Text only | Text with Images