Overview
monday.com does not have the ability to 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 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)
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, 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 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.
Create cards
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:
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.
View type: Icon Card
The Icon Card requires:
A label (mandatory) to provide a meaningful description of the resulting number.
A prefix and/or suffix (optional) to add units or extra information to the number.
An icon (mandatory) to give a visual clue of the provided number.
View type: Donut Card
The Donut Card requires:
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 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.
Configuration
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, indicate the http://monday.com account where you want to fetch the data from.
The variables, where each one:
The workspace, the board and the 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 the column using the filtering mechanism.
The aggregations to perform calculations -Count, Count (distinct), Sum, Min, Max, Mean, Median- over the results.
The cards, where each one:
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.
Integrations
We are working on our growing catalog of https://roninpixels.atlassian.net/wiki/spaces/RDD/pages/33345 and https://roninpixels.atlassian.net/wiki/spaces/RDD/pages/87457873, but contact us you want us to expedite a specific one, visit our https://roninpixels.atlassian.net/wiki/spaces/RDD/pages/85721333.
Dashboards
This gadget is not included in any pre-defined dashboard, check other orphan gadgets: