...
- Visibility: Select if the row should be displayed on the dashboard table/chart. Select "hidden" if the result is only used for calculations.
- Aggregate: A row can only have one result (but different columns in case of grouping). Select the method how the the results (of each column) should be aggregated.
- Column: The database column used for calculation or a column based function (like "distinct") depending of the selected aggregate function.
- Date Filter: The Date Range Variable (Global or Report scope) that contains the date period where the invoices are collected from. Please note that reports variables with the same name (case sensitive) are overriding global variables.
- Filter Button: It's possible to add additional filters by comparing a column to a variable (global/report scope, only matching variable types are shown), e.g. "Products" "greater than" "transactional_xray" to count only radiography products
- Filter Logic: allows boolean operations on the defined filters (currently not implemented)