Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
how to summarize data group by specific date range?
Summary
want to summarize not in a regular calendar date rangeContent
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?
Tagged:
0