DNU Unit 3 Lesson 6 + 7

Question 1

Can you convert story filters to page filters

Answer 1

yes

Question 2

What is a section

Answer 2

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

Question 3

What type of page can you use a section for

Answer 3

Canvas

Question 4

What are the two behaviors of a section

Answer 4

• Display section instances on multiple pages

- display a carousel so you can search dimension values

Question 5

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

Answer 5

• quickly see what filters are in effect

Question 6

what are the 2 types of input controls

Answer 6

• Dimension input control

- Measure input control

Question 7

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

Answer 7

measure input control

Question 8

When using input control for time, what are the two ranges that can be used:

Answer 8

• fixed

- dynamic (based on current date)

Question 9

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

Answer 9

1. Apply selected dimension as a filter

2. Cascading effect

Question 10

What is a dimension tuple

Answer 10

-a condition which contains a number of dimension filters

Question 11

Where can advanced filters be used (2)

Answer 11

• page

- story

Question 12

What filter types are available with advanced filters (4)

Answer 12

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

Question 13

What would create an asymmetrical filter

Answer 13

If dimension members in an advanced filter are different

Question 14

What is a component filter

Answer 14

Filter on a component of a chart/table. EG, filter on Product type

Question 15

What are the two types of component filters

Answer 15

• single filter

- predefined filter (eg, ranking)

Question 16

What are the two uses of a time series chart

Answer 16

• show absolute value of a data point

- show the relative % difference

Question 17

How do you calculate the relative % difference

Answer 17

• 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 18

You can only sort on measures in the chart

Answer 18

False - advanced sorting lets you sort on measures not in the chart

Question 19

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

Answer 19

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

Question 20

What is Break Grouping and when do you use it?

Answer 20

• 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