1 of 1 people found this helpful
Your options are:
- Custom SQL - you will have to write a query (SQL) that will only select what you want from the data source.
- Context filter - same thing, but Tableau will do all the hard work of writing SQL
- Normal filter - will work just like context filter if the data source is relatively small.
But if I have GBs of data and I just want to extract for a particular grade .Is there any work around?As now I just tried by connecting live to the data
What is your data source? How is it structured?
For example, instead of connecting directly to a table, you can use custom SQL along these lines:
SELECT * FROM some_table WHERE grade = 'B'
But I want the extract should be created based on user input.
My data has columns like
Grade Student's Name Father's Name Subject Marks Location Address
I am not sure I understand the desired workflow here.
You want user to select grade and then what? Get Tableau to extract data only for that grade?
If yes, and if user is using Tableau Desktop, then you can try using extract's built-in filters, following these steps:
- Create parameter that will allow user to select a grade, call it Selected Grade
- Create calculated field called Is selected grade using formula: [Grade] == [Selected Grade]
- Execute data extract - when extract dialog appears, add a filter as shown in the screenshot below
- Instruct user to select a grade using parameter and execute/refresh the extract - the filter will be there and will take care of the rest
Thanks Dmitri this I guess resolves my problem
Dmitri but on changing the value in input parameter the extract is not getting refreshed.Do you know how to auto-update the refresh
There is no way to automatically trigger extract refresh via filter or parameter control. This has to be done manually by the user.