Search by Requestor Organization

I’m looking to do a search that will group by requestor organization
(bar chart to be exact)

When running my search I can select Requestor Organization, but I cannot
display it as a column, therefore I cannot create a bar chart for it.

What I want is a graph showing the number of tickets created in each
organization.

Ideas?

Thanks

Ben

The information contained in this communication may be confidential or legally privileged and is intended only for the recipient named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication or its contents is strictly prohibited. If you have received this communication in error, immediately advise the sender and delete the original and any copies from your computer system.

I’m looking to do a search that will group by requestor organization
(bar chart to be exact)

When running my search I can select Requestor Organization, but I cannot
display it as a column, therefore I cannot create a bar chart for it.

What I want is a graph showing the number of tickets created in each
organization.

I have exactly the same need, but it seems that intrusive modifications
of RT are required to acheive that goal.

Emmanuel Dreyfus
http://hcpnet.free.fr/pubz
manu@netbsd.org

Not that hard: http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision?rev=16264
Would be available in RT 3.8.3, however there is a bug in RT I should
fix that makes numbers incorrect for Requestors, Ccs and other
watchers.On Thu, Oct 9, 2008 at 11:44 PM, Emmanuel Dreyfus manu@netbsd.org wrote:

Auch, Benjamin bauch@jcpgroup.com wrote:

I’m looking to do a search that will group by requestor organization
(bar chart to be exact)

When running my search I can select Requestor Organization, but I cannot
display it as a column, therefore I cannot create a bar chart for it.

What I want is a graph showing the number of tickets created in each
organization.

I have exactly the same need, but it seems that intrusive modifications
of RT are required to acheive that goal.


Emmanuel Dreyfus
http://hcpnet.free.fr/pubz
manu@netbsd.org


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Ok, there is no fix, however if CGM table is not shrinked after
upgrade from 3.6 then numbers can be wrong.

There is known numbers shift when more then one user from the same
organization is listed as requester. That can be fixed I think, but
not today.On Fri, Oct 10, 2008 at 6:07 AM, Ruslan Zakirov ruz@bestpractical.com wrote:

Not that hard: http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision?rev=16264
Would be available in RT 3.8.3, however there is a bug in RT I should
fix that makes numbers incorrect for Requestors, Ccs and other
watchers.

On Thu, Oct 9, 2008 at 11:44 PM, Emmanuel Dreyfus manu@netbsd.org wrote:

Auch, Benjamin bauch@jcpgroup.com wrote:

I’m looking to do a search that will group by requestor organization
(bar chart to be exact)

When running my search I can select Requestor Organization, but I cannot
display it as a column, therefore I cannot create a bar chart for it.

What I want is a graph showing the number of tickets created in each
organization.

I have exactly the same need, but it seems that intrusive modifications
of RT are required to acheive that goal.


Emmanuel Dreyfus
http://hcpnet.free.fr/pubz
manu@netbsd.org


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


Best regards, Ruslan.

Best regards, Ruslan.