Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:



Panel
bgColorwhite
titleBGColor#f5f5f5
titleManaging the Free Text FilterNumber Range Filters

Table Filter and Charts for Confluence add-on is equipped with the number range filter. You can add this filter type for any column of your table containing numbers or decimal numbers. It allows you to specify the number range for showing data in the table. Alternatively, you can set the start or end value instead of the number range. Both cardinals and decimals are supported.


Widget Connector
width432
urlhttps://www.youtube.com/watch?v=tgrsqpqU82o&list=PLRpx9wuFqlzFa9X4DWwQEBdy22YIwT6kh&index=4
height243



Adding the Number Range Filter

  1. Edit the pageSwitch the page to edit mode.
  2. Insert the Table Filter macro either by entering {Table Filter} or by selecting it from other macros.Copy and  and paste the table into within the macro body.
  3. Select the macro and click Edit.
  4. In the the Number Filter Columnsrange filter columns box, select the columns for filtration with number range filters.
  5. Select Switch to the Filtration tab and set the correct decimal separator for number values (if needed).
    Image Removed
  6. Save the macro.
  7. Save the page.

Image Added



Filtering the table with number range filters

  1. Open the page with the table for filtration.
  2. On the filtration pane, enter locate the number range filters and position the mouse pointer within the appropriate one.
  3. Enter the appropriate number range (including a capability to enter decimal values).
    Image Removedor start/end values for filtration.

Image Added



Filtering the table with JIRA worklogs or time intervals

You can filter tables containing JIRA worklogs or time intervals.

  1. Open the page with the table for filtration.
  2. On the filtration pane, locate the number range filters and position the mouse pointer within the appropriate one.
  3. Enter the appropriate worklog duration or time interval.

Use the correct format for entering worklogs:

  • Xw - for weeks (for example, '2w').
  • Xd - for days (for example, '3d').
  • Xh - for hours (for example, '5h').
  • Xm - for minutes (for example, '45m').

You can combine multiple values into a single string.

Use the correct time format ('hh:mm:ss') for setting time intervals.

Info

You can define the worklog parameters, for the details see this page.


Image Added

Widget Connectorwidth432urlhttps://www.youtube.com/watch?v=tgrsqpqU82o&list=PLRpx9wuFqlzFa9X4DWwQEBdy22YIwT6kh&index=4height243