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 🙂
JorgePinho
Solution Sage
Solution SageCan'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?