Calculate average of item in Monday.com in Make.com

How To
, , ,
1

Hey all,

Need your help with the following:

I have a Monday.com board set up to track KPIs over time. Each row represents a KPI, and the columns represent different weeks. I’m using Make.com to automate a process where it:

  1. Triggers: Responds to new items (new kpi’s, probabky wont happen to often) or updates on the board (new week added) or change of values.
  2. Calculates: Averages the values from the first 13 weeks (columns) for each KPI (row).
  3. Updates: Places the calculated average in a designated “Average” column.

Additional details:

  • The board currently has 3 KPIs (items).
  • The “Average” column is located after the first item column.
  • Weeks are unlimited, but dont think i need to store more than 52 wks.

Best,
Wouter

2

Hi @GoogleWouter_Potman
You can add a formula column named average as the last column:

image
image772×81 4.06 KB

image
image810×597 45.5 KB

Set the formula:
image
image714×552 27.6 KB

Now everything will be updated automatically in Monday itself.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

3

Thanks for your reaction. I tried that, but get into trouble when a new week is added. The new weeks will be added on the left side of the board, next to the average. Ao the formula must average the first 13 columns, and these will change all the time. (So the formula needs to be dynamic).

I couldn’t make that work…