An analyst needs to compare monthly sales, year over year, based on when an order...

Vendor: Google
Product: Looker-Business-Analyst
Update on: Nov 1, 2025
Questions: 40

Google Looker-Business-Analyst Question Answer

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

Select the dimension Created Month, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

Google Looker-Business-Analyst Summary

Price: $52.5 ~~$149.99~~