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


      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