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
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.
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
Sorry, forgot to attach the xml code.
Thanks,
Sridevi