Test 2 - Filters and Misc Hard Flashcards
What are 3 ways you can create filters?
- Select data points in view to keep or exclude
- Select headers to keep or exclude entire columns/rows
- Drag dimensions, measures, and date fields to the Filters shelf
What types of filters can you use on dimensions?
- General
- Wildcard
- Condition
- Top
What is the first step in filtering a measure?
Aggregation
In what ways can you filter measures?
- Range of values
- At least
- At most
- Special (to filter on nulls)
In what ways can you filter dates?
- Relative dates
- Range of dates
- Discrete dates
- Latest date
- Individual dates
- Special (to filter on nulls)
How do you add an extract filter?
- Select ‘Extract’ in the data source pane and Edit
- Click Edit next to Filters
- Select Add Filter
How do you create a data source filter?
- Click Add under Filters in the data source pane
- Click Add…
How do you create a context filter?
Click the dropdown on an existing filter and select ‘Add to Context’
How do you apply filters to multiple sheets and data sources?
Right click a field in the filters shelf and select the appropriate options
What fields are required to create a forecast?
a date dimension and a measure
How can you add a forecast to the view?
- Right click the view and select Forecast>Show Forecast
- Analysis pane>Forecast>Show Forecast
How do you rename a column?
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
How do you use a parameter as a reference line?
- Create the parameter
- Add a reference line
- In the reference line dialog box, select your parameter under Value
In what ways can you create groups?
- Select data in the view and click on the paperclip icon in the tooltip or toolbar
- Right click a field in the data pane>Create>Group
What is the purpose of groups?
combine related members in a field
What is the purpose of sets?
compare and ask questions about a subset of data
How do you create a dynamic set?
Right click a dimension in the data pane>Create>Set
How do you create a fixed set?
Select one or more marks or headers in the view, right click, select Create Set
What fields are needed to create a symbol map?
Lat in rows, Long in columns, location in detail, measure in size
What fields are needed to create a heat map?
Dimension in rows, measure in label and color, mark type square
What fields are needed to create a density map?
Lat in rows, long in columns, location in detail, measure in color, mark type density
What fields are needed to create a chloropleth map?
Lat in rows, long in columns, location in detail, measure in color, automatic marks
How do you remove grid lines and row or column bands?
Format in main menu> Lines or Shading as needed