Labels Query in Data Summary

Labels Query

With the Labels query you can create your own category that will base the calculations on transactions having specific labels assigned if you’re using the Labeling service. In the Data Summary response, your query will become the category name with calculated metrics within.

Format description

The Labels Query contains:

• “label” keyword with a semicolon (:)
• required inclusion section: label names separated by ampersand (&) or pipe sign (|)
  • you can provide from 1 to up 5 labels in the inclusion section
  • labels separated by & mean: include transactions that contain at least all of the provided labels
  • labels separated by | mean: include transactions that contain at least any of the provided labels
  • you can’t mix & and | in one inclusion section
• optional exclusion section preceded by the tilde sign (~) with labels names separated by pipe sign (|)
  • you can provide from 1 to 5 labels in the exclusion section
  • labels in the exclusion section mean: exclude all transactions that contain at least any of the provided labels

The format requires label names as per our documentation.

Label names may contain spaces. Only :, &, | and ~ are allowed in the query as special characters.

“at least” in the descriptions means that the transactions can have any number of other labels that are not mentioned in the query and they will still be considered for the calculations.

The constructs in the table present examples that should either match or not with the required format:

Usage examples

Given transactions with the following labels:

1. car
2. e commerce
3. leasing
4. invoice
5. car, e commerce
6. car, leasing
7. car, invoice
8. e commerce, leasing
9. e commerce, invoice
10. leasing, invoice
11. car, e commerce, leasing
12. car, e commerce, invoice
13. car, leasing, invoice
14. e commerce, leasing, invoice
15. car, e commerce, leasing, invoice

The following queries will cause Data Summary to process specific transactions: