...
Count. It counts the number of rows/elements in that group/field.
Count (distinct). It counts the number of only distinct (different) rows/elements in the group/field.
Sum. It returns the addition of the sequence of the numbers of the group/field.
Min. It returns the smallest value of the range of values of the group/field.
Max. It returns the largest value of the range of values of the group/field.
Mean. The arithmetic mean, sums the values of the grouped rows and divides the result by how many rows are being averaged.
Median. It returns "the middle" value of the range of values of the group/field. If the number of values is even, then, the mean of the two values in the middle is returned.
Create cards
Cards clearly display the result of a formula expression. 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.
...
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, where the source Jira instance is installed.
...
The JQL (Jira Query Language) query or filter to filter the list of issues (see the JQL documentation). We recommend to add adding at least one clause, for example, to list all the issues of the project Teams in Space use the clause
project = "TIS”. And remember Remember that the gadget returns the query results of the query, which are not fixed and could change over time.The aggregations to perform calculations -Count, Count (distinct), Sum, Min, Max, Mean, Median- over the results. Check the aggregations section.
The field to select what do you want to apply the calculation to e.g., Story Points.
...
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
...