Retrieving data for Grafana from elasticSearch

Lobby
1

Is it possible to get data on the amount of time spent by each agent? I would like to add not only top agents but also top time spent per day per agent.

2

I’ve connected the PoistgreSQL base to grafana and made a query, but I can’t figure out how to map “public.ticket_time_accountings.time_unit” to
“public.ticket_time_accounting_types.name”.

SELECT 
  public.ticket_time_accountings.time_unit,
  public.ticket_time_accounting_types.name,
  public.ticket_time_accountings.time_unit AS metric
FROM
  public.ticket_time_accountings,
  public.ticket_time_accounting_types
3

Hi Lex,

You can add the Graphana template for Zammad and see how they work to create your own :

image
image935Ă—612 110 KB

that be usefull for me to understand how thats work

Grafana — Zammad System Documentation documentation

1 Like