I have an indicator of how late the event occurred. It is measured in hours. I need a KPI as a mean value. There are no problems. The problem is in the format of values. I want to output the resulting average value in the format HH: MI. How can I do this? thank you
Сan someone know how in Format Setting to replace Decimal Separator "," (or other available) on ":"?
Example, instead of "1,2" - "1:2"?
Perhaps you should consider casting the result to separate dataitems as varchar and concatenating them with ':':
[dataitem1]||':'||[dataitem2]
Unfortunately, in this case the number is converted to text, not the average value calculated. I decided to go the other way - to replace the Decimal Separator ":", but the available no '". Maybe in the global settings this can be done - I do not know