Búsquedas recientes
No hay búsquedas recientes
IF-THEN-ELIF-ENDIF
Publicado 04 dic 2023
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 comentario
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