DNU Unit 3 Lesson 6 + 7 Flashcards
Can you convert story filters to page filters
yes
What is a section
- container for your story to split report into smaller parts
- allows you to break down widgets by dimension
What type of page can you use a section for
Canvas
What are the two behaviors of a section
- Display section instances on multiple pages
- display a carousel so you can search dimension values
What is the purpose of the “Controls” tab (next to the edit/view tabs in a story)
- quickly see what filters are in effect
what are the 2 types of input controls
- Dimension input control
- Measure input control
What type of input control can be used with multiple cross calculations
measure input control
When using input control for time, what are the two ranges that can be used:
- fixed
- dynamic (based on current date)
What are the 2 options to create a chart to chart filter using a hyperlink
- Apply selected dimension as a filter
2. Cascading effect
What is a dimension tuple
-a condition which contains a number of dimension filters
Where can advanced filters be used (2)
- page
- story
What filter types are available with advanced filters (4)
- AND
- OR
- include/exclude results
- nested exceptions
What would create an asymmetrical filter
If dimension members in an advanced filter are different
What is a component filter
Filter on a component of a chart/table. EG, filter on Product type
What are the two types of component filters
- single filter
- predefined filter (eg, ranking)
What are the two uses of a time series chart
- show absolute value of a data point
- show the relative % difference
How do you calculate the relative % difference
- Difference between the first visible data point, and all other data points.
- values will change as you change time, eg, and the first data point may change
You can only sort on measures in the chart
False - advanced sorting lets you sort on measures not in the chart
How do you create a custom sort in a table/chart
Add a custom order, and drag and drop desired order.
What is Break Grouping and when do you use it?
- use when there are multiple cols/rows
- when enabled, it applies the sort to the selected column/row first
- if not enabled, sort is applied to the outer col/row first
