Skip to main content
Mike Ryan (ECCO) ha fatto una domanda in #Reports & Dashboards
We provide food using the case object, so an Account hase several cases - service = food, I would like to calculate on that Account the days between the "Case" food requests.
6 risposte
  1. 9 set 2013, 17:43
    That's going to be kinda tricky with a report because the Cases are not directly connected to each other, so there is no way to compare Case-1.Date to Case-2.Date to Case-3.Date, etc.  

     

    You might want to start be creating a Custom Report Type (CRT) and selecting Account as the Primary object, then select "with or without" related Cases. (kinda like this) => https://success.salesforce.com/069300000031uhF

     

       

     

    Then create a Matrix report grouped by:  

     

    Account (Rows) and Case (Columns) grouped by Case Date