Looker Business Analyst: LOOKER-BUSINESS-ANALYST

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?

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

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

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

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

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

Which filter expression should the business analyst use?

A. 7 days from now

B. After Today's Date for 7 days

C. Today for 7 days

D. For 7 days

An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.

How should that metric be calculated?

A. Add a Sum measure to the Explore and re-run the query.

B. Add a table calculation that calls running_portal (${users.signup_count})

C. Add a custom measure of type: running_total

D. Add a table calculation that calls ${users.signup_count:total}