KPI Row Type

Input fields:

• Display Name: see report fields
• Name: see report fields
• Description: see report fields
• Type: The type of a row describes where it collects the data (see description on the right). Depending what type is selected the options to configure the type are displayed below:
  • Invoice: Collects data from the invoices table
  • Invoice Line: Collects data from the invoice lines table
  • Profit and Loss: Collects data from the ledger accounts imported from the bookkeeping software
  • KPI: Collects data from "Manual Data Points" (time based static values) (see Settings > Manual Data Points)
  • Formula: Use existing report variables or row results to calculate a value
  • /wiki/spaces/SVA/pages/10420360: Use a predefined SQL query (see Settings > SQL Query). These SQL queries can only be defined/edited by admins (for security reasons)
  • Alias Normalisation Factor: (currently not in use)

Enter display name and description and, as we want to count invoices, select type "KPI". The options are now displayed below:

Input Fields:

• Visibility: Select if the row should be displayed on the dashboard table/chart. Select "hidden" if the result is only used for calculations.
• 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.
• KPI: A Manual Data Point. Keep in mind, that if no value is set during the given period in the in the Manual Data Point, the value of the month is 0
• Aggregate: A row can only have one result. Select the method how the monthly values in the Manual Data Point should be aggregated.