Allow Numeric Fields to Appear in Rows/Columns Not Just Metrics

4 Comments

  • Chandra Robrock
    Community Moderator
    Most Helpful - 2021

    Hey Sara - There is a way to create a standard calculated attribute based on a numeric ticket field that I've found extremely helpful for the exact reason you described. 

    Here's the formula I use:

    IF (VALUE(Numeric Field Name) != NULL)
    THEN VALUE(Numeric Field Name)
    ENDIF

    You'll just want to replace the bolded Numeric Field Name text with the name of the exact ticket field you'd like to use.

    0
  • Kuldeep Patidar

    Hi @...,

    Thank you to share your solution! I went through the same process and created a standard calculated attribute using your formula, but the new attribute is still displayed under Metrics Segment only. (sharing my formula)

    Could you please let me know how to make it available in the Row/Columns segment as well?

    Thanks,

    Kuldeep

    0
  • Chandra Robrock
    Community Moderator
    Most Helpful - 2021

    Hi @... - Based on your screenshot, it looks like you may have created a Standard Calculated Metric instead of a Standard Calculated Attribute which would explain why you're having trouble seeing this new metric available in the Rows/Columns section. 

    Sharing a screenshot of where you can find this option in the Calculations menu:

    0
  • Kuldeep Patidar

    Works perfectly! Thanks so much @....

    0

Please sign in to leave a comment.

Powered by Zendesk