Searching and Selecting Key Field (and/or Data Column) 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,
-Nd and -Ndays for the number of days since the current date, where N - any positive integer or zero.
-Nm and -Nmonths for the number of months since the current date, where N - any positive integer or zero.
-Nm_first, -Nmonths_first, -Nm_last and -Nmonth_last for the first and the last day of the specified month correspondingly, 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.