Is there a built-in way to perform transformations on fields retrieved from a data provider in the dash builder?
I'm currently exploring the capabilities of the Dashbuilder to see how flexible the customization is for creating business dashboards. In our database, we sometimes use certain fields as "Flags" to represent certain categories.
For instance, I might use a single character field in the database to represent a "processing status." I might use 'R' to represent "Rejected", 'A' to represent accepted, and null to represent that a record had not yet been processed. Is there a built-in way to tell a "Key Performance Indicator" panel to automatically replace the value in the database with the human readable "translation?"