Forum Discussion

Jos13's avatar
Jos13
Helper III
5 years ago
Solved

Cannot format measure

Hi All, I was trying to format total duration in hh:mm:ss format in a matrix visual. I wanted to show those employees with duration>100 sec or transactions>20.  I could create a measure for ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Jos13 ,

     

    Please try this:

    Measure = 
var _hour=TRUNC([Total Duration]/3600)
var _min= TRUNC(  MOD([Total Duration],3600)  /60)
var _sec=MOD( MOD([Total Duration],3600),60)
return IF([Total Duration]>100 || [Total Transactions]>20 , TIME(_hour,_min,_sec),BLANK())

    After uncheck the Show items with no data options, the final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jos13 ,

 

Please try this:

Measure = 
var _hour=TRUNC([Total Duration]/3600)
var _min= TRUNC(  MOD([Total Duration],3600)  /60)
var _sec=MOD( MOD([Total Duration],3600),60)
return IF([Total Duration]>100 || [Total Transactions]>20 , TIME(_hour,_min,_sec),BLANK())

After uncheck the Show items with no data options, the final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.