|
Summary mission |
Summary mission is a query, with or without aggregations.
Only the list of dimensions is compulsory to compose. You can also define several aggregations. If you create aggregations the data will be grouped by dimension. If there are no aggregations it will be a simple query without grouping.
If you group data you can analyze any string more thoroughly by creating submissions.
When the data has been selected, you can:
move columns within the detail grid (click a column title and drag it to the left or right, keeping the left mouse button pressed);
change any column width (drag a column border to the left or right);
sort the data (double click on the title of a column, you want to sort data by);
search for the strings, which have substrings or certain first symbols (just choose the required column and start typing a substring or the first symbols of the required word). The program will search for matches on typing of each symbol.
sum up numeric columns;
export the components from a table to Excel;
create an Excel chart.
Only summary missions can be used in reports, but you can create a summary submission for any parent mission type. In practice, you may just create a summary submission for this position, if you need to use the details of a detailed mission position in a report.