Versions Compared

Old Version 1

changes.mady.by.user Nikita Kamai

Saved on

compared with

New Version 2

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  boxbox.
  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 the needed format.

  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

Image Removed

Image Removed Image Removed

Image AddedImage AddedImage Added


Shorten title

This option removes the operation type name from the header.

Enable the cumulative count

  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 Cumulative countShorten title option.
  5. Save the macro and the page.

Image Removed

Show data values

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Show data values option and select the appropriate option, as follows:
    • Number
    • Percentage
    • Number (Percentage)
    • Percentage (Number)
  5. Save the macro and the page.

Image Removed

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 Added

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

Hide totals

  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 totals option.
  5. Save the macro and the page.

Image Removed

Show/Hide the source table

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Source data option and select the appropriate option, as follows:
    • Show all content
    • Hide tables
    • Hide all content
  5. Save the macro and the page.
Info

To show/hide the source table in the page view mode:

  1. Hover over the control panel on the right of the table.
  2. Click the cogwheel icon, select the Show source content, Hide source content (Hide tables, Hide all content) option.
  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes .
  1. Show result as plain text option.
Handy Carousel
delay10

Image RemovedImage Added

Image Removed

Image RemovedImage Added

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.

Set the literal value delimiter

When selecting the Literal operation type the Literal value delimiter option becomes available:

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Options tab.
  4. Locate the Literal value delimiter  option and select the appropriate option, as follows:
    • None (default)
    • Comma
    • Semicolon
    • Space
    • Line break
    • Bullet list
    • Numbered list
    • Any custom character
        5.
  1. and enable the Customize no table found message option.
  2. Enter your custom message that you want to be displayed instead of the standard one.
  3. Save the macro and the page.

Image Removed

Handy Carousel
delay10

Image Added

Image Added

Collapse rows and columns

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

Show result as plain text

NoteThis 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 Collapse rows and columns option.
  5. Save the macro and the page option.
Handy Carousel
delay10

Image RemovedImage Added

Image RemovedImage Added