How to Create a Query

1. Go to Analytics > Dashboard Manager > Queries.

2. Click New Query.

3. In the Source Data section:

   1. Select Source from the drop-down menu.
      Since the release of Black Cat 16.0 the following Data Sources are supported.

   2. Select Column or multiple Columns.
      No columns are preselected when you select the Source. You must explicitly select each column you want to include in the query. To use every column of the source, click Select all. Select only the columns that the query needs, because fetching all columns can slow the query down.

   3. Select Currency.
      Defines which currency the money data will be converted into.

4. Click Save.

5. In the Save Query menu:

   1. Enter a Label.
      Info Title used for display and translations.

   2. Enter a Name.
      Info Mandatory and unique identifier. Changing it can break dependencies. Prefer using the Label for naming visible to users.

   3. In the Save to Folder section, select the folder where the query will be saved.

   4. Click Save.

When you return to the Query List screen, the query will be saved in the selected folder.