# Consumption Aggregation Types

**URL:** <https://community.drivendata.org/t/consumption-aggregation-types/2588>\
**Category:** Cold Start Energy Forecasting\
**Created:** [September 1, 2018, 8:43am UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588 "2018-09-01T08:43:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![c3josh](https://avatars.discourse-cdn.com/v4/letter/c/c89c15/32.png) [@c3josh](https://community.drivendata.org/u/c3josh)\
**Post date:** [September 1, 2018, 8:43am UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/1 "2018-09-01T08:43:28Z")

</div>

Just to be very explicit, can we assume that all consumption values are extensive (summed) and not intensive (averaged/mean) when we aggregate them?

Another way to think about this is “Are all of the consumption units all kWh or similar and not kW or an other usage rate?”.

Many thanks

---

<div class="post-metadata">

**Author:** ![rosgori](https://avatars.discourse-cdn.com/v4/letter/r/7ab992/32.png) [@rosgori](https://community.drivendata.org/u/rosgori)\
**Post date:** [September 2, 2018, 4:07am UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/2 "2018-09-02T04:07:22Z")

</div>

I don’t understand you. Could you be more explicit?

---

<div class="post-metadata">

**Author:** ![ABourn](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@ABourn](https://community.drivendata.org/u/ABourn)\
**Post date:** [September 2, 2018, 12:08pm UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/3 "2018-09-02T12:08:59Z")

</div>

I’m assuming [c3josh](http://community.drivendata.org/u/c3josh) is asking whether the consumption data units are in kWh or kW which would depend on whether it refers to the total energy consumed in an hour or the average consumption over an hour period.

It shouldn’t matter either way as the difference between the two would be the same ratio for all values.

---

<div class="post-metadata">

**Author:** ![c3josh](https://avatars.discourse-cdn.com/v4/letter/c/c89c15/32.png) [@c3josh](https://community.drivendata.org/u/c3josh)\
**Post date:** [September 2, 2018, 3:15pm UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/4 "2018-09-02T15:15:00Z")

</div>

@ABourn - yes.

However, if the daily/weekly scores are in kW (we do not have examples of these), these will be averaged when aggregating. This means we will be x24 out and x168 out for daily and weekly respectively.

I very much doubt this is the case, but I wanted to be 100% sure when making submissions.

---

<div class="post-metadata">

**Author:** ![c3josh](https://avatars.discourse-cdn.com/v4/letter/c/c89c15/32.png) [@c3josh](https://community.drivendata.org/u/c3josh)\
**Post date:** [September 2, 2018, 3:17pm UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/5 "2018-09-02T15:17:04Z")

</div>

Also, there is a chance some of these energy usages are gas, and so could be m^3 etc.

Still, this is irrelevant really as aggregating m^3 is summed and so equivalent to kWh.

---

<div class="post-metadata">

**Author:** ![rosgori](https://avatars.discourse-cdn.com/v4/letter/r/7ab992/32.png) [@rosgori](https://community.drivendata.org/u/rosgori)\
**Post date:** [September 2, 2018, 8:59pm UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/6 "2018-09-02T20:59:20Z")

</div>

According to the description

> `consumption` - Consumption (watt-hours) since the last measurement

At least we know the unit.

---

<div class="post-metadata">

**Author:** ![c3josh](https://avatars.discourse-cdn.com/v4/letter/c/c89c15/32.png) [@c3josh](https://community.drivendata.org/u/c3josh)\
**Post date:** [September 2, 2018, 9:34pm UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/7 "2018-09-02T21:34:04Z")

</div>

This answers my question. All aggregations are sums. Thanks!

---

<div class="post-metadata">

**Author:** ![bull](https://yyz2.discourse-cdn.com/flex028/user_avatar/community.drivendata.org/bull/32/8_2.png) [@bull](https://community.drivendata.org/u/bull)\
**Post date:** [September 4, 2018, 12:02pm UTC](https://community.drivendata.org/t/consumption-aggregation-types/2588/8 "2018-09-04T12:02:31Z")

</div>

Yes, the information in this thread is correct. The aggregation of consumption is a sum. Where temperature is aggregated it is an average.
