On Fri, Dec 9, 2016 at 11:23 AM, Barton Chittenden
<bar...@bywatersolutions.com> wrote:
> We use a CF called 'Community Bug' to track bugzilla bug numbers associated
> with customer tickets. It would be really useful to know which values of
> CF.{Community Bug} occur most often.
>
> If you'll pardon a mix of SQL and query builder syntax, I'm looking to do
> something like this:
>
> SELECT COUNT(*), CF.{Community Bug}
> FROM CF
> GROUP BY CF.{Community Bug}
> ORDER BY COUNT(*)
>
> I'm well aware that query builder doesn't work like this, but I'm wondering
> if there's a way to do something like this.

What RT are you using?

In 4.2 the defaults will get you mostly there.

Search -> Chart

Group by -> Custom field

Choose CF, then "Update Chart"

-m
---------
RT 4.4 and RTIR training sessions, and a new workshop day! 
https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Reply via email to