We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to summarize data group by specific date range?

Received Response
8
Views
3
Comments
edited Dec 4, 2020 9:49AM in Oracle Analytics 3 comments

Summary

want to summarize not in a regular calendar date range

Content

In OAC or DVD

For example, I have a table with  detail data from Jan. 01~ Dec. 31.

I have another table to define the date range for summary. Let's say, summarize data from Jan.01 ~ Feb.15 (start_date Jan 01, end_date Feb 15), Feb 16 ~Mar 20  (start_date Feb 16, end_date March 20)...etc. The date Range could be random depending on the business requirement.

how to summarize the data by specific date range?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!