Duration Field

Good afternoon,

I was wondering whether it was possible to have a field which displays the length of time a case has been at a certain stage? Unless there is a way to pull through the information from the tracking tab? The end result would be to get it to display the duration on an interactive dashboard which displays active cases.

Thanks,

Marc

  • 0

    You're right there is duration field on the tracking tab. This is the 'Case Progress' table in the database, you just need a report view what links Cases and CaseProgress together and then you will be able to display the duration field on the dashboard.

  • 0

    Generally you need to do "Create View" -> "Create Report using view" -> "Place Report on Dashboard".

    By the sounds of things you missed out the step where you need to crate the report first, once created on the dashboard you would "Create Gadget (List)" and select the report you have just created.

  • 0

    I have created the Report view fine however am unable to see it when it comes to selecting the data source on the dasboard. Is there a chance i have missed something? Not ticked something? I only ticked Report View on the view creation screen, is this correct?

    Thanks.

  • 0

    Hi,

    I have created the report based off of the view, however cannot see the report listed in available reports when it comes to creating the Dashboard Gadget. Is there something i need to tick on the report to enable it on the dasboard?

    Thanks.