This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
i have some data and a formula tool which creates a column "result".
But in the result calculation i would like to add the Sum of previous results.
But not row specific but the last 5 minutes. (so the needed rows can change)
For example i would like this:
How could i achieve this?
Do i need a interativ macro or is there some default tool that could help?Best,David
One quick question, do you need the result to be displayed in all rows for previous five minutes?
From row 11 to 21?
yes. Every row needs to have a result.
The calculation needs the sum of previous five minutes.
So for e.g. row 23 i need the sum result of row 11 till 21.
I used a time anchor hard code of '2022-01-01 10:05:00' for this.
If your actual flow has dynamic date timestamps, update your sample and I will work on an adaptive workflow solution.
Please take a look at the below.
Please mark it as an acceptable solution if it works for you.
Hi @RobertOdera Thanks for your Workflow.Its not exactly what i was looking for. Because it does not go through all timestamps.But i could solve this today with using an iterative makro and a batch makro inside the interative makro.BestDavid
Yes, sure thing @df!
You can use an iterative macro, and you can use generate rows to achieve dynamic flows.
It helps the community immensely if you articulate your problem statements and if your samples provide the scenarios you anticipate 👍