Home » Google » Looker Business Analyst » Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?
An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.
Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?
A. pivot_offset()
B. lookup()
C. offset_list()
D. offset()
ANSWER: D
Explanation:
Reference: https://help.looker.com/hc/en-us/articles/360023509454-Calculating-Percent-of-Previous-and-Percent-Changewith-Table-Calculations
Download Printable PDF. VALID exam to help you PASS.
|
|