graphics in real time

[RRFARIA]

Within the OTRS has some kind of chart that I can see and follow the updates of the calls, called closed without my having to keep drawing reports?


What I need is the type of statistical graphics that is the main screen of the OTRS
only needed more graphics (pie graphs, bar ...)
show me the same information in real-time statistics ...
without having to report is taking all the time ... similar to a dashboard

[jojo]

no, there is no such module

[RRFARIA]

there is no add-on to do it ?

[jojo]

currently there is no module for this.

If you need this you can code this or pay somebody for development of such a kind of module

[RRFARIA]

on forum in Portuguese, cited a User that uses a complementary tool to generate the graphics, but did not say name .... Anyone know something similar

viewtopic.php?f=129&t=15832&p=62346&hil ... cos#p60909

[artjoms15]

Hmmm, it is possible to generate a real-time graph in Zabbix System monitoring tool, by executing SQL statements for data input on time period basis (Graph refreshes every x seconds). But I haven' t tried implementing those reports inside OTRS dashboard.

The SQL for opened tickets might be really trivial, like

Code: Select all

SELECT COUNT(*) FROM ticket
WHERE DAY(ticket.create_time) = DAY(NOW());