One of the best and simple explanation of Context filters. Been using Tableau for couple of years but never really understood what Context Filters were and how best to use them. Your example was perfect. Thank you Bhaji.
Thanks Rajan for your kind works. I am glad that I am able to help the community by sharing my knowledge and experience. Stay tuned for more such videos.
I didn't get when you explained the difference between data source filter and extract filter. Can you please explain in simple and clear way with other example
Hi Vicky, Thanks for your feedback. As per the definition : Extract filter is a pre condition filter before data extract is created. Data source filter is a post condition filter while displaying the data in the visualisation i.e it is applied to the query while pulling the data from extract. Lets take an example: Assume we have a sale table with 100 rows. 50 rows refer to Sales in India 25 rows refer to Sale in US 25 rows refer to Sales in Australia If we need Better performance and are only looking at data for Sales in India than we will apply extract filter and it will create a .tde extract with only 50 rows. Now for same scenario if we apply data source filter for Sales in India, but in this case the volume of records in extraction time will not reduce. first it will extract all 100 rows and create .tde extract file. Once that is created it will then it will apply data source filter to reduce the data to 50 rows.. every calculation happening in the workbook, will go through all 100 rows which will impact the performance. Another use cases data source filter and extract filter : Lets say you publish this sales data source table for Asia pacific region with 75 rows (India + Aus) in table server or tableau online for self service purpose. In this case you will apply Extract filter An analyst in Aus in only interested in Aus. data so will apply data source filter to get 25 rows on live published data source Another analyst in India is only in India data so will apply data source filter to get 50 rows on live published data source. Hope that clarifies :-) Please feel free to reach out if you more info. Cheers! Gurpreet
One of the best and simple explanation of Context filters. Been using Tableau for couple of years but never really understood what Context Filters were and how best to use them. Your example was perfect. Thank you Bhaji.
Thanks Rajan for your kind works.
I am glad that I am able to help the community by sharing my knowledge and experience.
Stay tuned for more such videos.
Thank you for so detailed informations 😃
Great video lesson)
Glad it was helpful!
First like and first view
Thanks Durga
I didn't get when you explained the difference between data source filter and extract filter. Can you please explain in simple and clear way with other example
Hi Vicky,
Thanks for your feedback. As per the definition :
Extract filter is a pre condition filter before data extract is created.
Data source filter is a post condition filter while displaying the data in the visualisation i.e it is applied to the query while pulling the data from extract.
Lets take an example:
Assume we have a sale table with 100 rows.
50 rows refer to Sales in India
25 rows refer to Sale in US
25 rows refer to Sales in Australia
If we need Better performance and are only looking at data for Sales in India than we will apply extract filter and it will create a .tde extract with only 50 rows.
Now for same scenario if we apply data source filter for Sales in India, but in this case the volume of records in extraction time will not reduce. first it will extract all 100 rows and create .tde extract file. Once that is created it will then it will apply data source filter to reduce the data to 50 rows.. every calculation happening in the workbook, will go through all 100 rows which will impact the performance.
Another use cases data source filter and extract filter : Lets say you publish this sales data source table for Asia pacific region with 75 rows (India + Aus) in table server or tableau online for self service purpose. In this case you will apply Extract filter
An analyst in Aus in only interested in Aus. data so will apply data source filter to get 25 rows on live published data source
Another analyst in India is only in India data so will apply data source filter to get 50 rows on live published data source.
Hope that clarifies :-)
Please feel free to reach out if you more info.
Cheers!
Gurpreet