Math within dashboards

The ability to have serval widgets within a dashboard is incredibly useful. However one thing that could be a game changer is the creating a math widget that combines other widgets. For example: one widget shows sales, the next shows volume, the last one shows how many customers were spoken with. By combining these numbers you could get really useful info such as sales percentage, cash per guest, clients lost percentage. There are hundred of examples to why this would be useful. The formula column is great but is very limiting to the fact you can only use numbers with the same row and that makes getting percentages and averages hard.


Hi @Miltime19

Happy you’re loving the dashboards :100: I am thinking about how could we perform your suggestion in-app :exploding_head: The widgets import data from boards, so technically it would be natural to make the changes and the calculations on the boards, whereas the widget would just reflect the results (Reporting is the main purpose for widgets and dashboards) :receipt:
When using the Numbers widgets on formula columns, you can get a sum/average of the whole column. However, was there a function that you cannot achieve by using the Formula and the Numbers widget? I’d love to see whether I can help!

1 Like

Yes, the ones that I listed. Just getting the total columns is limiting. In the formula or total how would you get sales divided by customers? You can take away a number meaning if there are 6 clients with only 5 spots left there’s no way to automate an alert saying there’s only 5 left because the formula only relates to the individual row.

@Miltime19 - I am not sure I understand what you are trying to achieve :thinking:

When you want to combine the widgets in the dashboards, what will the end result be? Can you give me an example?

1 Like

If you had a widget that showed how many total customers were seen. Then you had another widget that showed how many of those clients purchased ( total sales) . Then the third widget would have total sales widget divided by the total customers widget giving you a closing percentage

Hey @Miltime19

I see what you mean! Though I will submit this feature to our product team to consider adding it to our roadmap for Dashboard, in the meantime, let me know if you are looking to accomplish a specific workflow on I’d love to help out :innocent:

1 Like

+1 for this feature :slight_smile:

In our case, we have:

  • A board with multiple groups, recording sales by type
  • A board recording lost sales

We have a dashboard that has a number widget that sums up all groups to give us the total figure. E.g. Product 1 (group) = £10, Product 2 (group) = £20, therefore total sales = £30. And the same for business lost, for example, total lost = £3.

It would be extremely useful to be able to calculate those two dashboard widgets as a %, so the ‘Lost Business’ widget would report 10%.

There isn’t an easy way to do this in boards and it doesn’t justify the mess of an entire board. The ability to calculate %s is so important to reporting.

Thanks guys!


1 Like