We could do with having the ability to use the average value of a column when building charts.
Like you can already select ‘Count’ instead of having the sum of the values. We just need an ‘Average’ value here, like you do when you just add a number widget to the dashboard.
We are trying to create a chart showing our Average Install Time for each item on the board.
I’ve raised this issue about a year ago with Monday.com support. They offered a workaround that includes building another dashboard to aggregate values and then pulls the average from that dashboard. However, that solution is not scalable or easy to maintain.
I hope that the Monday.com team is reading this and will work to add this essential feature as soon as possible.