12.18. Quiz

Multiple-choice questions:

1. What are the two types of calculations in Looker Studio? a. Cumulative and comparative b. Comparison and running c. Running and cumulative d. Comparative and running

Correct answer: b

2. Running calculations can be applied to which of the following visualization types? a. Scorecards b. Tables c. Pie charts d. Time series

Correct answer: b, d

3. What is the main difference between comparison and running calculations? a. Comparison calculations can be used in further calculations, while running calculations cannot. b. Comparison calculations are only for display purposes, while running calculations can be used in further calculations. c. Comparison calculations compare a value with the total, maximum, or minimum, while running calculations perform cumulative calculations. d. Running calculations compare a value with the total, maximum, or minimum, while comparison calculations perform cumulative calculations.

Correct answer: c

4. Which of the following is NOT a type of running calculation? a. Running sum b. Running max c. Running median d. Running delta

Correct answer: c

True/false questions:

1. Running calculations can be used in further calculations.
• True
• False

Correct answer: False

2. Sorting data does not affect the way running calculations are displayed.
• True
• False

Correct answer: False

3. Running calculations can only be applied to tables.
• True
• False

Correct answer: False

Fill-in-the-blanks:

1. The ____ calculation shows the difference between the current value and the one before it.

Correct answer: Running delta

2. Comparison calculations compare a value with the ____, ____, or ____.

Correct answer: total, maximum, minimum

Open-ended long answer question:

1. You are analyzing website traffic data in Looker Studio using a table visualization with dates in ascending order. Describe a real-world scenario where running calculations can provide valuable insights and explain which running calculation you would choose and why.

Example of a correct answer:

Suppose you are analyzing the number of daily new users on your website. You want to track the cumulative growth of new users and understand how quickly the user base is growing. In this case, you would choose the running sum calculation to display the cumulative total of new users by date. This would help you identify trends in user growth, spot any irregularities, and assess the overall performance of your user acquisition efforts.