Filter Results | Decadis App Help Center

The Filter Results gadget closely resembles the standard Jira Filter Results gadget, but it includes an enhanced feature: a sum row that displays totals.

Configuration


Work item source	Select an existing filter or Custom JQL to define the issues that you want to analyze. Using Custom JQL allows you to narrow down the result set ad-hoc without the need to create a filter.
Columns to display	Select the fields that you want to display and / or sum up in columns and reorder them using drag&drop. Only certain fields can be summed up (e.g., numeric fields, text fields with numeric values, etc.). See Supported Fields for a full list of supported fields. 💡 Click a column heading on the table to sort fields ascending or descending. Status, Priority, and Resolution use the order defined on their Jira pages. Quick Rename To align fields with your company glossary or preferred terminology, hover over a field and click to edit its name. To revert changes, hover over the field again and select “Restore to original name”.
Aggregation metric: Sum or Average, Cumulative, or None	Enhance your data view by defining aggregation metrics, directly within the column selector. Simply hover and click to apply the calculation that best fits your analysis. Once your field appears in the Columns to display panel, you can choose an additional aggregation metric, such as Cumulative, or select None to skip the calculation. If you select “Cumulative“, the cumulative column will be seen on the “Columns to display“ as well as on the gadget table.

Work item source

Select an existing filter or Custom JQL to define the issues that you want to analyze.

Using Custom JQL allows you to narrow down the result set ad-hoc without the need to create a filter.

Columns to display

Select the fields that you want to display and / or sum up in columns and reorder them using drag&drop.

Only certain fields can be summed up (e.g., numeric fields, text fields with numeric values, etc.).

See Supported Fields for a full list of supported fields.

💡

Click a column heading on the table to sort fields ascending or descending. Status, Priority, and Resolution use the order defined on their Jira pages.

Quick Rename To align fields with your company glossary or preferred terminology, hover over a field and click to edit its name. To revert changes, hover over the field again and select “Restore to original name”.

Aggregation metric: Sum or Average, Cumulative, or None

Enhance your data view by defining aggregation metrics, directly within the column selector. Simply hover and click to apply the calculation that best fits your analysis.

Once your field appears in the Columns to display panel, you can choose an additional aggregation metric, such as Cumulative, or select None to skip the calculation.

If you select “Cumulative“, the cumulative column will be seen on the “Columns to display“ as well as on the gadget table.

Choose additional options


Rows per page	Choose how many results (rows) you want to display when viewing the gadget. Additional results will be paginated. The sum row will show the total of all results regardless of the page they are on.
Time format	For duration fields like Original Estimate, Time Spent, etc. you can now choose a custom format such as Pretty, Compact, Days, Hours, or stick to System settings.
Reload every 15 min	Enabling this option is useful when displaying information that needs a periodic and automatic refresh, particularly when the gadget is displayed on a wallboard.
Show zero if empty	By default, empty numeric or time-based fields are displayed as blank. Enable this option if you prefer to show those values as zero.

:filter: Advanced column filtering

Unlock deeper insights and eliminate manual searching with our new intelligent column filters. Instead of scrolling through endless rows, you can now isolate critical information in seconds using filtering logic tailored to your specific data.

💡

Pro tip: Apply filters to multiple columns to narrow your results further. The gadget automatically combines your criteria using logical AND, displaying only the records that meet all specified conditions.

Good to know
Filters are saved per user and remain persistent even after a page refresh.

🖌️ Conditional cell highlighting

Identify important data quickly without filtering, isolating, or losing the context of your current gadget view. Shed light on what matters most in your gadget data. Define highlight rules for a column, such as marking priority values like “Highest” or “High,” and matching cells will be visually emphasized using your chosen highlight color.

💡

Pro-tip: You can define up to 3 highlight rules per column and can add highlight to as many columns that are present on the gadget table.

↔️ Manual column resizing

Columns in the Filter Results gadget can now be resized manually to improve readability and better accommodate longer values.

To resize a column, move your cursor over the column header. A gray vertical bar will appear between the columns, indicating that the column can be resized. When you hover over this bar, it will turn blue and the cursor will change to a resize icon. You can then click and drag the bar to the left or right to adjust the column width as needed.

📥 Export / download CSV

You can now download the gadget table as a CSV file directly from the gadget. Simply open the in-app menu and select Download CSV to export the full table for offline use, sharing, or further analysis.