最近の検索
最近の検索はありません
IF-THEN-ELIF-ENDIF
投稿日時:2023年12月04日
Hello there
I had created a standard calculated attribute like this:
IF ([Changes - Previous value]="24947722") THEN "Support 1"
ELIF ([Changes - Previous value]="10896710647068") THEN "Support 2"
ELIF ([Changes - Previous value]="10896665204124") THEN "Support 3"
ELIF ([Changes - Previous value]="10867060074140") THEN "Support 4"
ELIF ([Changes - Previous value]="10896689212444") THEN "Support 5"
ELIF ([Changes - Previous value]="10867032886556") THEN "Support 6"
ENDIF
This is not working because it is being evaluated until the first condition is true. This attribute is being used to measure the time the ticket spent in a group. Is there another way to accomplish this?
0
1
1件のコメント
Fran
Are you trying to achieve a result similar to the one described in this recipe (sorting results by brackets)?
I'm assuming the attribute you posted is based on what is mentioned on this recipe. In the same section where the attribute formula is described, there is a sub-section called 'Using the custom attribute in a report' with details on how to add it to a report.
Is your goal to display an average or the total time spent on all tickets in a specific time range or are you reporting on individual tickets?
As this might need further investigation, I'll be creating a ticket for you to look into this issue in detail.
Best regards,
Fran
0