Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Convert seconds into hours and their format

I have a graph that presents the phrases in internal numbers, these values are in seconds and I need to convert this number in hours and present these values in the graph in the format of hh: mm: ss....
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    To convert the second to hours, you only need to divide it by 3600.

    TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")/3600

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

We are able to convert seconds into hours with format "hh:mm:ss".

hh:mm:ss = 
RIGHT ( "0" & INT ( Table[seconds] / 3600 ), 2 )
    & ":"
    & RIGHT (
        "0"
            & INT ( ( Table[seconds] - INT (Table[seconds] / 3600 ) * 3600 ) / 60 ),
        2
    )
    & ":"
    & RIGHT ( "0" & MOD (Table[seconds], 3600 ), 2 )

 

But after formatting, values will be set to text data type. It is not possible to show actual values of text data in a bar chart, because it will be aggregated (Count/Count Distinct) automatically if adding it into values section in a chart visual.

 

So, your requirement cannot be achieved currently.

 

Best regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-yulgu-msft

 

In this case I will then display the value in hours not displaying the format "hh: mm: ss", using the measure that I am already using what change should I make for it?

TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    To convert the second to hours, you only need to divide it by 3600.

    TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")/3600

     

    Best regards,
    Yuliana Gu