Hi guys,
Is anyone aware of a tool to let users create more complex or arbitrary graphs
than the few published modern extensions? They’re useful, but all fairly limited
and impose many constraints. I’m asking for a general solution, but what I’m
presently most interested in is a way of graphing the relative abundance of
custom field values amongst tickets matching a given query. i.e; I’d like a pie
chart of how many tickets created in the last month have CF-Fred set to foo,
bar, baz or qux…
Any thoughts?
Cambridge Energy Alliance: Save money. Save the planet.
Is anyone aware of a tool to let users create more complex or arbitrary graphs
than the few published modern extensions? They’re useful, but all fairly limited
and impose many constraints. I’m asking for a general solution, but what I’m
presently most interested in is a way of graphing the relative abundance of
custom field values amongst tickets matching a given query. i.e; I’d like a pie
chart of how many tickets created in the last month have CF-Fred set to foo,
bar, baz or qux…
What you describe should be built into 3.8
Search for tickets created after 2009-07-01
Scroll the bottom of the results, choose a Pie
chart and chart by Custom Field Fred
-kevin
Ah, yes, got it! Thanks.
I forgot that RT assumes CF’s are queue specific,
and only shows them when a queue is specified.
We have several CFs that are used in multiple queues e.g;
Tags; and sometimes want to search across queues based
on these fields. In query builder this can be gotten around
by first selecting a queue, then your CF condition, then
deleting the queue from the query…
The workaround for this chart is similar, get your results
for one queue, then remove the queue condition from the URI.
Cambridge Energy Alliance: Save money. Save the planet.