Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

Chelsie Eiden's Duration

Chelsie Eiden is my new favorite human being on the face of the planet. I don't know her major but, even if she is majoring in math, it still wouldn't change my mind on this one. That's how much I li...
Other
Time Intelligence
Totals
strifler's avatar
strifler
Frequent Visitor
4 years ago

Hi Greg!

Formatting the value works properly, but I think we cannot visualize it

because the 1:00:00 bar shouldn't be ~40% larger than the 00:59:50 bar, since the difference is only 10 seconds (<1%), right?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    strifler Well, the underlying numbers are 10000 and 6000 so, yes, that is an issue.

  • MysticSloth's avatar
    MysticSloth
    New Member
    3 years ago

    Since May you can solve this problem by using measure calculating only minutes in y-axis and original measure on custom data label. 

     

    Take hours out of the original measure:

    duration in minutes =

    VAR Duration = SUM(Sheet1[Call Duration total seconds])
    VAR Hours = INT ( Duration / 3600)
    VAR Minutes = INT ( MOD( Duration - ( Hours * 3600 ),3600 ) / 60)
    VAR Seconds = ROUNDUP(MOD ( MOD( Duration - ( Hours * 3600 ),3600 ), 60 ),0)
    RETURN
    (Hours * 60 + Minutes) * 100 + Seconds
     
    And use the original measure in Visual->Data Labels->Values->Custom label. Maybe hide y-axis if you feel like it.
     
    Like this
     
     
    • BugmanJ's avatar
      BugmanJ
      Icon for Helper V rankHelper V
      3 years ago

      It would be great if you could show how this is now being done with an example please? Thank you!!