Forum Discussion
Solved
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 ...
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 🙂
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)