Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rank/topcount issue in Pareto Chart

Status
Not open for further replies.

Acierno1

Technical User
May 29, 2014
1
I am attempted to whittle down my results in a Pareto Chart I have created in Cognos Workspace Advanced.
I get the following error however after validating my Data Item Expression:
OP-ERR-0060 An invalid number of operands was specified for the operator 'topcount' in the dataItem 'dataItem="Number of incidents1"

This is the expression I have written that has the problem.
rank(topcount([Incident Management].[Work Related Incident Information].[Part_Of_Body]),5,tuple([Incident Management].[Work Related Incident Information].[Cause_Of_Injury]))

Also worth noting, I am using Workspace advanced 10.2.1 through a webportal with data hosted off site by a 3rd party.

I have already ranked the data, now all I simply need to do is isolate the top 5, but it proving to be much harder to do than in Microsoft Report Builder.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top