Dashboard Help

RT Users
1

Hello,

I’m looking to create a custom dashboard, similar to the way in which
"QuickSearch" functions. I would like it to display a list of queues, and
then show how many tickets are New, Open, Stalled for each queue.

In the query builder I seem to be stuck at the getting RT to count the
total number of tickets per status, rather than just the total number of
tickets.

I have the following:

Query:
Queue = ‘SW_Bugs’ OR Queue = ‘SW_Incoming’ OR Queue = ‘SW_Projects’

Format:
‘QueueName’,
‘Status’

Please can you help?

Thanks.

2

I’m looking to create a custom dashboard, similar to the way in which
“QuickSearch” functions. I would like it to display a list of queues, and then
show how many tickets are New, Open, Stalled for each queue.

In the query builder I seem to be stuck at the getting RT to count the total
number of tickets per status, rather than just the total number of tickets.

I have the following:

Query:
Queue = ‘SW_Bugs’ OR Queue = ‘SW_Incoming’ OR Queue = ‘SW_Projects’

Format:
‘QueueName’,
‘Status’

That’s just going to list the tickets with Queue Name and the Status.
If you click on Chart, in 4.2 the default is to group/count by Status,
you can further group by Queue and then save that and stick it on your
dashboard.

You may find this helpful
http://bestpractical.com/docs/rt/latest/charts.html

-kevin

3

Hi Kevin, thanks for the reply.

Unfortunately I’m running 4.0.1 and don’t have that option. Is there any
way to do this without upgrading.

Thanks.On Tuesday, 17 June 2014, Kevin Falcone falcone@bestpractical.com wrote:

On Tue, Jun 17, 2014 at 11:52:00AM +0100, Guy Baxter wrote:

I’m looking to create a custom dashboard, similar to the way in which
“QuickSearch” functions. I would like it to display a list of queues,
and then
show how many tickets are New, Open, Stalled for each queue.

In the query builder I seem to be stuck at the getting RT to count the
total
number of tickets per status, rather than just the total number of
tickets.

I have the following:

Query:
Queue = ‘SW_Bugs’ OR Queue = ‘SW_Incoming’ OR Queue = ‘SW_Projects’

Format:
‘QueueName’,
‘Status’

That’s just going to list the tickets with Queue Name and the Status.
If you click on Chart, in 4.2 the default is to group/count by Status,
you can further group by Queue and then save that and stick it on your
dashboard.

You may find this helpful
Charts - RT 5.0.5 Documentation - Best Practical

-kevin

4

I updated to 4.2.5 without any issues and am able to achieve what I wanted
the way you described.

Thanks.On 22 Jun 2014 17:46, “Guy Baxter” gmbaxter@gmail.com wrote:

Hi Kevin, thanks for the reply.

Unfortunately I’m running 4.0.1 and don’t have that option. Is there any
way to do this without upgrading.

Thanks.

On Tuesday, 17 June 2014, Kevin Falcone falcone@bestpractical.com wrote:

On Tue, Jun 17, 2014 at 11:52:00AM +0100, Guy Baxter wrote:

I’m looking to create a custom dashboard, similar to the way in which
“QuickSearch” functions. I would like it to display a list of queues,
and then
show how many tickets are New, Open, Stalled for each queue.

In the query builder I seem to be stuck at the getting RT to count the
total
number of tickets per status, rather than just the total number of
tickets.

I have the following:

Query:
Queue = ‘SW_Bugs’ OR Queue = ‘SW_Incoming’ OR Queue = ‘SW_Projects’

Format:
‘QueueName’,
‘Status’

That’s just going to list the tickets with Queue Name and the Status.
If you click on Chart, in 4.2 the default is to group/count by Status,
you can further group by Queue and then save that and stick it on your
dashboard.

You may find this helpful
Charts - RT 5.0.5 Documentation - Best Practical

-kevin