1 of 1 people found this helpful
Is there a "Show query" button on that error dialog? If yes - could you paste (or attach in txt file) that query here?
If not - could you pull up the whole query from log.txt (under repository's Logs directory)?
And if I read documentation correctly - aren't you missing OVER part of the expression?
Hi, yes.... U got it, I missed the OVER part
Ok, I encountered another weird problem.
Adding the "Over" clause seems like it works, but it prompted another error "...must appear in the GROUP BY clause or be used in an aggregate function"".
RAWSQLAGG_REAL("PERCENTILE_CONT (0.20) WITHIN GROUP (ORDER BY %1 ASC) OVER (PARTITION BY %2)", [SPEED], [ROAD])
However, when I adding this field calculation to the viz in Tableau, it gives an AGG(field calculation). Desipte this, why doesn't the it doesn't automatically add the variables to group by backend? Is this a limitation for raw sql queries?