Class Five: Calculations

Question 1

How to use reference lines?

Answer 1

1. build out regular chart
2. click on the axis and say add reference line?
3. drop the average into the detail area in the chart
4. you can add it in as a reference line now!

Question 2

to clean

Answer 2

1. keep no decimal places
2. colour oNLY IF IT ADDS VALUE
3. drop grid lines if you are labelling the values (they are not needed)
4. change the title
5. Declutter
   Remove gridlines
   Adding labels
   Use appropriate colour
   Use appropriate shape

Question 3

how to combiine line charts?

Answer 3

move the pill to the axis

Question 4

how to make things dual axis

Answer 4

drag the pill to the right axis

Question 5

how to make a combined line and bar chart

Answer 5

make the lines into a bar! in the left hand marks dash board

Question 6

Aggregate Calculations:

Answer 6

A single number at the bottom of the original column

but you need to use the aggregate functions (sum/average etc.)

Question 7

What does the rank function do? You can put it into a calculated field

Answer 7

RANK(SUM([Profit])). or RANK(SUM([Attribute])

Question 8

zn()

Answer 8

strips characters

Question 9

RANK(expression, [‘asc’|’desc’])

Answer 9

This returns the standard competition rank for the current row in the partition.

Identical values are assigned an identical rank. Use the optional ‘asc’ | ‘desc’ argument to specify ascending or descending order. The default is descending

Question 10

WINDOW_AVG(expression, [start, end])

Answer 10

‒ This returns the average of the expression within the window. The window is defined
by means of offsets from the current row