IF-THEN-ELIF-ENDIF | Community
Skip to main content

IF-THEN-ELIF-ENDIF

  • December 4, 2023
  • 1 reply
  • 0 views
A

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?

 

    1 reply

    F
    Hi Alex,

    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
    Terms & ConditionsCookie settingsAccessibility statement