...
| Excerpt | ||
|---|---|---|
| ||
 |
Overview
monday.com does not have the ability to cannot perform calculations on column values. While you can create columns to track data such as the hourly price of your services, the budget for a marketing campaign, or the hours worked on a project, you cannot use the platform to calculate the total charge for the hours billed on a project. Don't worry, we have a solution for to your problem.
This gadget allows you to perform math calculations on column values from any board from any workspace. Display the result in Icon Cards (numerical results) or Donut Cards (percentage results).
| Info |
|---|
Note that the maximum number of issues that the monday.com Formula Card gadget allows is fixed to 2500. |
...
Create variables
Variables store values that can be referenced later in the formula. They are useful to separate data in meaningful sets, so you can refer to it easily later in the formula or as the maximum value for the Donut Card visualization in %.
You can create up to 5 variables, and query any column from any board in any workspace. In addition, you can filter the items by selecting multiple values of those columns, then, aggregate the result with different functions in your fields.
...
Aggregations
Aggregations are also a common in the SQL domain. These functions get the values of grouped items as the input of that function to return a calculated value. This gadget currently support supports seven functions:
Count. It counts the number of items in that column.
Count (distinct). It counts the number of only distinct (different) items in the column.
Sum. It returns the addition of the sequence of the numbers of the column.
Min. It returns the smallest value of the range of values of the column.
Max. It returns the largest value of the range of values of the column.
Mean. The arithmetic mean, it sums the values of the grouped items and divides the result by how many items are being averaged.
Median. It returns "the middle" value of the range of values of the column. If the number of values is even, then, the mean of the two values in the middle is returned.
...
Cards display the result of a formula expression in a nice looking way. This mathematical formula accepts any of the previously created variables, but also integers and float numbers e.g., -5, 100, 23.32, or -1,000,000.2, etc.
To construct the relationship of these elements, formulas accept mathematical operators like + (plus), - (minus), * (multiplication), / (division), and ( ) (parenthesis).
...
To present the result you can choose between two different views:
...
A label (mandatory) to provide a meaningful description of the resulting percentage.
A prefix and/or suffix (optional) to add units or extra information to the number.
A max value (mandatory) to indicate the maximum value of the percentage and paint the donut chart accordingly. If the max value is 100 and the result of the formula is 50, then, half of the donut will be painted in the selected color.
A color (mandatory) to paint the donut chart.
...
Name your gadget meaningfully, so everyone knows at a glance what it is about and when to use it. Fill out the rest of the fields as applicable, namely:
The datasource data source, indicate the http://monday.com account where you want to fetch the data from.
The variables, where each one:
The workspace, the board, andthe column where the items are located. Any workspace, board, and column can be selected
The filter for the board items. You can filter the items of in the column using the filtering mechanism.
...
The view type
Icon Cards, where you can visually display any result of the formula with an icon.
Donut Cards, where you can represent percentages in a donut chart.
The formula expression accepts the previously created variables, integers, and float numbers e.g., a, b, -5, 100, 23.32 or -1,000,000.2, etc. And mathematical operators like + (plus), - (minus), * (multiplication), / (division), and ( ) (parenthesis).
Finally, indicate if you want to use the current settings for all the compatible gadgets in the dashboard. This option eases the pain of configuring one by one the rest of the gadgets with the same default configuration.
...