Database average of

[Barrelito]

Hi
I hope you guys can help me out.

So I am developing an application to asses recovery. It is very simple really.
It gives you five questions, and the points you get are stored into a databe. At the end of the five questions you get the score for the day wich is basically the average off the five questions. So far no problem.

Where I am finding problems is that I like the start screen to show the average of five days of recovery. But i can’t get it to work.

So far I have accomplished so that it saves the daily value the total of that day into a separate database where all the totals are saved. It would be easy if I just wanted an average of all the totals. But I only need and average of the last five inputs. Is this possible?

Also - is there a way to make the ”totals” database always delete the oldest post, so that the database only is 5 post long?

Thank you in advance!!

[James_App_Maker]

Hey there. Welcome to the community!

Can you upload a database of what your database is looking like? That would help me understand what we’re working with.

James

[Barrelito]

Thank you for replying. Attached is a screenshot of the two databases I use. One called Logs is where all the data gest collected and summed in the column total. The total is then transfered to the database Snitt. And its from ”Snitt” i would like to get the average of the last five entries. And also as a bonus, if there is a way to keep the ”snitt” database only five post long so that all older post (6 six and above) gets deleted everytime there is a new entry.

I hope you get med. Its all so clear in my head

Thank you i nadvance for your time.

/Christian