Photo by Marcel Eberle on Unsplash | How to Coda a time based delta value?

How to Coda a time based delta value?

Applying a group index to find increased or decreased profits.

In my blog on rolling totals I applied the FormulaMap() logic as an alternative for the often applied Row Index variation based on Find() and Slice():

This rolling total is based on the assumption that you have one type of items. In the Coda Community I solved a little puzzle related to a layered approach. Below some additional explanation.

Step 01 Filtering the values

I started rather simple with a filter to get the values that belong together, a classical approach. The next step was to apply the logic as described in my related blog using a FormulaMap(). So far it is rather straight forward if you have my blog open next to you. The result is what you see below:

Step01 : applying the logic from my previous blog

Step 02: getting the values right

Once you have this range of items on each row related to the proper article the question is how can I get one number per row? We cannot relay on the Row Index thisTable.Find(thisRow) Instead we need a variation that keeps track of the filtered articles. In this blog I explain the principle behind the group index as I named it. This group index you see back in the formula below. It is this value we work with in our Slice(), to generate a range from one up to the variable. Using Last() we take indeed the last value of this range.

Group Index combined with Slice() and Last()

And so we have our solution while applying Slice() again this time in the good company of group index.

I hope you enjoyed this article. If you have questions feel free to reach out. Though this article is for free, my work (including advice) won’t be, but there is always room for a chat to see what can be done. Besides you find my (for free) contributions to the Coda Community and on Twitter

My name is Christiaan Huizer and I am the owner of Huizer Automation. A company specialized in serving SME in harvesting data and keeping it aligned. I am a Coda Expert and I mainly rely on Coda, Mailjet, Zapier & Paperform to get the job done.

Huizer Automation — Coda Consultant & Expert on How to Coda a time based delta value?



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christiaan Huizer

Christiaan Huizer

I use Coda mainly for planning & calculations of all sorts. Follow me to learn how to Coda with numbers. I blog at least once per week.