Page Comparison

...

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:

...
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:

...
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:

...
cols: [
  { 
    name: 'created', 
    filter: { name: 'dateTimeInDateRange', values: ['2023-01-01', '2023-05-17'] },
  },
],
...

System Dimensions (Jira System fields)

...