# Monthly average

**URL:** <https://discourse.nodered.org/t/monthly-average/85212>\
**Category:** General\
**Created:** [5 February 2024 10:51 UTC](https://discourse.nodered.org/t/monthly-average/85212 "2024-02-05T10:51:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![colin0031](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin0031/32/85027_2.png) [@colin0031](https://discourse.nodered.org/u/colin0031)\
**Post date:** [5 February 2024 10:51 UTC](https://discourse.nodered.org/t/monthly-average/85212/1 "2024-02-05T10:51:43Z")

</div>

Dear node-red family members,  
I am collecting data from a machine, which send out parameters(values between 20 &50) once every second.

Is it possible to that I can find monthly average from Ui without the help of additional data base??

I'm a bit worried about crashing node red. so I'm looking forward to save values to excel sheet and find an average from it.

Any suggestions and ideas will be appreciated.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [5 February 2024 10:58 UTC](https://discourse.nodered.org/t/monthly-average/85212/2 "2024-02-05T10:58:54Z")

</div>

> [@colin0031](#):
>
> Is it possible to that I can find monthly average from Ui without the help of additional data base??
> 
> I'm a bit worried about crashing node red. so I'm looking forward to save values to excel sheet and find an average from it.

A database is far easier than excel. And file backed context storage is even easier.

Here is an example of what you can add to your settings file to enable 2 context stores (one of them backed up to file): [Problem with multiple context stores - #7 by zenofmud](https://discourse.nodered.org/t/problem-with-multiple-context-stores/52955/7)

And here are the docs: [Working with context : Node-RED](https://nodered.org/docs/user-guide/context)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [5 May 2024 10:58 UTC](https://discourse.nodered.org/t/monthly-average/85212/3 "2024-05-05T10:58:54Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.