Unit 3.2 Config Charts & Tables + 3.3 Conditional Formatting

Question 1

what are the 3 uses of a text widget in a story

Answer 1

1. Enter your own labels
2. Use hyperlinks to access stories/pages
3. Dynamic text (Date, current user, or Dim members)

Question 2

What are the 3 types of dynamic text that can be used in a Text Widget

Answer 2

1. Date
2. Current user
3. Dimension members (can be from source input control or filters, or dim filters)

Question 3

How to create a hyperlink in a text widget

Answer 3

Highlight text and right click > hyperlink..

Question 4

If you select a table and chose “examine”, what will show up?

Answer 4

A chart below the table. Vice versa if you select a chart, a table will show.

Question 5

2 uses of chart scaling

Answer 5

1. set bar widths for several charts at one time

2. Consistent display of values

Question 6

Chart types (5)

Answer 6

1. Comparison
2. Trend
3. Distribution
4. Indicator
5. Other: Donut, Pie, Marimekkto

Question 7

If change chart scaling, it only applies to the selected chart.

Answer 7

No, it applies to all pages in the story. But, scaling may be different for the same measure of different pages, because scaling factor is calculated separately for each page.

Question 8

You can exclude some charts from scaling

Answer 8

Yes

Question 9

When should you use a comparison-variance chart

Answer 9

Can use variance for any 2 measures

1. Show the difference between versions of a measure
2. Difference between time periods

Question 10

What is a trellis chart

Answer 10

A trellis chart will replicate your chart for each dimension (eg, repeat bar chart of each region)

Question 11

Where do you write R scripts for visualizations

Answer 11

Built-in IDE (an R server runtime environment) on top of existing data models

Question 12

R serve deployed by SAC is provided for what datacenters (5)

Answer 12

EU1
EUDP
AP1
US1
US2

Question 13

Where can you use the R visualizations widget

Answer 13

1. Stories

2. Analytic applications

Question 14

What is used to add in a word cloud chart

Answer 14

R visualization widget

Question 15

Thresholds can only be applied to what field?

Answer 15

account members and measures

Question 16

Where can you apply thresholds (2)

Answer 16

1. In a story (applies to entire story)

2. In a model (applies to all stories where that model is used)

Question 17

Threshold styles are the same in a story as in an Analytical Application

Answer 17

True

Question 18

what can you apply conditional formatting to in a chart (2)

Answer 18

• measure in a chart

- in builder pane, the colour definition for a chart

Question 19

what can you apply conditional formatting to in a table (2)

Answer 19

• in builder pane, to a measure