With Malartu you can create virtually any calculation you could make in a program like Excel and easily plot it on one of your blocks. These calculations will constantly run as new data is piped into your accounts.
To create a new custom metric, first navigate to a board and bring it to edit mode.
Select "Data" from your block browser to launch the metric browser
Select custom metric, then "+ Create new custom metric"
This will display the Custom Metric Editor
To begin, add a metric from the metric browser below the editor and notice it moves to the formula bar.
To add logic to this calculation, select "Operator" and make whichever selection you need.
In addition to operators, you can also add a static number to your formula or work with more complex functions like you would in Excel.
Pro Tip: Don't worry about the order in which you add operators or metrics, you can drag and drop the order of elements within the formula bar any time you would like.
Pro Tip #2: Use the small search bar as much as possible when searching for your desired formula elements. Many accounts can contain thousands of metrics, search is your best friend.
After you've built your formula, give the new metric a name and click "Save." You should now see the custom metric in your custom metric menu.
You can add this metric to any table or sheet just as you would add any other metric.
Two helpful features for building out your library of custom metrics are:
Make sure to explore functions available to metric editing to understand the full capabilities of Malartu. Examples of functions are: