How to Format SLA Durations in eazyBI Reports
This article explains how to convert raw SLA duration values (exported in seconds) into human-readable formats such as 2d 5h 8m in eazyBI.
Summary
By default, Time to SLA exports all duration metrics such as Working Duration, Remaining Duration, and Overdue Duration to eazyBI as integers representing total seconds. While this format is ideal for calculations (like averages or sums), it is not intuitive for end-user reporting.
This guide provides the steps to reformat these values into a standard duration string within the eazyBI interface.
Use case: Converting seconds to "2d 5h 8m" format
Customers integrating Time to SLA with eazyBI often find that their reports display large numeric values (for example, 190800 seconds) instead of readable time units (for example, 2d 5h).
Prerequisites
Time to SLA is successfully integrated with eazyBI.
SLA measures (for example,
SLA Working Duration) have been imported into the eazyBI cube.
Solution: Reformatting in eazyBI
Since the data is exported as numeric seconds to allow for mathematical processing, the formatting of the data must happen on the eazyBI side using Calculated Measures and Formatting.
Step 1: Create or locate the SLA measure
Open your eazyBI report.
Locate the SLA measure you want to format (for example,
SLA Working DurationorSLA Remaining Duration).
Step 2: Apply duration formatting
eazyBI has a built-in formatting engine that can automatically interpret a large number of seconds as a duration.
Click the Measures section.
Find your calculated measure and click Edit (or create a new one that references the original SLA field).
In the Formatting dropdown menu, select one of the following:
Duration (##d ##h ##m): Best for high-level management reports.
Duration (##h ##m ##s): Best for detailed technical or operational reports.
Step 3: Advanced conversion (optional)
If you need more complex transformations, such as converting decimals to hours/minutes or using specific work-day logic, you can use eazyBI's MDX functions.