Perform calculation for pie chart

[jamesjj]

I'm probably over complicating this but here goes. I have time field that I have converted to a decimal number (time field/24), as an example converts 15 minutes to .25

I have a pie chart that sums the time/person. The pie chart displays the sum correctly (eg will show 1.3k, as in 1300 minutes, but would like to show it in hours now(21.6 hours). 

Is this possible, is there an easier way to do this? Any help is ap

[jamesjj]

I can't seem to get the field into the calculation. Neither the original time field, or the calculated decimal field are available or work in the calculation. 

[JorgePinho]

Try this : Time_Hours = DIVIDE(MAX(Time_Minutes),60) 

[jamesjj · Accepted solution]

So.... I accidently figured this out. I discovered I had a couple hundred entires that were a negative number and for some reason throwing this way out of whack. My original new column (time *24)-24 without anything fixed the issue. 

Next time I'll wait a day before I post a question 🙂

[jamesjj]

Tried this one and is looking for a second argument, although when I put a another number after the "60" it says I have 2 many arguments lol. Without "Max" in the equation, the option to pick the field does not come up. Am I maybe going about this wrong? I choose Modeling>New Measure and type in equation..

[JorgePinho]

Can't you just create a measure like this Time_Hours = DIVIDE(Time_Minutes,60) and use it in the chart instead of the minutes field you are using?