Repeat Data Rows based on Start and End Date

Repeat Data Rows based on Start and End Date

I want to create a capacity heat map in ZOHO. The first step was to develop this query (below) to determine the "Capacity Start Date" , "Hours p/Day Remaining", and "Scheduled End Date." Now that I have all that, I want to create a new query that will essentially reference the one below, but spread those "Hours p/Day Remaining" across all the days between "Capacity Start Date" and "Scheduled End Date" by the Department, Network ID, etc.


The Simplest way to explain the final goal, is that I would like to generate a new "Date" column in the new query, and repeat the entire row of data on each date under the new date column between the Start and End Dates

For instance, if a row (Network) has a "Capacity Start Date" of 4/1/2022 and the "Scheduled End Date" is 4/5/2022 I want to create a NEW DATE COLUMN and repeat that entire row of data using dates 4/1, 4/2, 4/3, 4/4, 4/5 for the NEW DATE COLUMN

Any suggestions on the next step?
SELECT
         "JobStatus" AS "Job Status",
         "Division" AS "Division",
         "DepartmentName" AS "Department",
         "CustomerName" AS "Customer",
         "Network" AS "Network",
         "EstStartDate" "Scheduled Start Date",
         "EstEndDate" AS "Scheduled End Date",
         "ActStartDate" AS "Actual Start Date",
         "ActEndDate" AS "Actual End Date",
         "EstimatedHours" AS "Budgeted Hours",
         "ActualHours" AS "Hours Consumed",
         "Remaining Hours",
         to_integer(date_diff("EstEndDate", current_date())) AS "Remaining Days",
         "Remaining Hours" / to_integer(date_diff("EstEndDate", current_date())) AS "Hours p/Day Remaining",
         "Budget Consumed Percent_Reference Only" * 100 AS "% Of Budget Consumed",
         "PercentComplete" * 100 AS "POC",
         "Kickoff Date",
         "Dock Date",
         "PM",
         "QA",
         "LB",
         (row_number() over()) AS "Auto Number",
         add_date("EstEndDate", ROUND("Remaining Hours" / -24)) AS "Latest Start Date",
         find_max_value(add_date("EstEndDate", ROUND("Remaining Hours" / -24)), current_date()) AS "Capacity Start Date",
          to_integer(date_diff("EstEndDate",find_max_value(add_date("EstEndDate", ROUND("Remaining Hours" / -24)), current_date()))) AS "Capacity Remaining Scheduled Days"
FROM  "Eagle_AllHoursReport" 
WHERE    "JobStatus"  IN ( 'In Process'  )
 AND    "EstEndDate" - current_date()  >= 1
 AND    "Remaining Hours"  >= .01

    • Sticky Posts

    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security