RT 4.2.3 - Charting - Group By Ticket ID

Hi List (Sorry if this is a doubleup I cant seem to post even though I am
subscribed),

Trying to make a performance report where the x-axis value is the Ticket
ID so we can see if a job was done on time (Due Date set via the SLA
Extension)

However I couldn’t select this as an option in the group by field.

I editted /lib/RT/Report/Tickets.pm from

our @GROUPINGS = (
Status => ‘Enum’, #loc_left_pair

Queue  => 'Queue',                  #loc_left_pair

Owner         => 'User',            #loc_left_pair
Creator       => 'User',            #loc_left_pair
LastUpdatedBy => 'User',            #loc_left_pair

Requestor     => 'Watcher',         #loc_left_pair
Cc            => 'Watcher',         #loc_left_pair
AdminCc       => 'Watcher',         #loc_left_pair
Watcher       => 'Watcher',         #loc_left_pair

Created       => 'Date',            #loc_left_pair
Starts        => 'Date',            #loc_left_pair
Started       => 'Date',            #loc_left_pair
Resolved      => 'Date',            #loc_left_pair
Due           => 'Date',            #loc_left_pair
Told          => 'Date',            #loc_left_pair
LastUpdated   => 'Date',            #loc_left_pair

CF            => 'CustomField',     #loc_left_pair

);
our %GROUPINGS;

to

our @GROUPINGS = (
Status => ‘Enum’, #loc_left_pair
id => ‘Enum’,
Queue => ‘Queue’, #loc_left_pair

Owner         => 'User',            #loc_left_pair
Creator       => 'User',            #loc_left_pair
LastUpdatedBy => 'User',            #loc_left_pair

Requestor     => 'Watcher',         #loc_left_pair
Cc            => 'Watcher',         #loc_left_pair
AdminCc       => 'Watcher',         #loc_left_pair
Watcher       => 'Watcher',         #loc_left_pair

Created       => 'Date',            #loc_left_pair
Starts        => 'Date',            #loc_left_pair
Started       => 'Date',            #loc_left_pair
Resolved      => 'Date',            #loc_left_pair
Due           => 'Date',            #loc_left_pair
Told          => 'Date',            #loc_left_pair
LastUpdated   => 'Date',            #loc_left_pair

CF            => 'CustomField',     #loc_left_pair

);
our %GROUPINGS;

and am able to use id as an x-axis value and I can generate all the graphs
we wanted. However is this the proper way to do this or is there a better
way to get this functionality that will survive through upgrades?

Thanks in advance

View this message in context: http://requesttracker.8502.n7.nabble.com/RT-4-2-3-Charting-Group-By-Ticket-ID-tp57531.html

Hi List (Sorry if this is a doubleup I cant seem to post even though I am
subscribed),

Trying to make a performance report where the x-axis value is the Ticket
ID so we can see if a job was done on time (Due Date set via the SLA
Extension)

However I couldn’t select this as an option in the group by field.

and am able to use id as an x-axis value and I can generate all the graphs
we wanted. However is this the proper way to do this or is there a better
way to get this functionality that will survive through upgrades?

To get something that will survive via upgrades, you want to use a
_Local.pm overlay. However, if you think this is a genuinely useful
enhancement to the charting features of RT 4.2, send a patch,
preferably with some screenshots showing what you’re doing with it.

-kevin