Skip to content

Searching and selecting key field and/or data field values

General Concept

When generating a report, it is often necessary to display data for particular key field (and/or data column) values only.

u-Slicer allows you to search and select the required key field (and/or data column) values quickly and easily for any key fields (and/or data columns) and combinations thereof. You can use the simple filter for selecting directly the desired key field values, the advanced filter for selecting the desired combinations of key field values and their mappings, as well as data filters for selecting desired combinations of data column values.

When you apply various search criteria subsequently to different key fields, the corresponding Split Chain is created to facilitate your navigation through the Slicer data.

The Split Chain is located in the upper left corner and displays the current sequence of selected key field values.

When you apply various filters to data columns, currently selected filtering criteria are displayed under the each data column name correspondingly.

When you open a Slicer for the first time, UI looks like as follows depending on your project:

Selecting date ranges

To select the desired date range:

  • Open the Calendar control.

  • Select the desired date range using one of the following options:

    • Click the corresponding shortcut: 90 DAYS, 60 DAYS, 30 DAYS, 14 DAYS, 7 DAYS or 3 DAYS.
    • Enter the start and end dates into the corresponding boxes. Supported formats:
      • Absolute dates: YYYY-MM-DD.
      • Relative dates:
        • today, yesterday,
        • - N d and - N days for the number of days since the current date, where N - any positive integer or zero.
        • - N m and - N months for the number of months since the current date, where N - any positive integer or zero.
        • - N m_first, - N months_first, - N m_last and - N month_last for the first and the last day of the specified monthcorrespondingly, where N - any positive integer or zero.

  • Select the start and end dates by clicking the corresponding days in the Calendar.

  • Click the Ok button.

Selecting Keys

To select the desired key:

  • Open the key selection dialog box.
  • Click the desired key.

OR

  • Enter a search string into the Select a category field box.

  • All keys matching the specified search string are highlighted as displayed above.

  • Click the desired key or press to select the first highlighted key ( Conversion ID in this example).