my question is how to get accounted time by every agent in queues-service by week ?
example but needs to filter only time accounted by the agent who is running the stat
Service - Queue Fri 21 Sat 22 Sun 23 Mon 24 Tue 25 Wed 26 Thu 27 Fri 28
Application Support - Company1 0 1 0 0 1 4 0 0
Application Support - Company2 0 0 0 0 0 0 0 0
Application Support - Company3 0 0 0 0 0 0 0 0
Application Support - Company4 0 0 0 0 0 0 0 0
Application Support - INTERNAL 0 0 0 0 0 0 0 0
Application Support - ITOCHU 0 0 0 0 0 0 0 0
Application Support - UMG 0 0 0 0 0 0 0 0
Infrastructure Support - Company1 0 0 0 0 0 1 0 0
Infrastructure Support - Company2 0 0 0 0 0 0 0 0
Infrastructure Support - Company3 0 0 0 0 0 0 0 0
Infrastructure Support - Company4 0 0 0 0 0 0 0 0
Infrastructure Support - INTERNAL 0 0 0 0 0 0 0 0
Infrastructure Support - ITOCHU 0 0 0 0 0 0 0 0
Infrastructure Support - UMG 0 0 0 0 0 0 0 0
I have generated the attached stat but this will provide time for each agent who will run the report?
Code: Select all
<?xml version="1.0" encoding="utf-8"?>
<otrs_stats>
<Cache>0</Cache>
<Description>time</Description>
<File></File>
<Format>CSV</Format>
<Object>TicketList</Object>
<ObjectModule>Kernel::System::Stats::Dynamic::TicketList</ObjectModule>
<ObjectName>Ticketlist</ObjectName>
<Permission>Company1</Permission>
<Permission>Company2</Permission>
<Permission>Company3</Permission>
<Permission>Company4</Permission>
<Permission>INTERNAL</Permission>
<Permission>UMG</Permission>
<ShowAsDashboardWidget>0</ShowAsDashboardWidget>
<StatType>dynamic</StatType>
<SumCol>0</SumCol>
<SumRow>0</SumRow>
<Title>timeWeek</Title>
<UseAsValueSeries Element="SortSequence" Fixed="1">
<SelectedValues>Up</SelectedValues>
</UseAsValueSeries>
<UseAsXvalue Element="TicketAttributes" Fixed="1">
<SelectedValues>TicketNumber</SelectedValues>
<SelectedValues>Queue</SelectedValues>
<SelectedValues>CustomerID</SelectedValues>
<SelectedValues>AccountedTime</SelectedValues>
</UseAsXvalue>
<Valid>1</Valid>
</otrs_stats>