Enclosed is an excel chart I am trying to convert to cognos. The issue is I have a set of dates and totals. I want to segment the dates by week and present a weekly snapshot via chart. I am very new to cognos and have purchased several books that do not provide good examples. If someone has answers and perhaps some sample code that would help greatly.
You should be able to calculate the week commencing date...always assuming you don't already have a calendar table. Depending on your database you probably want something along the lines of:
_add_days([Lock Expiration Date],-_day_of_week([Lock Expiration Date],1))
That should give you the Sunday at the start of each week.
Feels like deja vu all over again. You might do better continuing an existing thread rather than posting a new thread for the same thing so that the continuity and big picture of your situation isn't scattered across different posts.
http://www.cognoise.com/index.php/topic,30434.msg98931.html#msg98931
BigChris has provided a good expression to use for weeks on the X-axis. I think if you put the two measures in the series, as I said in the other post, then the figures will automatically aggregate by week.