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

How to use one of the row total % in visualisation

Started by navap, 18 Mar 2019 05:33:46 PM

Previous topic - Next topic

navap

Hi,

Business asked to convert an excel report into Cognos dashboards 11.1 report.

Data is granular. One row per order. Excel conveniently calculating row total % first using pivot(See data screenshot) and using this data set as input for graph (See visual). Note I only need Compliant %s and it's average for the visualization.

I exposed this relational model in FM and using it in Dashboard, however I could get the row% total using percentage function but not sure how I can use this as dataset for visualization. If there is a way to do this directly even better but no matter how I try the percentage function, I am not getting the anticipated result.

The other complexity is average again just for Compliant orders. Do not worry about target as that is just hard  coded value.

Thanks for any help.

navap


navap