[changes - field name] - creating metric with 2 changes

Beantwortet
image avatar

Eli (Vitalii Klymiuk)

Gepostet 19. Mai 2022

Hi guys! I am creating a metric, that should display ticket updates according to 2 fields changes: status and customer request type. Is it possible? If yes, what is wrong with my formula:

IF ([Changes - Field name] = "Customer request type"
AND [Changes - Previous value] != [Changes - New value])
AND ([Changes - Field name] = "status" and [Changes - New value] != "solved")
THEN [Update ID]
ENDIF

0

2

2 Kommentare

Datum
    Neueste
      image avatar

      Eli (Vitalii Klymiuk)

      Hi Stephen! Thank you for the suggestion. Unfortunately, it is still showing 0, however, separately it is working fine.

      0

      image avatar

      Stephen Belleau

      Hi Eli (Vitalii Klymiuk)! I am wondering if you just need an extra set of brackets around your IF condition?

      IF (
        ([Changes - Field name] = "Customer request type"
        AND [Changes - Previous value] != [Changes - New value])
        AND ([Changes - Field name] = "status" and [Changes - New value] != "solved")
      )
      THEN [Update ID]
      ENDIF

      0

      Melden Sie sich an, um einen Kommentar zu hinterlassen.

      Sie finden nicht, wonach Sie suchen?

      Neuer Post