3.6 Filtering Data in Stories

Question 1

Can you convert story filters to page filters

Answer 1

yes

Question 2

what data do prompt filters apply to in a story

Answer 2

all tables and charts

Question 3

what are the 2 types of input controls

Answer 3

• dimension input control

- measure input control

Question 4

what can you use to filter by measure value (2)

Answer 4

• in an input control

- in a page filter

Question 5

2 ways to change how members are displayed in a dim input control

Answer 5

1. from builder panel - set all dims to use same display settings
2. from Dimension input control - set each dim to use diff display settings

Question 6

what is a difference between a dim and measure input control

Answer 6

• measure input controls can be used with multiple cross calcs

Question 7

what’s 2 different range types for time input controls

Answer 7

• fixed

- dynamic (based on current date)

Question 8

for a time input control, how do you offset the range from the current date?

Answer 8

• when you’re setting up the input control, you can pick “Previous” or “next” > year/month/etc

Question 9

What type of input control can be used with multiple cross calculations

Answer 9

measure input control

Question 10

what is chart-to-chart filtering

Answer 10

• you can setup filters to jump from one page to another

Question 11

What are the 2 options to create a chart to chart filter using a hyperlink

Answer 11

1. Apply selected dimension as a filter

2. Cascading effect

Question 12

what option do you need to select on the hyperlink to create a cascading filter

Answer 12

under hyperlink options:

• apply selected dimension as a filter
• cascading effect

Question 13

What is a section

Answer 13

• container for your story to split report into smaller parts
• allows you to break down widgets by dimension

Question 14

what happens when you apply a filter to a section?

Answer 14

widgets in the section , that are based on the same model will be filtered for that member

Question 15

What are the two behaviors of a section that you can choose from

Answer 15

• Display section instances on multiple pages

- display a carousel, which lets you search for dimension values

Question 16

What is the purpose of the “Controls” tab (next to the edit/view tabs in a story)

Answer 16

• quickly see what filters are in effect

Question 17

What filter types are available with advanced filters (4)

Answer 17

• AND
• OR
• include/exclude results
• nested conditions

Question 18

What is a dimension tuple

Answer 18

-a condition which contains a number of dimension filters

Question 19

What would create an asymmetrical filter

Answer 19

If dimension members in an advanced filter are different

Question 20

Where can advanced filters be used (2)

Answer 20

• page

- story

Question 21

by default, changes you make to a story or page filter affect related filters in the same story or page (t/f)

Answer 21

true

Question 22

how do you turn off the cascading filter effect

Answer 22

> under More options for specific filter or input control

Question 23

What is a component filter

Answer 23

Filter data in a component (eg, a chart/table) EG, filter on Product type

Question 24

What are the two types of component filters

Answer 24

• single filter

- predefined filter (eg, ranking)

Question 25

how do you filter on a component on a chart? (steps)

Answer 25

right click and apply filter

Question 26

How do you calculate the relative % difference

Answer 26

• 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

Question 27

How do you create a custom sort in a table/chart

Answer 27

Add a custom order, and drag and drop desired order.

Question 28

What is Break Grouping and when do you use it?

Answer 28

• 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