tHaving problem with combination bar chart not displaying correct values.

[tinas]

I have created a report that contains a list report and a combination chart. The report shows specific categories by month.  A calculation is included for 'Rate per 100 Admissions'.  The calculation is:

([Adverse Event Count]/ [Daily Occupancy Summary Admit Count]) * 100


The Daily Occupancy Summary Admit Count number is the same for every row on the list report, as it should be.  For example, the report columns look similar to the following:

Month    Category    100 Adm    Ade Count  Census

JUL07   ANTICOAG   0.89    3,363        30
   NARCOTICS   0.51    3,363        17
   TOTAL ADEs   2.65    3,363        89

JUN07    ANTICOAG   0.92    3,377        31
   NARCOTICS   0.47    3,377        16
   TOTAL ADEs   3.49    3,377       118

The problem with the graphical display is that the bar is only presenting for each month; I need the bars to represent each Category for each month.  So - for Jun07  I see .92 for July I see .89.   I need to see the 3 different category values - June shold display .92 for AntiCoag, .47 for Narcotics, 2.65 for total.



Any help is appreciated.

Tina Stapleton

[RAJESH_COGNOS]

I too have a similar problem...TINAS did you find the solution to your problem?
Though both List and Graph are using same query internal queries are different.If you see the MDX queries COGNOS is generating QUERY 1.1 FOR GRAPH and QUERY 1.2 for list....

Please help how to solve this.

[Sridevi]

Hi,

Please check if the aggregation property of the measure is set to total .
Find the sample code attached which is similar to your requirement. See if this helps.

Thanks,
Sridevi

[Sridevi]

Sorry, forgot to attach the xml code.

Thanks,
Sridevi