# Result interpretation - Strange aggregate
**URL:** https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066
**Category:** InfluxDB 2
**Tags:** time, query, flux
**Created:** [December 21, 2021, 4:55pm UTC](https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066 "2021-12-21T16:55:01Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Monk](https://community.influxdata.com/u/Monk)
#### Post date: [December 21, 2021, 4:55pm UTC](https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066/1 "2021-12-21T16:55:01Z")
I have following flux query:
```auto
import "date"
thisMonth = date.truncate(t: today(), unit: 1mo)
from(bucket: "home")
|> range(start: thisMonth)
|> filter(fn: (r) => r["_measurement"] == "vzlogger")
|> filter(fn: (r) => r["Source"] == "S0_EG")
|> filter(fn: (r) => r["_field"] == "Energy")
|> aggregateWindow(every: 1d, fn: sum, createEmpty: false)
```
My intention is to get a daily sum across the current month, i.e. one daily total per day of the month.
Above is the screenshot from the InfluxDB UI.
Why am I getting two lines of results for 2021-12-21 (current day)? How to avoid this?
Many thanks for any input and a happy holiday season
---
### Author:  [@scott](https://community.influxdata.com/u/scott)
#### Post date: [December 21, 2021, 5:02pm UTC](https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066/2 "2021-12-21T17:02:11Z")
@Monk aggregateWindow use the `_stop` column of each `1d` window as the new `_time` value of the aggregate points. So where “today” is still in progress, you get a partial window and that `_stop` time of the window is essentially `now()`. One thing to also note is that because it’s using the `_stop` time of each window as the new `_time`, the value is actually that of the previous day.
To solve this, I’d recommend specifying the `_start` as the `timeSrc` in `aggregateWindow()`:
```javascript
import "date"
thisMonth = date.truncate(t: today(), unit: 1mo)
from(bucket: "home")
|> range(start: thisMonth)
|> filter(fn: (r) => r["_measurement"] == "vzlogger")
|> filter(fn: (r) => r["Source"] == "S0_EG")
|> filter(fn: (r) => r["_field"] == "Energy")
|> aggregateWindow(every: 1d, fn: sum, timeSrc: "_start", createEmpty: false)
```
---
### Author:  [@Monk](https://community.influxdata.com/u/Monk)
#### Post date: [December 21, 2021, 5:23pm UTC](https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066/3 "2021-12-21T17:23:02Z")
@scott, many thanks, works like a charm. Still a lot to learn. Although I’m every time amazed by the power of InfluxDB, sometimes it feels like black magic. Thankfully there is such a supportive community.
---
### Author:  [@Monk](https://community.influxdata.com/u/Monk)
#### Post date: [December 21, 2021, 5:35pm UTC](https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066/4 "2021-12-21T17:35:56Z")
@scott a related question if you allow:
If I understand correctly, this would apply to all aggregates \> 1d?
---
### Author:  [@scott](https://community.influxdata.com/u/scott)
#### Post date: [December 21, 2021, 6:45pm UTC](https://community.influxdata.com/t/result-interpretation-strange-aggregate/23066/5 "2021-12-21T18:45:52Z")
@Monk Correct, it should.