-
1. Re: Is there a way to modify the query that gets ran when tableau fetches data?
Russell Christopher Feb 7, 2013 10:44 AM (in response to Tremain Keith)Hey Tremain -
There isn't a way to do this. However, can you expand on your "why I want to do this" a little bit?
You said: e.g. changing what columns are included in the select statement
Why would this be helpful?
-
2. Re: Is there a way to modify the query that gets ran when tableau fetches data?
Tremain Keith Feb 7, 2013 11:01 AM (in response to Russell Christopher)Well I have created a Dashboard that uses 3 different sheets. All the sheet require the same data source, and the data is a join of 2 tables; one that logs Test Defects for an application and one the logs Prod. Incidents. They are joined together by an application_code. On one of the sheets I am recording the total Defects and Incidents for a each month, however because the tables are joined by the application_code if, for example, an application has 5 defects for January and 1 incident for January, search results display 5 rows of defect info (which is correct) but attaches that 1 incident that shares the application code to the five defects. This makes it seem as if there are 5 incidents, but it's really that 1 incident repeated 5 times.
If I could choose the columns in the select statement, I could choose the columns that are related to the defects and do a sum of records to get the number of defects and choose the columns that are related to incidents and do a count distinct to get the sum incidents.
I hope this makes sense.