Skip to main content
Mike Ryan (ECCO) 님이 #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개
  1. 2013년 9월 9일 오후 5: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