Skip to main content
I would like to create a dashboard pie chart, in Classic, that shows what percentage of Assets on an Account have Cases against them.

 

For example, if there are 6000 Assets on the Account, and 60 of those Assets have Cases, I want the pie chart to show 10% (with cases) and 90% (no cases).

 

(These are the standard Asset and Case objects. Case has a lookup standard field to Asset.)

 

I cannot figure out how to build the report that will support this chart. Can anyone provide guidance?

 

All help greatly appreciated!
7 answers
  1. May 16, 2018, 6:53 PM
    Hi Chris,

     

    Could you post a screenshot of the Report, Report Type, and the Groupings, Settings, etc, that you're currently using and the results you're getting, and a mock-up of what you would like your Report/Dashboard results to look like? 
0/9000