Pesquisas recentes
Sem pesquisas recentes

BO Zappier
Entrou em 23 de set. de 2022
·
Última atividade em 04 de out. de 2022
Seguindo
0
Seguidores
0
Atividade total
3
Votos
0
Assinatura
1
VISÃO GERAL DA ATIVIDADE
MEDALHAS
ARTIGOS
PUBLICAÇÕES
COMENTÁRIOS NA COMUNIDADE
COMENTÁRIOS EM ARTIGOS
VISÃO GERAL DA ATIVIDADE
Atividade mais recente por BO Zappier
BO Zappier comentou,
I solved the format issue! But now I am facing another issue of computation with this error: fail to calculate AVG(Resolution in business hours) because the following values can't be evaluated {1}
Here is the code:
IF (DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days")=0) AND ([Ticket created - Hour]ARRAY("13:30")) THEN VALUE(Full resolution time - Business hours (hrs))-1
ELSE IF (DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days")=0) AND ([Ticket created - Hour]ARRAY("13:30")) THEN VALUE(Full resolution time - Business hours (hrs))-(ARRAY("13:30")-[Ticket created - Hour])
ELSE IF (DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days")>=1) AND ([Ticket created - Hour]ARRAY("12:30")) THEN VALUE(Full resolution time - Business hours (hrs))-(DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE IF (DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days")>=1) AND ([Ticket created - Hour]ARRAY("13:30")) THEN VALUE(Full resolution time - Business hours (hrs))-(1+DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE IF ( DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days")>=1) AND ([Ticket created - Hour]>ARRAY("13:30")) AND ([Ticket solved - Hour]>ARRAY("13:30")) THEN VALUE(Full resolution time - Business hours (hrs))-(DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE IF (DATE_ADD([Ticket created - Date],"day",1)<[Ticket solved - Date]) AND ([Ticket created - Hour]>ARRAY("12:30")) AND ([Ticket solved - Hour]>ARRAY("13:30")) THEN VALUE(Full resolution time - Business hours (hrs))-(1+DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE VALUE(Full resolution time - Business hours (hrs)) ENDIF ENDIF ENDIF ENDIF ENDIF ENDIF
Exibir comentário · Publicado 04 de out. de 2022 · BO Zappier
0
Seguidores
0
Votos
0
Comentários
BO Zappier criou uma publicação,
Hello,
I can't upgrade to set a different set of planing for each team and I would like to calculate the full resolution time without the lunch break (I don't want my team to be impacted because of that :) )
For this I am trying to create a calculated metric that will modify the full resolution time but there seems to be a problem with the syntax and I don't know where it could be...
Here is the formula, if anyone can help it would be very appreciated:
IF ([Ticket created - Date]=[Ticket solved - Date] AND [Ticket created - Hour]ARRAY("13:30")) THEN VALUE(Full resolution in business hours)-1
ELSE IF ([Ticket created - Date]=[Ticket solved - Date] AND [Ticket created - Hour]ARRAY("13:30") ) THEN VALUE(Full resolution in business hours)-(ARRAY("13:30")-[Ticket created - Hour])
ELSE IF ([Ticket created - Date]<[Ticket solved - Date] AND [Ticket created - Hour]ARRAY("12:30") ) THEN VALUE(Full resolution in business hours)-(DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE IF ([Ticket created - Date]<[Ticket solved - Date] AND [Ticket created - Hour]ARRAY("13:30")) THEN VALUE(Full resolution in business hours)-(1+DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE IF ( [Ticket created - Date]<[Ticket solved - Date] AND [Ticket created - Hour]>ARRAY("13:30") AND [Ticket solved - Hour]>ARRAY("13:30")) THEN VALUE(Full resolution in business hours)-(DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days"))
ELSE IF (DATE_ADD([Ticket created - Date],'day',1)<[Ticket solved - Date] AND [Ticket created - Hour]>ARRAY("12:30") AND [Ticket solved - Hour]>ARRAY("13:30")) THEN VALUE(Full resolution in business hours)-(1+DATE_DIFF([Ticket created - Date],[Ticket solved - Date],"nb_of_days")) ELSE VALUE(Full resolution in business hours) ENDIF ENDIF ENDIF ENDIF ENDIF ENDIF
Thank you!
Publicado 23 de set. de 2022 · BO Zappier
0
Seguidores
4
Votos
3
Comentários