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.
      info Since the release of Black Cat 16.0 the following Data Sources are supported.

    2. Select Column or multiple Columns.
      info By default, all available columns are pre-selected (All Selected).

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

  4. Click Save.

  5. In the Save Query menu:

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

    2. Enter a Name.
      info 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.

This example will list the whole table from the source that you selected in the Select Source step.