FirstResponseInMin return 0
Moderator: crythias
FirstResponseInMin return 0
First of all, im sorry if this has been asked before.
i have been using OTRS for a few months now its been a great. but upon generating report through statistic i found that FirstResponseInMin always shows 0 but my FirstResponse shows correct value. anything that i missed? any help would be appreciated
Thanks in advance
i have been using OTRS for a few months now its been a great. but upon generating report through statistic i found that FirstResponseInMin always shows 0 but my FirstResponse shows correct value. anything that i missed? any help would be appreciated
Thanks in advance
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: FirstResponseInMin return 0
Did you respond?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny guru
- Posts: 2210
- Joined: 13 Mar 2014, 09:16
- Znuny Version: 6.0.14
- Real Name: Rolf Straub
Re: FirstResponseInMin return 0
I got a list about those params from our support. According to that, the FirstResponse shows the timestamp of the first response (as you say) and the FirstResponseInMin shows the minutes to the first response IF you have an escalation (SLA or Queue settings) attached to it.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: FirstResponseInMin return 0
It's important to answer this question. If the response is generated, it clears the timestamp where a response is needed. If a response was not generated, then the deadline remains.crythias wrote:Did you respond?
Note I think I understand what you're asking (Did the response exceed the deadline?)
https://github.com/OTRS/otrs/blob/584bd ... et.pm#L173
You might want to look at these:
https://github.com/OTRS/otrs/blob/584bd ... et.pm#L151
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: FirstResponseInMin return 0
Forgive me for the late reply.
attached here is the screenshot from the stat that i have generate.
as u can see my first response show correct value and 0 for the FirstResponseInMin.
any ideas fellas?
attached here is the screenshot from the stat that i have generate.
as u can see my first response show correct value and 0 for the FirstResponseInMin.
any ideas fellas?
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: FirstResponseInMin return 0
If anyone else wants to take a crack at this, have at it.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny guru
- Posts: 2210
- Joined: 13 Mar 2014, 09:16
- Znuny Version: 6.0.14
- Real Name: Rolf Straub
Re: FirstResponseInMin return 0
I'd still like to know if this value changes when there is an escalation attached to the ticket.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
-
- Znuny expert
- Posts: 213
- Joined: 04 Nov 2012, 23:58
- Znuny Version: OTRS 4.x
- Real Name: Esteban
- Company: NORTON DE COLOMBIA
Re: FirstResponseInMin return 0
From i have seen(experienced) if the ticket doesnt have an SLA associated, it will show 0 for FirstResponseInMin and SolutionTimeInMin.. i dont know if it is your case
Re: FirstResponseInMin return 0
again sorry for keep all of u waiting for my reply. been quite busy and away from my desk
so far from the stat that i generated FirstResponseDiffInMin come up with 120 exactly as i want it but still nothing for FirstResponseInMin
UPDATE : one ticket i noticed shows 488 for the FirstResponseInMin BUT only after he(agent) repspond on the next day. calculate that and u got 12.00 am meaning that it start to count responses starting at 12.00am??? <--- am i right?
this one
yes from the stat that i attached earlier i have respond to all ticketcrythias wrote:Did you respond?
i have not use any escalation before but i did now but only on escalation - first time response (minutes)RStraub wrote:I got a list about those params from our support. According to that, the FirstResponse shows the timestamp of the first response (as you say) and the FirstResponseInMin shows the minutes to the first response IF you have an escalation (SLA or Queue settings) attached to it.
so far from the stat that i generated FirstResponseDiffInMin come up with 120 exactly as i want it but still nothing for FirstResponseInMin
Thank You for this but i still cant figure the how to make it works.crythias wrote:It's important to answer this question. If the response is generated, it clears the timestamp where a response is needed. If a response was not generated, then the deadline remains.crythias wrote:Did you respond?
Note I think I understand what you're asking (Did the response exceed the deadline?)
https://github.com/OTRS/otrs/blob/584bd ... et.pm#L173
You might want to look at these:
https://github.com/OTRS/otrs/blob/584bd ... et.pm#L151
UPDATE : one ticket i noticed shows 488 for the FirstResponseInMin BUT only after he(agent) repspond on the next day. calculate that and u got 12.00 am meaning that it start to count responses starting at 12.00am??? <--- am i right?
this one
-
- Znuny guru
- Posts: 2210
- Joined: 13 Mar 2014, 09:16
- Znuny Version: 6.0.14
- Real Name: Rolf Straub
Re: FirstResponseInMin return 0
Two things to keep in mind:
1) FirstResponseInMin is calculated IF there is an escalation and IF there is a response
2) The minutes are based on the calendar that is attached to the queue - so if you have weird working hours configured, that response time does not show the "real" difference.
1) FirstResponseInMin is calculated IF there is an escalation and IF there is a response
2) The minutes are based on the calendar that is attached to the queue - so if you have weird working hours configured, that response time does not show the "real" difference.
Currently using: OTRS 6.0.14 -- MariaDB -- Ubuntu 16 LTS
Re: FirstResponseInMin return 0
Thank you so much RStraub !! it turns out that i did change the timezone in sysconfig for the calendar which i should not to. fix that and its all good. Thanks allRStraub wrote:Two things to keep in mind:
1) FirstResponseInMin is calculated IF there is an escalation and IF there is a response
2) The minutes are based on the calendar that is attached to the queue - so if you have weird working hours configured, that response time does not show the "real" difference.
-
- Znuny newbie
- Posts: 7
- Joined: 25 Apr 2014, 22:04
- Znuny Version: 6.0.12
- Real Name: Khaled Yousry
- Company: Next-Levels
Re: FirstResponseInMin return 0
Hello
I am having the same issue
the queue is assigned a calendar
and the calendar reflect a typical work week
check output of the PDF report, where it shows all FirstResponseInMin fields as 0s (Zeros)
I am just trying to generate a report, with all tickets which are closed successfully , with the first response time and fix time for each ticket
I am having the same issue
the queue is assigned a calendar
and the calendar reflect a typical work week
check output of the PDF report, where it shows all FirstResponseInMin fields as 0s (Zeros)
I am just trying to generate a report, with all tickets which are closed successfully , with the first response time and fix time for each ticket
OTRS 6.0.12, Ubuntu 18.04.1 LTS, Apache/2.4.29 , mysqld 5.7.24, Perl v5.26.1