ich habe die Standardstatistik ein bißchen abgespeckt:
Code: Select all
<?xml version="1.0" encoding="utf-8" ?>
- <otrs_stats>
<Cache>0</Cache>
<Description>-</Description>
<File />
<Format>CSV</Format>
<Format>Print</Format>
<Object>TicketList</Object>
<ObjectModule>Kernel::System::Stats::Dynamic::TicketList</ObjectModule>
<ObjectName>Ticketlist</ObjectName>
<Permission>stats</Permission>
<StatType>dynamic</StatType>
<SumCol>0</SumCol>
<SumRow>0</SumRow>
<Title>Ticketliste aller geschlossenen Tickets geordnet nach der Lösungszeit_2</Title>
<UseAsRestriction Element="CloseTime" Fixed="1" TimeRelativeCount="1" TimeRelativeUnit="Month" />
- <UseAsValueSeries Element="OrderBy" Fixed="1">
<SelectedValues>SolutionDiffInMin</SelectedValues>
</UseAsValueSeries>
- <UseAsValueSeries Element="SortSequence" Fixed="1">
<SelectedValues>Up</SelectedValues>
</UseAsValueSeries>
- <UseAsXvalue Element="TicketAttributes" Fixed="1">
<SelectedValues>Number</SelectedValues>
<SelectedValues>TicketNumber</SelectedValues>
<SelectedValues>Age</SelectedValues>
<SelectedValues>State</SelectedValues>
<SelectedValues>Type</SelectedValues>
<SelectedValues>FirstResponse</SelectedValues>
<SelectedValues>SolutionTime</SelectedValues>
<SelectedValues>SolutionInMin</SelectedValues>
<SelectedValues>SolutionDiffInMin</SelectedValues>
</UseAsXvalue>
<Valid>1</Valid>
</otrs_stats>Nummer Ticket Nr. Alter Status Typ FirstResponse SolutionTime SolutionInMin SolutionDiffInMin
1 2,01112E+15 508019 closed successful default 30.12.2011 15:40 02.01.2012 11:18 0 0
2 2,01112E+15 508918 closed successful default 30.12.2011 14:46 30.12.2011 17:13 0 0
3 2,01112E+15 511416 closed successful default 30.12.2011 14:43 30.12.2011 17:04 0 0
4 2,01112E+15 517291 closed successful default 30.12.2011 12:44 30.12.2011 13:43 0 0
5 2,01112E+15 520701 closed successful default 30.12.2011 12:49 30.12.2011 13:42 0 0
6 2,01112E+15 521271 closed successful default 30.12.2011 13:36 30.12.2011 14:16 0 0
7 2,01112E+15 596284 closed successful default 30.12.2011 08:06 30.12.2011 13:31 0 0
Muss man dass in Excel berechnen?
Kann OTRS das nicht?
