Solution to BI calculations randomness
I found quite a lot of problems in the calculations performed by BI. It hallucinated values, algorithms, etc. To solve this problem I first enforced in the memories a rule to ask for execution of explicit code. Even this was not enough. I have now performed two major changes to my approach: 1. Make the rule much more aggressive, it now enforces the use of code for calculations. 2. Ask BI to prepare standardised code methods for the calculations I want to use repeteadly (for instance, those in the weekly check in).
The second idea is key, I may “vibe code” a parameter calculation until I am sure it works. From this moment on, the calculation is frozen and the values are comparable. I have fixed rules for minutes in z2+, TRIMP based on minute hr and banister formula, nutrition adherence, etc.
BI has even created a new file called methodology.md containing all those methods.
It would be so nice and powerful if BI had a methodology to leverage this kind of approach… think of custom dashboards, tables, plugins …