...
| Drawio | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Group
Format
Filter
Dimension filters allow to Groupers in pivot tables are essential for organizing and summarizing data effectively. They allow you to aggregate data by specific categories or time periods, making it easier to analyze patterns and trends. This helps in gaining insights from large datasets by breaking them down into manageable, meaningful chunks.
Different dimensions support various grouping options. For example, all date and time-related dimensions can be grouped by day, week, or month.
Example:
| Code Block | ||
|---|---|---|
| ||
...
cols: [
{
name: 'created',
group: { name: 'year' },
},
],
... |
Format
A formatter in a pivotopia is a configuration option, that allows you to apply different styles and formats to the cells within the table. This includes customizing how numbers, dates, and text are displayed, and setting up different formats for headers, totals, and data cells. It enhances readability and helps emphasize important information in your data.
Example:
| Code Block | ||
|---|---|---|
| ||
...
cols: [
{
name: 'created',
group: { name: 'month' },
format: {name: 'monthShort'},
},
],
... |
Filter
A filter is a feature that allows you to display only the data that meets certain criteria. By applying filters, you can focus on specific subsets of your data, such as a particular date range, category, or value, making it easier to analyze relevant information and draw insights from your data.
Example:
| Code Block | ||
|---|---|---|
| ||
...
cols: [
{
name: 'created',
filter: { name: 'dateTimeInDateRange', values: ['2023-01-01', '2023-05-17'] },
},
],
... |
System Dimensions (Jira System fields)
...
Name | Display Name | Scheme | Type | Category | Description |
|---|---|---|---|---|---|
| Count of Issues | Issue | Number | Count | Counts issues regardless of their statusesof their statuses. In Format you can also select display with bar to get visual display of percentage of issues in a group compared to the total count of issues. |
| Count of Opened Issues | Issue | Number | Count | Counts issues where issues |
| Count of Resolved Issues | Issue | Number | Count | Counts issues where |
| Count Of Status Changes | Issue | Number | Count | Counts number of times the issue changed its status |
| Sum of logged time | issue.worklog | Duration | Sum | |
| Sum of Original Estimate | Issue | Duration | Sum | Sum of values from Original estimate field |
| Sum of Time remaining | Issue | Duration | Sum | Sum of values from Time remaining field |
| Mean of Votes | Issue | Number | Sum | |
| Latest Issue Creation Date | Issue | Date | Date | Calculates the latest date of the issue creation in a selected scope of issues |
| Newest Issue Creation Date | Issue | Date | Date | Calculates the latest date of the issue creation in a selected scope of issues |
| Sum of Age (Business days) | Issue | Duration | Sum | Sum of “Age (Business days since creation)” calculated field values |
| Sum of Age (Calendar days) | Issue | Duration | Sum | Sum of “Age (Calendar days since creation)” calculated field values |
| Sum of Business Days since last update | Issue | Duration | Sum | Sum of “Business Days since last update” calculated field values |
| Sum of Calendar Days since last update | Issue | Duration | Sum | Sum of “Calendar Days since last update” calculated field values |
| Progress by issues | Issue | Percent | Percent | Calculates progress by count of resolved or open issues relative to the total count of issues |
| Progress by time | Issue | Percent | Percent | Calculates progress based on time spent or remaining estimate relative to the original estimate |
Format
Depending on the measure type, there could be a few possible formatting options.
...