Hey everyone!
I'm a newbie to Tableau. I've been stuck on some calculations that I'm not sure how to go about. I'll try my best to explain it.
Basically, I've union-ed a table to itself and I need to give each row a number (aka Point number in my file). I've used Index() to get the row number but I can't work out how to use this field for other calculations in other calc fields.
Here's a screenshot of an example table in Excel of what I was trying to achieve in Tableau:
The blank fields -- Angle degrees, Angle radians, X and Y -- are ones I'm struggling with as everything hinge on Angle degrees which is currently giving the error "Cannot mix Aggregate and Non Aggregate Arguments".
I've attached the workbook here. I appreciate any input!
Thank you!
Han
Hello,
You get "Cannot mix Aggregate and Non Aggregate Arguments" because one of your columns from the formula aren't aggregated (index is an aggregation). You should aggregate with Sum/Min/Max.
See the workbook attached.
If this post resolves the question, would you please "Select as Best"? This will help other people find the same answer and help community keep track of answered questions.
Thank you.
