最近の検索
最近の検索はありません
BO Zappier
参加日2022年9月23日
·
前回のアクティビティ2022年10月04日
フォロー中
0
フォロワー
0
合計アクティビティ
3
投票
0
サブスクリプション
1
アクティビティの概要
バッジ
記事
投稿
コミュニティへのコメント
記事へのコメント
アクティビティの概要
さんの最近のアクティビティ BO Zappier
BO Zappierさんがコメントを作成しました:
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
コメントを表示 · 投稿日時：2022年10月04日 · BO Zappier
0
フォロワー
0
投票
0
コメント
BO Zappierさんが投稿を作成しました:
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!
投稿日時：2022年9月23日 · BO Zappier
0
フォロワー
4
投票
3
コメント