Versions Compared

Old Version 3

changes.mady.by.user Katerina Kovriga

Saved on

compared with

New Version 4

changes.mady.by.user Katerina Kovriga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft
Read more:

Set the default sorting

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Default Sorting box.
  5. Click it and select the column with the appropriate sorting order.
  6. Save the macro and the page.
Info

Default sorting is available only in the pivot tables with one column selected as row labels.

Set the cell value delimiter

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.

  4. Locate the Cell value delimiter box.

  5. Enter the character (multiple characters) used to separate values in cells.

  6. Save the macro and the page.

Info

If the call value delimiter is not a regular character, but a space, use the Unicode character  \u0020.

Handy Carousel
delay10

Set the decimal separator

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Decimal separator  box.
  5. Select the correct decimal separator from the list, as follows:
    • Point
    • Comma
  6. Save the macro and the page.
Info

The incorrectly specified decimal separator may cause the incorrect calculation of numerical values.

Set the thousands separator

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Thousands separator box.
  5. Select the correct decimal separator from the list, as follows:
    • Space
    • Point
    • Comma
  6. Save the macro and the page.
Info

Selection of the thousands separator is optional as it only improves Options of numerical values without affecting the original values in the source table.

Set the number of decimal places

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Decimal places box.
  5. Enter the number of decimal places to display.

  6. Save the macro and the page.

Info

You may need to limit the decimal places when using the Average operation type.

Set the date format

Excerpt
  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Date format  box.

  5. Select the correct date format from the list or manually specify it. This format will be used to read date values in the source table.

  6. Save the macro and the page.


Info

For the details on specifying date formats, read this article.

Table Excerpt
namedate pivot 2

Set the worklog settings

The Pivot Table macro supports summarization of worklogs and time intervals.

Info

Please ensure that the worklog parameters set in the macro are identical to parameters configured in Atlassian JIRA.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Click the Set worklog settings button.
  5. In the opened form, define the worklog parameters, as follows:
    1. Days in week - enter the number of business days in a week.
    2. Hours in day - enter the number of working hours in one business day.
    3. Time format - select the used time format in worklog values.
    4. Week shortening - enter the shortening for the week time unit if you use any language different from English.
    5. Day shortening - enter the shortening for the day time unit if you use any language different from English.
    6. Hour shortening - enter the shortening for the hour time unit if you use any language different from English.
    7. Minute shortening - enter the shortening for the minute time unit if you use any language different from English.
  6. Click Save.
  7. Save the macro and the page.
Info

Worklog time units in different languages are denoted with different shortenings. Please adjust them according to your JIRA localization settings.

Handy Carousel
delay10

Shorten title

This option removes the operation type name from the header.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate and enable the Shorten title option.
Info

The Shorten title option works only for simple one-dimensional pivot tables.

But please note that you can always rename pivot columns with the help of the Table Transformer macro. 

Handy Carousel
delay10

Image RemovedImage Added

Image RemovedImage Added

Show result as plain text

Note

This option can be enabled only if the calculation result is displayed as a table with a single cell.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit .
  3. Switch to the Options  tab.
  4. Locate and enable the Show result as plain text option.
Handy Carousel
delay10

Hide control panel

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit .
  3. Switch to the Options  tab.
  4. Locate and enable the Hide control panel  option.

  5. Save the macro and the page.

Info

To hide the control panel in the page view mode:

  1. Hover over the control panel on the right of the table.
  2. Click the cogwheel icon, select the Hide control panel option.

To show the control panel hove over the pivot table and click the cogwheel icon on the right of the table.

Handy Carousel
delay10

Customize no table found message

This option allows editing the default no table found message.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate and enable the Customize no table found message option.
  5. Enter your custom message that you want to be displayed instead of the standard one.
  6. Save the macro and the page.
Handy Carousel
delay10

Collapse rows and columns

This option keeps the rows and columns of the multilevel pivot table collapsed by default.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate and enable the Collapse rows and columns option.
  5. Save the macro and the page.
Handy Carousel
delay10