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.
Forgot to attach.
second attachment