BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Tableau Exam TDS-C01 Topic 7 Question 21 Discussion

Actual exam question for Tableau's TDS-C01 exam
Question #: 21
Topic #: 7
[All TDS-C01 Questions]

If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Show Suggested Answer Hide Answer
Suggested Answer: A, D

By default, all filters that you set in Tableau are computedindependently. That is, each filter accesses all rows in your data source without regard to other filters. However, you can set one or more categorical filters as context filters for the view.You can think of a context filter as being an independent filter (Option stating - To create a dependent filter eliminated here).Any other filters that you set are defined as dependent filters because they process only the data that passes through the context filter.

You may create a context filter to:

1) Improve performance --If you set a lot of filters or have a large data source, the queries can be slow. You can set one or more context filters to improve performance.

2) Create a dependent numerical or top N filter --You can set a context filter to include only the data of interest, and then set a numerical or a top N filter.

For example, suppose you're in charge of breakfast products for a large grocery chain. Your task is to find the top 10 breakfast products by profitability for all stores. If the data source isvery large, you can set a context filter to includeonlybreakfast products. Then you can create a top 10 filter by profit as a dependent filter, which would process only the data that passes through the context filter.


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel