Chart X-axis Date need to group, sort and show as ww/yyyy

[Rovinesh]

Hi Experts,

I'm currently using Cognos 8 Report Studio to make a chart about the amount of incomplete orders at the end of the week(Friday). Right now I'm stuck because the X-Axis of the chart needs to show the week/year(ww/yyyy). When I use a Date-field I get the ww/yyyy but the chart groups the data on date. It needs to show the amount of every week of the year.

Ex. Now it show like 49/2012, 49/2012, 50/2012, 50/2012...etc etc.

My question is how can I fix this. I already tried to put both the week and the year data fields in the X-Axis, but that doesn't work either.

Please Help!!

[absriram]

Rovinesh,

I think you are using the data format option to get the desired format in the chart. But your underlying data item is still date. Hence the duplicate entries. You should, instead, use _week_of_year function inside your data item and concatenate this with year. Now, your data will be grouped by the week.

To make sure it works, look at the tabular data first, and this should have the grouping you want in the chart.

Sriram.
http://www.cognosonsteroids.com