Forum Discussion
Perform calculation for pie chart
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)
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 🙂
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..
