SOLVED : 'Created by' option in statistics (Report)

hkshetty · Post by **hkshetty** » 04 May 2015, 04:45

Hi Team,

I am looking to have the 'Created by' column (X-axis) in my report (Statistics). However, I am unable to find that option in any of the steps (2 or 3), while generating the report. Basically, when I generate a report, I want to know who (Agent) created the ticket.

I am generating the following reports:

Stat# 10009 --> List of tickets closed between dates
Stat# 10068 --> List of tickets created between dates

I go to Admin --> Statistics --> Select the relevant stat and click on edit.
I do not see the option 'Created by' under the section "Attributes to be printed" in Step 2 nor in Step 3 (under the section "Order by").

Please advice.

Regards
Deepak
OTRS - 4.0.7
Ubuntu - 14.04
Apache - 2.4.7
MySQL - 5.5.41

hkshetty · Post by **hkshetty** » 15 May 2015, 10:12

Hi,

Anyone has any inputs or suggestion regd. my query?

hkshetty · Post by **hkshetty** » 01 Sep 2015, 03:27

Can someone advice, if this possible to achieve at all?

Post by **crythias** » 01 Sep 2015, 13:48

Agent statistics need to be enabled in SysConfig.

hkshetty · Post by **hkshetty** » 07 Sep 2015, 04:31

Thanks Crythias!

I tried looking the agent statistics option under SysConfig, however could not find it.

I checked in (a). Core::Stats (under the group 'Framework') (b). Core::Stats (under the group 'Ticket'), however could not find the relevant option to enable per your advice. Am I missing something?

Could you please assist in providing the correct path in SysConfig?

Thanks again for your time!

Regards

hkshetty · Post by **hkshetty** » 07 Sep 2015, 07:44

Dear Crythias,

Also, I tried checking (c). Frontend::Agent::Stats, I see there is one option which is already enabled (as show in the screens hot).
Is that what you were referring? or Am I missing something somewhere?

please advice.

Warm Regards

Post by **crythias** » 08 Sep 2015, 14:57

It is, but if it didn't do what you wanted, you'd be asking a different question.

hkshetty · Post by **hkshetty** » 09 Sep 2015, 05:00

Hi Crythias / Team,

Thanks for your time so far!

All I want is to pull a report which includes the ticket 'created by' (Agent) column. This is to measure the workload and individual productivity. Right now, in my reports (stats item # mentioned earlier), this column is not available.
Is it possible to have this column in the existing report? Or is there a separate report that speaks about individual agent stats?

Also, when you say, "Agent statistics need to be enabled in SysConfig", where can I enable this? Am I missing something?
Can you please advice?

Your assistance would be much appreciated!

Cheers

Post by **jojo** » 09 Sep 2015, 07:00

The mentioned setting was already explained, and allows to create reports on owners. The report you actually want to create needs an SQL query

hkshetty · Post by **hkshetty** » 09 Sep 2015, 09:46

Got it!

I am seeking my friends assistance in the SQL query as I am not well versed with the SQL nor Unix etc.

Thanks Jojo / Crythias for your time and advice!

Warm Regards
Deepak

igorlidzhiev · Post by **igorlidzhiev** » 28 Nov 2017, 12:14

hkshetty wrote:Got it!

I am seeking my friends assistance in the SQL query as I am not well versed with the SQL nor Unix etc.

Thanks Jojo / Crythias for your time and advice!

Warm Regards
Deepak

Hi!
I have the same question as you posted above. Can you share your query?
Thanks in advance.

Znuny and ((OTRS)) Community Edition