Page 1 of 1

Dashboard customization

PostPosted: Mon Dec 13, 2010 10:12 am
by marilyn
I love the new Dashboard but would like to customize it a bit.

There are 2 charts - one is the Calls by Type and the other is Active Computers by Type.

The 2nd chart is not that useful to our company - I would rather see the Open Calls by Tech. Another chart that would be helpful would be Open Calls by Category.

Could you give me the SQL that would produce these chart so I could play with them a bit?

Thanks in advance for your assistance.

Re: Dashboard customization

PostPosted: Thu Dec 16, 2010 6:22 pm
by tccwrd
Dunno which dashboard you mean but look under the dashboards are in admin settings under general. Open any dashboard and look for entries that say Panel (Chart). Double-click and you'll see the sql used in the chart.

Re: Dashboard customization

PostPosted: Tue Jan 04, 2011 10:16 am
by marilyn
tccwrd wrote:Dunno which dashboard you mean but look under the dashboards are in admin settings under general. Open any dashboard and look for entries that say Panel (Chart). Double-click and you'll see the sql used in the chart.

The Dashboard I am talking about is the Default Dashboard. I did find the SQL for the current charts - I want a different chart on there.

Re: Dashboard customization

PostPosted: Thu Jan 06, 2011 5:22 pm
by janstonselig
marilyn wrote:The Dashboard I am talking about is the Default Dashboard. I did find the SQL for the current charts - I want a different chart on there.


You'll have to edit the charts in the default dashboard in admin settings to use a query like this:

Code: Select all
select Top 5
   CASE
   WHEN LEN(Assignee) > 15 THEN LEFT(Assignee, 12)+'...'
   ELSE Assignee
END, count(*)
from Incident_List
Where Status <> 'Resolved' and Status <> 'Closed'
group by Assignee
order by count(*) desc


That will show top 5 assignees. If you show all assignees it might make the chart look bad due to too many columns.

Re: Dashboard customization

PostPosted: Tue Feb 08, 2011 11:23 am
by marilyn
Thank you for your assistance - I tried it and it looks great.