Dashboard Query

[Kelvin]

I have been asked to set up a dashboard for a colleague which would show calls that have been open for a certain period of time, eg call age over 72 hours. is this possible?

[Lyonel]

Sure it is

Create a widget of type: List of counter data:

Then set the details as follow:

Result:

[Kelvin]

@Lyonel Thank you for that, however I am looking for a user dashboard so that they can drill down to the call details. 

[Lyonel]

@Kelvin if you want to do that in the request list, then:

1. Create a view by setting up the fields as follow:

NOTE: Team is optional

2. Save your view and share it with all teams (when applicable of course)

3. Build pie chart from this view:

You can do all sorts of charts and have as many as you need.

Drill down from charts is native in this screen.

Hope this helps?