最近搜索
没有最近搜索
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