If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

weeks display by selected date start and date end

Started by shivani_cog, 03 Dec 2011 10:06:18 PM

Previous topic - Next topic

shivani_cog

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.

blom0344

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..