[rt-users] RT 4.2.3 - Charting - Group By Ticket ID

sinical andrew at emptyness.net
Thu May 29 19:22:39 EDT 2014


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
Sent from the Request Tracker - User mailing list archive at Nabble.com.



More information about the rt-users mailing list