Convert value of a field to its label
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2024 07:22 AM
Hello! I am trying to build various indicators on the incident_metric db view. One indicator I'd like to build in particular is for the On hold reason field. Essentially, I'd like to use that indicator to build a word cloud widget on the On hold reasons to show the most common reasons an incident was placed on hold.
I tried this, and was not able to see the actual label for the field On hold reason. It just returned its value (0, 1, 2, 3) instead of the label (Awaiting Caller, Awaiting Change, Awaiting Problem, Awaiting Vendor).
I'm sure this will involve a script, but I'm not sure what to script and where to put the script (should it be in the breakdown mapping, aggregate in the indicator, or elsewhere?). Any help is appreciated! Thanks!