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:
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.
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.
