I’m trying to figure out the best way to track the monthly moving average amount of Deals each Contact is producing every month. I currently have the boards linked in a one-to-many relationship, but am finding it difficult to do this calculation with just formula columns or the basic reporting charts. Would data points like this be part of the advanced reporting available in the Enterprise tier of Monday?
It does sound like perhaps an advanced reporting Enterprise feature like the pivot board might work well for this! Have you taken a look at the features on the Enterprise plan to see if it will meet your needs?