Test 2 - Filters and Misc Hard

Question 1

What are 3 ways you can create filters?

Answer 1

1. Select data points in view to keep or exclude
2. Select headers to keep or exclude entire columns/rows
3. Drag dimensions, measures, and date fields to the Filters shelf

Question 2

What types of filters can you use on dimensions?

Answer 2

1. General
2. Wildcard
3. Condition
4. Top

Question 3

What is the first step in filtering a measure?

Answer 3

Aggregation

Question 4

In what ways can you filter measures?

Answer 4

1. Range of values
2. At least
3. At most
4. Special (to filter on nulls)

Question 5

In what ways can you filter dates?

Answer 5

1. Relative dates
2. Range of dates
3. Discrete dates
4. Latest date
5. Individual dates
6. Special (to filter on nulls)

Question 6

How do you add an extract filter?

Answer 6

1. Select ‘Extract’ in the data source pane and Edit
2. Click Edit next to Filters
3. Select Add Filter

Question 7

How do you create a data source filter?

Answer 7

1. Click Add under Filters in the data source pane
2. Click Add…

Question 8

How do you create a context filter?

Answer 8

Click the dropdown on an existing filter and select ‘Add to Context’

Question 9

How do you apply filters to multiple sheets and data sources?

Answer 9

Right click a field in the filters shelf and select the appropriate options

Question 10

What fields are required to create a forecast?

Answer 10

a date dimension and a measure

Question 11

How can you add a forecast to the view?

Answer 11

1. Right click the view and select Forecast>Show Forecast
2. Analysis pane>Forecast>Show Forecast

Question 12

How do you rename a column?

Answer 12

Data Source pane: double-click or use the dropdown on a column header and select Rename

Data pane: drop down or click and tap and select rename

Question 13

How do you use a parameter as a reference line?

Answer 13

1. Create the parameter
2. Add a reference line
3. In the reference line dialog box, select your parameter under Value

Question 14

In what ways can you create groups?

Answer 14

1. Select data in the view and click on the paperclip icon in the tooltip or toolbar
2. Right click a field in the data pane>Create>Group

Question 15

What is the purpose of groups?

Answer 15

combine related members in a field

Question 16

What is the purpose of sets?

Answer 16

compare and ask questions about a subset of data

Question 17

How do you create a dynamic set?

Answer 17

Right click a dimension in the data pane>Create>Set

Question 18

How do you create a fixed set?

Answer 18

Select one or more marks or headers in the view, right click, select Create Set

Question 19

What fields are needed to create a symbol map?

Answer 19

Lat in rows, Long in columns, location in detail, measure in size

Question 20

What fields are needed to create a heat map?

Answer 20

Dimension in rows, measure in label and color, mark type square

Question 21

What fields are needed to create a density map?

Answer 21

Lat in rows, long in columns, location in detail, measure in color, mark type density

Question 22

What fields are needed to create a chloropleth map?

Answer 22

Lat in rows, long in columns, location in detail, measure in color, automatic marks

Question 23

How do you remove grid lines and row or column bands?

Answer 23

Format in main menu> Lines or Shading as needed