Google Exam Looker-Business-Analyst Topic 8 Question 5 Discussion

Actual exam question for Google's Looker-Business-Analyst exam

Question #: 5
Topic #: 8

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error ''Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time''.

How can the analyst resolve this error while showing the rank as a column visualization?

APivot the Explore by the Brand Name dimension.

BSelect a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

CPivot the Explore by brand Rank.

DSelect a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

Show Suggested Answer

Suggested Answer: D

by Martina at May 04, 2022, 05:01 AM

Limited Time Offer

25%

Off

Get Premium Looker-Business-Analyst Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!