5 Replies Latest reply on Jun 8, 2012 12:01 PM by Tracy Rodgers

    Alternative to RAWSQL_REAL to override filters and create a calculated constant

    Chris Ralph

      I have a calculated variable (A) that I'd like to use to create a new constant variable (B), where every row in my Tableau data table should be equal to the overall average of A.  I've read some posts that use RAWSQL_REAL to do this to create an index relative to an overall sum or average, but the RAWSQL_REAL function won't work in my worksheet (presumably because I'm using a Tableau extract table as my data source). 

       

      Is there any way to do this?  Please note that manually creating a secondary data source is not an option.. I need to do this within my worksheet because the original calculated variable (A) can be changed via parameters.

       

      Any help with this would be very greatly appreciated!!

      Chris