Forum Discussion
Perform calculation for pie chart
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
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 🙂
5 Replies
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?
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.
Try this : Time_Hours = DIVIDE(MAX(Time_Minutes),60)
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 🙂
