COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Brandimore on 24 May 2011 09:33:33 AM

Title: Baseline in Chart - Average Count for 3 months
Post by: Brandimore on 24 May 2011 09:33:33 AM
Hi Folks

I have a report with a chart. I want to show an average count for 3 months of data as a baseline.

It sounds simple. I created a calculation to filter out the 3 months. I then added a Query Calculation to the Baseline which was

count ([callid] for [3 months])

When I go to verify it says it can't find DataItem1 and doesn't like the [3 month] calc I created. Which works fine.

Can someone provide feedback if I'm heading in the right direction?

Thanks!