2 Replies Latest reply on Jun 26, 2015 5:46 AM by Rizwan

    How to create open Aged Incidents query to add on dashboard as gadget

    Specialist

      Hi Experts,

       

      I want to have a aged Incidents query by group and analyst created to add on dashboard as gadget.

      I believe i have to create a field with calculation to calculate the date diff between today and Incident Creation date, then use if else logic to group them into (0-1 Days) (1- 3 Days) (3-5) (5-10) (>30).

       

      I am wondering how can i write a calculation as i am new to calculation (Boo)  and pull data by groups and Analyst.

      Please help!

       

      Below is the screenshot of what and how the data looks like.

       

      Aged Incidents Gadget on dashboard.jpg