WEBVTT

1
00:00:00.000 --> 00:00:05.456
Welcome to Aquantify: this tutorial shows how to build a search from the beginning.

2
00:00:07.416 --> 00:00:11.740
Open Data, then Tasks, to find scheduled tasks and their results.

3
00:00:13.714 --> 00:00:20.212
The filters above the table describe what you want to find; the table below shows the matches from your last search.

4
00:00:22.189 --> 00:00:27.167
Open Manage filter and choose Clear to remove the editable criteria from this browser.

5
00:00:29.139 --> 00:00:36.354
A filter contains a field, an operator, and a value: for example, Date, greater than or equal to, and a start date.

6
00:00:38.321 --> 00:00:44.084
Each additional condition narrows the search, so begin with a small number of conditions you understand.

7
00:00:46.039 --> 00:00:51.302
Use Add filter to add Date, then choose greater than or equal to for the start of your period.

8
00:00:53.292 --> 00:00:58.267
Add a second Date condition, choose less than or equal to, and enter the final day.

9
00:01:00.267 --> 00:01:08.147
This example uses historical training data from January to November twenty twenty-four; choose the period that contains your own records.

10
00:01:10.109 --> 00:01:14.324
Add Submitted to distinguish completed results from work still pending.

11
00:01:16.301 --> 00:01:23.610
Tick it to find submitted results, leave it unticked to find pending tasks, or remove this condition to include both.

12
00:01:25.558 --> 00:01:33.031
Add Parameter, type part of its name, and select the matching item from the list so that Aquantify recognises your choice.

13
00:01:34.941 --> 00:01:38.419
Select Search to apply the criteria and refresh the table.

14
00:01:40.434 --> 00:01:46.803
Changing a filter does not by itself refresh these results, so select Search again after each change.

15
00:01:48.768 --> 00:01:55.902
To narrow the same parameter to one location, add Sample point, choose an item from the suggestions, and search again.

16
00:01:57.893 --> 00:02:04.084
Check the date, parameter, sample point, and result columns to confirm these are the records you intended to find.

17
00:02:06.070 --> 00:02:12.068
Select a column heading to change the sorting, and use the page controls to move through a longer result set.

18
00:02:14.042 --> 00:02:20.591
Calculate total finds the number of matching records; the number of rows on the current page alone is not the total.

19
00:02:22.596 --> 00:02:28.540
Date refers to the task date; Result date and Scheduled date are separate fields for different questions.

20
00:02:30.519 --> 00:02:38.326
The lock beside a date switches between a fixed calendar date and a relative date such as the start of this month, with an optional day offset.

21
00:02:40.306 --> 00:02:48.056
If a search is empty, check the period, submitted status, and selected items, then remove the narrowest condition and search again.

22
00:02:50.037 --> 00:02:55.349
You now have a search built from explicit criteria, with the results refreshed and checked.

23
00:02:57.323 --> 00:03:03.840
Use a fixed range when reviewing a historical period, and relative dates when the search should move forward with time.

24
00:03:05.843 --> 00:03:12.670
The next tutorial shows how to name this search, reopen it, and maintain a useful collection of saved searches.
