Description: In the fact tables, metrics are stored as integers. In the Analysis, there is an option to "Override Default Data Format" using a custom format that converts these integers into a hh:mm:ss format (Custom Numeric Format - [duration(sec)]hh:mm:ss
). However, in the workbook, there is no option for applying custom data formatting.
Use Case and Business Need: We are developing reports using the workbook for a contact center. The tables contain several columns that store time-based metrics (e.g., Talk Time, Handle Time, etc.) as integers in seconds. These columns need to be formatted to display in an HH:MM:SS
format for better clarity in reporting.
