Exam 1z0-1041-23 Topic 3 Question 41 Discussion

Actual exam question for Oracle's 1z0-1041-23 exam
Question #: 41
Topic #: 3
You need to compute sales for a period that starts at a quarter before and ends at a quarter after the current quarter.
Which Time Series function will you use?

Suggested Answer: D Vote an answer

To compute sales for a period that starts at a quarter before and ends at a quarter after the current quarter, you need to use the PERIODROLLING function. This function allows you to calculate the aggregated value of a measure over a rolling time period relative to the current time level. For example, PERIODROLLING("Sales", -1, 1, "Quarter") will return the sum of sales for the current quarter, the previous quarter, and the next quarter. Reference: Oracle Analytics Cloud - Data Visualization User's Guide, Oracle Analytics Cloud - Data Visualization User's Guide

by Perry at Feb 10, 2025, 09:01 AM

Limited Time Offer

15%

Off

Get Premium 1z0-1041-23 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10