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

Aggregate dataitem error

Started by que1983, 05 Apr 2016 02:55:54 PM

Previous topic - Next topic

que1983

I am attempting to create a chart like page 2 of this spreadsheet enclosed.  I chose the default measure as weekly_total.  This variable has the following parameters

aggregate dataitem=lock expiration date

aggregate method=total

The primary axes is total_recvd and total_not_recvd

The x axis is lock_expiration_date

When I run the chart I created I get the error unable to build aggregate dataitem=weekly_total.  referenced dataitem = lock_expiration_date not found in nesting level

Lynn

I don't think using the aggregate data item as the default measure is necessary. You can use your received and not received measures as the series since they will aggregate by week anyway because you having week on the x-axis.