[changes - field name] - creating metric with 2 changes | The place for Zendesk users to come together and share
Skip to main content
Eli13
Eli13
May 19, 2022
Question

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

  • May 19, 2022
  • 2 replies
  • 24 views

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

    2 replies

    sphen11
    sphen11
    May 20, 2022

    Hi @eli13! 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
    Eli13
    Eli13Author
    May 23, 2022

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

    Terms & ConditionsAccessibility statement