nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Summarize Dates within Range

Associate_1121

Hello,

I am having trouble figuring out how to do this. Essentially, I have changing ranges in one column. Every individual date has a count as either a 0 or a 1. I want to sum all of the counts within the selected range. For example, if the range is Jan 1-Jan 5, then the new column would give a total of 3 in the attached picture.

Date Time

Accepted answers

jdunkerley79

If I have understood correctly, you want the total of Count when Start Date is in the Range specified.

If this is correct, I suggest:

First create a running total

Next convert so a complete sequence of dates (start and end)

Make it unique in case a date in both start and end (making sure the union put start before end)

Use a multi-row to copy down the running totals

You can then join to get the end date running total

Finally a formula tool to compute totals

Hope this is what you meant

Sample attached

Range Dates Total.yxmd

All comments

JordanB

Hi @Associate_1121

I have attached an example of how you can build these business rules and aggregate the data. I am not sure what your ranges are so I can't build anything dynamic, but this should give you a good idea.

Best,

Jordan

Sample Flag.yxmd

Associate_1121

Hi @JordanB,

Thank you for your response. Perhaps I explained it incorrectly. The ranges actually change for each row. The ranges are included in the row. Is it possible to get totals for the range specified in that row by adding all rows with dates that fall within that range?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703