We wish to report on the number of items which have been allocated to a project team and those which have not.
The column I would like to use is a People column however this does not appear in the list of available fields to filter on within the Chart.
For context, the People column is native to the Board and populated manually.
A secondary query - if this is possible can the solution be paired with an additional level of detail, e.g. Service area > number allocated/number blank
Thanks!
Hi Chris, I think I might have something for you that could help you out. I’m part of the monday.com Team at Decadis and we’ve got an app on the Marketplace that, I think, would fit perfectly to your current needs: sumUp for monday.
If you need any support regarding your requirements feel free to schedule a call with us.
If you haven’t heard of sumUp yet, here’s just a short sumup 
With ‘sumUp for monday’ you can,
- harness two robust dashboard widgets – the ‘Group by’ and ‘Two dimensional’ widget – seamlessly converting your extensive data into insightful visualizations
- easily pivot your extensive board data either in one or two dimensions.
- use the ‘Group by’ widget to group extensive data by a single column effortlessly
- use the ‘Two dimensional’ widget to seamlessly group large data vertically and horizontally
- easily calculate the sum of your chosen metric in either of the gadgets
- gain insights from multiple boards, by summing data across the boards and then pivot it by selecting the common or matching columns
- make data-driven decisions without the need to export data
And here’s what it looks like:
