Filtering in Statistics

Moderator: crythias

Post Reply
seberget2
Znuny newbie
Posts: 74
Joined: 17 May 2013, 09:30
Znuny Version: 6.0.30
Real Name: Stein Erik Berget

Filtering in Statistics

Post by seberget2 »

I've looked at the statistics, and created a few new reports. Mostly with the accounted time for each ticket. I've done reports by Customer and By Agent. But I see specially for customers that customers we have not had ticket for in a period also comes up.

Is there a way to filter out those that have a sum of 0 in accounted time?
OTRS 6.0.12 on Ubuntu with MySQL DB, and various plug-ins and a hack or two :-D
alexus
Znuny wizard
Posts: 380
Joined: 20 Sep 2010, 16:54
Znuny Version: OTRS 6 CE
Real Name: Alexey Yusov
Company: Radiant System Group s.r.o
Location: Prague
Contact:

Re: Filtering in Statistics

Post by alexus »

Just use autofilters in OpenOffice or Excel - Excel -> Data -> Filter -> Choose column -> Unckeck "0"!
Alexey Yusov

Production: OTRS CE ITSM 6.0.28 on CentOS 7 + Apache 2.4 + MariaDB 10.4.13 + Radiant Customer Portal

Radiant System OTRS Intergrator
RS4OTRS marketplace
Stay tuned on our Facebook
((OTRS)) Community Edition - what next?
Post Reply