Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Time on line chart

Hello, would it be possible to display the following line chart with the time in mm:ss instead of seconds? Thank you.    
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous 
    Yes, through conditional format strings in calculations groups.
    Create a calculation item with this formula in the format string expression:

    """" & FORMAT(SELECTEDMEASURE()/86400, "nn:ss")

    Make sure to only use this item on the measures where you want to use it, wither by putting it in the visual level filter or by adding and if condition to the formula above to work only on the measure you want.

    Hope that helps

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous 
Yes, through conditional format strings in calculations groups.
Create a calculation item with this formula in the format string expression:

"""" & FORMAT(SELECTEDMEASURE()/86400, "nn:ss")

Make sure to only use this item on the measures where you want to use it, wither by putting it in the visual level filter or by adding and if condition to the formula above to work only on the measure you want.

Hope that helps