What options exists in Insight to customize / reformat data showing in a record or metric?
There are several:
1. Use derived fields and review the options available there. There are SQL functions available.
2. If none of those help, you can create custom SQL Functions that mirror the native database engine's functions.
Search the Online Help for your specific Insight version for additional information.
Level of Complexity
Article # 3046911