If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Baseline in Chart - Average Count for 3 months

Started by Brandimore, 24 May 2011 09:33:33 AM

Previous topic - Next topic

Brandimore

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!