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 🙂
Try this : Time_Hours = DIVIDE(MAX(Time_Minutes),60)
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..