Script to set up Goals % and Value

[Sam_Mitrani]

Hi,

I have a table of orders, with their value in $. I wanted to create a dashboard that will show the current sum of the orders vs. a goal. Since there is no (as far as i found) a way to do that with the current apps, i thought of using a script.

Can someone share an example of a formula that will calculate the sum of raws in the tables and then will take a # and reduce that sum from it?

Thanks

[JonathanBowen]

Hi @Sam_Mitrani - I’ve wrote a post about a similar scenario here - it might help you:

Airscript – 12 Jun 20

Adding it all up

Using “reduce” to group your data by something