Skip to main content
Skip table of contents

Fields Options in Pivot View

It allows you to configure Reports Filters, Columns, Rows, and Values according to your Jira issues fields.

image-20231226-112335.png
image-20250428-133844.png

Configuration

  1. Scroll the list of the All fields or type the one you need and set it for Values. The chosen values will be displayed in Columns.

  2. Choose the function for Values (Sum, Min, Max, Average, etc.)

image-20250428-133944.png

3. Select and add fields to Rows, Report Filters, or Columns. You can move fields by dragging them.

image-20250428-134409.png

4. To delete issue fields, move them back to the All Fields.

Fields order

Depending on the order in which you add fields, you will obtain different results for your report.

Example 1.

If you set issue type followed by assignee, the table will display the time for each issue type by assignee.

Settings:

image-20250428-134545.png

Result:

image-20250428-134609.png

Example 2.

If you set assignee followed by issue type, the table will display time for all issue types per assignee.

Settings:

image-20250428-134835.png

Result:

image-20250428-134946.png

You can also add calculated values to the Pivot table data.

  1. Enter the name for value

  2. Scroll to select the required field

  3. Choose the function you want to use

  4. Drug the value to the formula (bottom line)

image-20250428-135024.png
image-20250428-135233.png

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now!

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.