Question

Which of the following techniques would you use to exclude rows with fewer than 10 visits from a report table?

A) use a pivot table with two dimensions
B) sort the table by sessions from highest to lowest
C) add a primary dimension
D) apply a table filter
E) add a secondary dimension

Answer 1

To exclude rows with fewer than 10 visits from a report table, the best option is to apply a table filter, which allows for setting specific display criteria.

Step-by-step explanation:

To exclude rows with fewer than 10 visits from a report table, the most effective technique would be to apply a table filter. This method allows you to set specific criteria for what data should be displayed. For example, by applying a filter for the 'visits' column to only show rows with a value of 10 or more, the report will automatically exclude all rows that do not meet this criterion. This is a direct way to manipulate the data that is displayed without rearranging the structure or needing to add additional dimensions to the table.

Techniques such as using a pivot table with two dimensions or adding a primary or secondary dimension might provide deeper insights into the data, but they would not directly exclude rows based on visit counts. Sorting the table by sessions from highest to lowest would organize the data differently, but again, it would not exclude the rows with fewer than 10 visits.