Customizing / Reformatting data in Insight

Issue

What options exists in Insight to customize / reformat data showing in a record or metric?

Solution

There are several:

1. Use derived fields and review the options available there. There are SQL functions available.

https://docshield.kofax.com/Insight/...erived%20field

2. If none of those help, you can create custom SQL Functions that mirror the native database engine's functions.
https://docshield.kofax.com/Insight/...functions.html

Search the Online Help for your specific Insight version for additional information.
 

Level of Complexity 

Moderate

Applies to  

References

https://knowledge.kofax.com/Business..._Documentation