how to summarize data group by specific date range?

Xin Xu-147583

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?

WVanSluys1

Create a Calendar Dimension table with specific dates assigned to range name

Create a calculated column CASE WHEN DATE > 1/1/2021 and DATE < 2/15/2021 THEN Range1   etc

 

 

Xin Xu-147583

Wvansluys, Thanks your reply. But the start date and end date records are too many, it is not possible to define all of of them in a calculation.

Neeti Choksi-Oracle

Hi,

You can write a data flow with the joins between your date column (in detailed dataset) and your range dates (from your range table). Please find the attached image for the reference.

Regards,

Neeti