3.6 Filtering Data in Stories Flashcards
Can you convert story filters to page filters
yes
what data do prompt filters apply to in a story
all tables and charts
what are the 2 types of input controls
- dimension input control
- measure input control
what can you use to filter by measure value (2)
- in an input control
- in a page filter
2 ways to change how members are displayed in a dim input control
- from builder panel - set all dims to use same display settings
- from Dimension input control - set each dim to use diff display settings
what is a difference between a dim and measure input control
- measure input controls can be used with multiple cross calcs
what’s 2 different range types for time input controls
- fixed
- dynamic (based on current date)
for a time input control, how do you offset the range from the current date?
- when you’re setting up the input control, you can pick “Previous” or “next” > year/month/etc
What type of input control can be used with multiple cross calculations
measure input control
what is chart-to-chart filtering
- you can setup filters to jump from one page to another
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 option do you need to select on the hyperlink to create a cascading filter
under hyperlink options:
- apply selected dimension as a filter
- cascading effect
What is a section
- container for your story to split report into smaller parts
- allows you to break down widgets by dimension
what happens when you apply a filter to a section?
widgets in the section , that are based on the same model will be filtered for that member
What are the two behaviors of a section that you can choose from
- Display section instances on multiple pages
- display a carousel, which lets you search for 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 filter types are available with advanced filters (4)
- AND
- OR
- include/exclude results
- nested conditions
What is a dimension tuple
-a condition which contains a number of dimension filters
What would create an asymmetrical filter
If dimension members in an advanced filter are different
Where can advanced filters be used (2)
- page
- story
by default, changes you make to a story or page filter affect related filters in the same story or page (t/f)
true
how do you turn off the cascading filter effect
> under More options for specific filter or input control
What is a component filter
Filter data in a component (eg, a chart/table) EG, filter on Product type
What are the two types of component filters
- single filter
- predefined filter (eg, ranking)
how do you filter on a component on a chart? (steps)
right click and apply filter
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
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
