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.
Happy you’re loving the dashboards I am thinking about how could we perform your suggestion in-app 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)
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!
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
When you want to combine the widgets in the dashboards, what will the end result be? Can you give me an example?
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