Field that displays time units but functions like a number

Q&A
, , ,
1

I need to display a field that represents the time duration of a particular process step by customer, but the values of the field vary greatly by customer. For example, Customer A often has duration in minutes, Customer B has duration in hours, and Customer C often has duration in days. To make it easy for the user to read, we’d like to display the appropriate units based on the size of the duration (i.e. in “min” if under an hour, in hours if under 24 hours, etc).

In the past, we’ve added the units to a new string calculated field based on the duration size. However, the visual we are using is a KPI visual that can only take numbers - if we try to use the calculated field, it won’t be able to compare between the actual and target values since they are strings.

Is there any way to format the display in the KPI (or any visual) to include timescale units (sec, min, hrs, days) dynamically based on size? Or any other solution where we can change the unit display based on the duration size in a KPI visual?

Examples:

  • 5 days
  • 12.2 min
  • 3 hrs

image
image316×1149 29.4 KB

2

Hi @schirrj,

To achieve what you are looking it won’t be possible with KPI charts. If you want to have comparison between the previous value and the new value, it would be possible to achieve what you want with custom insight and metric comparison computation to compare metrics and then add the additional text in the custom visual itself with ifelse constructs.

Thanks,
Sri

1 Like