Limitations of RAWSQL functions?

tableaucommunity@tableau.com — Thu, 17 Jul 2008 21:30:58 GMT

I am trying to extract a value based on 2 dimensions: given a list of Condition1, Condition2, Value return Value for Condition1=C1 and every C2.

I want to use the result of this calculation to compute the ratio of Value to this reference value for each condition in Condition2 . I was trying to use RAWSQL functions for that but although the following query works

RAWSQL('select avg(%1) from "TableauExtract" where "Condition1"=%2 and "Condition2"=%3',[Value],"C1",[Condition2])

it returns the average Value over the full dataset and not by Condition2. It is also throwing an error ( "Firebird database error 335544652: multiple rows in singleton select") when I remove the avg() around %1. Is there anything I am missing here?

Many thanks in advance,

Yann

Content in Tableau Community Forums

Limitations of RAWSQL functions?