I would like to calculate inside a dashboard. It should be easy math skills like deviding to numbers 
But i can not find any solution. Found some workarounds with formulars, but thats hornestly a bit to complicated for me. Maybe there is an easy solution.
Best regards from Germany
You’ll need to have a formula on the board it’s pulling from. You should be able to just use the columns and divide one by the other?
But how could I manage that? The formular should count all item for one responsible person were one special collum is not empty and than devide it with the counted items for one responsible person were one special collum is not empty. is this even possible?
Hello Dominik,
I am Nacho and i am part of Decadis.
If using a third party app is an option for you, i would like to recommend our app sumUp for monday.
This app contains two dashboard widgets which will help you to sum up and group metrics.
If you would like to take a look, please visit the following page of our documentation: Dashboard Widgets.
If you have any doubt or require assistance, please feel free to create a ticket in our support portal and we will be happy to help.
Best regards,
Nacho
Hey Dominik,
This is something where monday’s formula lag a bit. As far as I have understood your problem. You want to create a formula like this. If{Column Value} is not 0 then divide {ColumnValue} by {No. of Items}.
That’s a group-level or board-level aggregation, which Monday.com’s formula column cannot perform on its own.
Zaki
Business Workflow Consultant
Great insight, Zaki. I ran into a similar limitation with Monday.com’s formulas when trying to calculate averages across grouped items. Hopefully they expand functionality for board-level calculations soon — it would really improve automation potential.
@ZakiImtiaz @thomasjames if an add-on is an option, you can do that with the Analytics & Reports app by Screenful. The chart you should be looking at is the Table chart that allows customizing each column separately, and doing calculations between columns. Since each column contains grouped items, it allows doing calculations using group-level or board-level aggregations.
Here’s a guide for getting started with the free trial.
