Know Your Customer KPIs & Measures

Catalog of the 403 measures shipped with the Know Your Customer semantic model, grouped by their display folder. Captions are shown in English and German together with the number format. Use any measure with any dimension to build your own analysis.

AvgAmounts

Measure (EN)	Measure (DE)	Format	Description
Avg. Invoice Unit Price	ø Rechnungsstückpreis		Shows the average price charged per unit on invoices by dividing the total invoice amount by the number of units sold. Useful for analyzing pricing trends and profitability across products or time periods. If there are no units on an invoice, the result is shown as zero.
Ø Sales Price p.U.	Ø Verkaufspreis pro Einheit	#,##0.0	Shows the average sales amount earned for each unit sold. Useful for understanding the typical revenue generated per item, helping assess pricing and sales performance. The calculation divides total sales revenue by the number of units sold, and will return zero if no units have been sold.
Avg Sales per Unit PY	Ø Verkaufspreis pro Einheit PY	#,##0.0	Shows the average sales amount per unit for the previous year, helping you compare current sales performance to last year’s results. The calculation uses only sales data from the prior year to provide a relevant year-over-year benchmark. This is useful for tracking trends and setting sales targets.
Avg. Sales per Unit YoY	Ø Verkaufspreis pro Einheit YoY	#,##0.0	Shows the year-over-year change in average sales amount per unit, helping you compare how much revenue was generated per item sold this year versus last year. This KPI highlights trends in pricing or sales mix by focusing on the average value per unit sold, rather than total sales. It specifically measures the difference between the current and previous year to track performance over time.
Avg Sales per Unit YoY %	Ø Verkaufspreis pro Einheit YoY %	#,##0 %	Shows the year-over-year percentage change in average sales amount per unit. This KPI helps track how the average revenue per product sold has increased or decreased compared to the same period last year. It is useful for identifying pricing trends or changes in product mix over time.
Average Invoice Amount	Ø Rechnungsbetrag	#,##0	Calculates the average value of each invoice by dividing the total invoiced amount by the number of unique invoices. This KPI helps assess typical invoice size, supporting analysis of sales trends and customer purchasing behavior. The calculation considers only distinct invoices, providing a clear picture of average transaction amounts.
Avg Invoice Amount PY	Ø Rechnungsbetrag PY	#,##0	Represents the average invoice amount for the same period in the previous year, helping to compare current performance with last year's results. Useful for identifying trends and year-over-year changes in sales or billing. The calculation only includes data where the time context is set to "Previous Year."
Average Invoice Amount YoY	Ø Rechnungsbetrag YoY	#,##0	Shows the average invoice amount for the current period compared to the same period last year, helping track year-over-year changes in sales or billing. This figure reflects how the typical invoice value is evolving annually, supporting trend analysis and performance evaluation. Only invoices matching the year-over-year timeframe are included in the calculation.
Average Invoice Amount YoY %	Ø Rechnungsbetrag YoY %	#,##0 %	Shows the year-over-year percentage change in the average invoice amount, helping you track how invoice values are increasing or decreasing compared to the same period last year. This metric is useful for identifying sales trends and growth rates, and is calculated as a percentage to easily compare performance over time. The calculation specifically looks at average invoice values filtered to show annual change.
Ø Order Amount	Ø Auftragsbetrag	#,##0	Calculates the average amount per order by dividing the total order value by the number of unique orders. This helps assess how much customers typically spend in a single order, supporting sales performance analysis. The value is shown in the same currency as your sales data.
Avg Order Amount PY	Ø Auftragsbetrag PY	#,##0	Shows the average order amount from the previous year, helping you compare current performance to the same period last year. Useful for identifying growth trends or seasonal changes, it specifically focuses on orders labeled as "PY" (Previous Year) in your time filter. The result is displayed in your standard currency unit.
Avg Order Amount YoY	Ø Auftragsbetrag YoY	#,##0	Shows the average order amount for the current period compared to the same period last year, helping to track year-over-year changes in order value. The calculation focuses specifically on orders from equivalent timeframes, such as this month versus the same month last year, to highlight growth or decline trends. Values are displayed in currency units and are useful for assessing performance over time.
Avg Order Amount YoY %	Ø Auftragsbetrag YoY %	#,##0 %	Shows the year-over-year percentage change in the average order amount, helping you track growth or decline compared to the same period last year. This metric is useful for identifying trends in customer spending over time. The calculation focuses specifically on percentage differences between years, giving you a clear view of annual performance shifts.
Avg Sales Price per Unit	Ø Verkaufspreis pro Einheit	#,##0.0	Shows the average sales price received for each unit sold by dividing total order value by the total number of units sold. Useful for understanding pricing trends and evaluating revenue per item. If no units are sold, the result is zero.
Avg. Sales Price per Unit PY	Ø Verkaufspreis pro Einheit PY	#,##0.0	Represents the average sales price per unit from the previous year. Useful for comparing current pricing trends to the same period last year to identify changes or patterns. The calculation uses sales data filtered specifically for the previous year's timeframe.
Avg Sales Price per Unit YoY	Ø Verkaufspreis pro Einheit YoY	#,##0.0	Shows the year-over-year change in the average sales price per unit, helping to compare pricing trends between the current year and the previous year. Useful for understanding how pricing strategies or market conditions have affected the average sales price over time. The calculation focuses specifically on annual differences, excluding other time periods.
Avg Sales Price YoY %	Ø Verkaufspreis pro Einheit YoY %	#,##0 %	Shows the year-over-year percentage change in the average sales price per unit. This KPI helps track pricing trends over time, highlighting how much the average unit price has increased or decreased compared to the same period last year. Results are expressed as a percentage, providing quick insight into pricing performance and potential impacts on revenue.

Basic

Measure (EN)	Measure (DE)	Format	Description
Cr. Memo Amount	Gutschriftsbetrag	#,##0	CrMemo Amount excl. Discounts
Cr. Memo Amount (Gross)	Gutschriftsbetrag Brutto	#,##0	Quantity x Unitprice
Cr.Memo Cost Amount	Kosten (kalk. Gutschrift)	#,##0	Cr. Memo Cost Amount
Cr. Memo Gross Wt	Bruttogewicht (Gutschrift)	#,##0
Cr. Memo Line Discount	Positionsrabatt (Gutschrift)	#,##0	Line discount of Cr. Memo line
Cr. Memo Profit Margin	Gutschrifts DB	#,##0	Profit Margin on Cr. Memo
Cr.Memo Qty	Gutschriftsmenge	#,##0	Quantity on Credit Memo
Gross Weight	Bruttogewicht	#,##0	Gross Weight shows the total weight of all products sold, measured in the base unit of weight (such as kilograms or pounds). It helps track the overall volume of goods shipped or handled within a specific period. This figure is calculated by adding up the gross weight for each sales transaction.
Invoice Amount	Rechnungsbetrag	#,##0	Represents the total sales amount for documents classified specifically as invoices, regardless of any filters on the sales document type. Useful for tracking overall invoiced revenue, this measure ensures only invoice-related sales are included and ignores other document types like orders or credit notes. The value is typically expressed in the transaction currency and helps monitor true invoiced sales performance.
Invoice Amount	Rechnungsbetrag Brutto	#,##0	Represents the total gross sales amount from invoices, shown in the target currency. Useful for tracking overall invoiced revenue without limiting the results by document type filters, as it always includes all invoices regardless of other selections. Calculation specifically focuses on documents classified as invoices, ensuring accuracy when comparing invoiced sales across different periods or segments.
Invoice Amount Plan	Rechnungsbetrag (Plan)	#,##0	Invoice Amount Plan represents the planned or targeted invoice amount set for a specific period or scenario. It is used to compare actual invoice performance against business goals or forecasts. The value may be adjusted based on time frames, departments, or other business filters to support budgeting and performance analysis.
Invoice Amount PY	Rechnungsbetrag PY	#,##0	Shows the total invoiced amount for the same period in the previous year, allowing you to compare current performance against last year’s results. Useful for tracking year-over-year growth or trends, it only includes data classified as “previous year” in your time intelligence setup. The amount is reported in the same units as your invoice data (e.g., dollars, euros).
Invoice Amount YoY	Rechnungsbetrag YoY	#,##0	Shows the total invoice amount for the current period compared to the same period last year, allowing you to track year-over-year changes in sales or billing. This measure helps businesses understand growth trends by comparing invoice totals across years. Results are filtered to only include amounts labeled as "YoY" in the time intelligence context.
Invoice Amount YoY %	Rechnungsbetrag YoY %	#,##0 %	Shows the percentage change in total invoice amounts compared to the same period last year. Useful for tracking year-over-year sales growth or decline. Expressed as a percentage, it helps identify trends and performance changes over time.
Invoice Cost	Kosten (kalk. Rechnung)	#,##0	Represents the total cost amount of all invoices, shown in the target currency. It focuses specifically on documents classified as invoices, regardless of other sales document types. Useful for tracking and analyzing the cost side of invoiced sales across different periods or filters.
Invoice Gross Weight	Bruttogewicht (Rechnung)	#,##0	Represents the total gross weight of all invoiced sales, regardless of sales document type, filtered specifically to include only records classified as invoices. Useful for tracking the overall volume of goods shipped on invoiced transactions, this value is typically measured in units such as kilograms or pounds and excludes other sales document types like orders or quotes.
Invoice End Discount	Rechnungskopfrabatt	#,##0	Represents the total end discount given on sales invoices, shown in the target currency. This value is calculated across all types of sales documents but only includes records identified as invoices. Useful for tracking the overall discount impact on invoiced sales, regardless of other sales document types.
Invoice Line Discount	Rechnungspositionsrabatt	#,##0	Represents the total value of sales discounts given on invoice lines, expressed in the target currency. It focuses only on records classified as invoices, ignoring any filters on document types to ensure a consistent view. Useful for analyzing how much discount is granted specifically through invoices, regardless of other sales document types.
Invoice Profit Margin	Rechnungs DB	#,##0	Shows the total profit earned from sales invoices by subtracting sales costs from sales revenue. It focuses only on transactions classified as invoices, ignoring any other sales document types. Use this KPI to track profitability specifically for invoiced sales, helping assess how much profit invoices are generating over a given period.
Invoice Profit Margin %	Rechnungs DB (%)	#,##0.0 %	Shows the percentage of profit earned from invoices by comparing total profit to total invoiced amount. This KPI helps assess how much profit is generated for every dollar billed to customers. The result is expressed as a percentage, making it easy to track profitability trends over time.
Invoice Profit Margin % Last Year	Rechnungs DB (%) PY	#,##0.0 %	Shows the percentage profit margin from invoices for the previous year, allowing you to compare current profitability with last year’s performance. The calculation filters data to only include invoice profit margins from the same period one year ago. Use this KPI to track year-over-year changes in profitability and identify trends or improvements.
Invoice Profit Margin % YoY	Rechnungs DB (%) YoY	#,##0.0" %p"	Shows the year-over-year percentage change in invoice profit margin, helping you track how profitability per invoice has changed compared to the same period last year. This value is shown as a percentage and is filtered specifically to highlight annual trends. Use this KPI to quickly assess improvements or declines in profitability on invoices over time.
Invoice Profit Margin PY	Rechnungs DB PY	#,##0	Shows the profit margin earned from invoices during the previous year. Useful for comparing current performance to last year’s results and tracking profitability trends over time. The calculation specifically looks at invoice profit margins filtered to the prior year, allowing for year-over-year analysis.
Invoice Profit Margin YoY	Rechnungs DB YoY	#,##0	Shows the year-over-year change in invoice profit margin, allowing you to compare the current year’s profitability on invoiced sales to the previous year. This helps identify trends in profitability over time. The calculation is filtered to specifically highlight yearly differences.
Invoice Profit Margin YoY %	Rechnungs DB YoY %	#,##0 %	Shows the year-over-year percentage change in profit margin from invoices. This KPI helps track how efficiently the business is generating profit from sales compared to the same period last year. It expresses the change as a percentage, allowing you to quickly assess profit margin trends over time.
Invoice Qty	Menge (Rechnung)	#,##0	Represents the total number of items invoiced, regardless of the sales document type currently selected. Useful for tracking the quantity of products sold through invoices only, this calculation ignores any filters on document types and focuses exclusively on those categorized as invoices. The value is shown in units, reflecting only invoiced sales.
Order Amount	Auftragsbetrag	#,##0	Represents the total sales amount for orders, regardless of the specific type of sales document. Used to track revenue generated from order transactions only, filtering out other sales document types such as quotes or returns. The calculation always sums sales for the selected order type, ensuring consistent comparison across different views or filters.
Order Amount	Auftragsbetrag Brutto	#,##0	Represents the total gross order amount in the target currency, focusing only on orders that match a specific sales document type. Used to track and compare gross sales performance for a chosen order type, regardless of any filters on sales document types elsewhere in reports. The calculation ignores other sales document type filters to ensure consistency and comparability.
Open Order Amount	Auftragsbetrag (offen)	#,##0	Represents the total value of orders that are currently open and not yet completed. Useful for tracking outstanding sales and monitoring work in progress. Only includes orders with a status marked as "open" (OrderStatusId = "0"), helping businesses understand current commitments and potential revenue.
Order Amount Open	Auftragswert offen	#,##0	Calculates the total value of open orders, providing insight into outstanding sales that are yet to be fulfilled. The result shows the sum in monetary terms, without applying any extra filters or adjustments. This helps track potential revenue from orders still in progress.
Order Amount Open PY	Bestellwert Offen VJ	#,##0	Represents the total value of open orders from the same period in the previous year, allowing for year-over-year comparison of outstanding orders. Useful for tracking changes in open order volume and identifying trends over time. The calculation specifically filters data to only include orders classified as "open" and aligns them with the corresponding timeframe from last year.
Open Order Amount YoY	Offener Auftragswert YoY	#,##0	Shows the year-over-year change in the value of open orders, helping to compare current open order amounts with the same period last year. Useful for tracking sales growth or decline in open orders over time. The calculation focuses only on orders that remain open and applies a filter to present the data as a year-over-year comparison.
Order Amount Open YoY %	Bestellwert Offen YoY %	#,##0 %	Shows the year-over-year percentage change in the total value of open orders. This helps track growth or decline in open order amounts compared to the same period last year, providing insight into sales performance trends. The value is expressed as a percentage and focuses only on orders that are currently open.
Order Amount Plan	Auftragswert Plan	#,##0	Order Amount Plan represents the target or planned value for total order amounts within a selected period. It serves as a benchmark to compare actual sales performance against business goals. Currently, no value is assigned, so the planned amount needs to be defined to enable effective performance tracking.
Order Amount Last Year	Auftragswert VJ	#,##0	Shows the total order amount from the same period in the previous year. Useful for comparing current sales performance against last year's results to identify growth or decline. The calculation filters data to only include orders that match the prior year timeframe.
Order Amount YoY	Bestellwert YoY	#,##0	Shows the total value of orders compared to the same period in the previous year. Useful for tracking year-over-year growth or decline in sales performance. The calculation specifically filters the data to reflect only year-over-year comparisons.
Order Amount YoY %	Bestellwert YoY %	#,##0 %	Shows the percentage change in order amount compared to the same period last year, helping track year-over-year sales growth or decline. Useful for identifying trends and seasonality in order revenue over time. The calculation compares total order amounts across matching time periods, expressed as a percent change.
Order Cost	Kosten (kalk. Auftrag)	#,##0	Represents the total cost amount of orders, converted to the target currency, regardless of the type of sales document. Used to analyze the overall order-related costs by filtering specifically for documents classified as orders, helping businesses understand expenses associated with order processing. The calculation ignores other sales document types and focuses only on those matching the selected order type.
Order Gross Weight	Bruttogewicht (Auftrag)	#,##0	Represents the total gross weight of orders, ignoring any filters on sales document types and focusing only on orders that match a specific sales document type as defined by user input or report parameters. Useful for analyzing the overall weight of products shipped or sold in a selected order category. The value is calculated in base weight units and ensures consistency by excluding other sales document types from the calculation.
Order End Discount	Auftragskopfrabatt	#,##0	Calculates the total value of end-of-order header discounts given in the target currency, specifically for sales documents matching the selected order type. The measure ignores any filters on sales document types except for the one specified by the current parameter, ensuring accurate comparison or analysis of header discounts across different order types. Results are displayed in the target currency as defined in the underlying data.
Order Line Discount	Auftragspositionsrabatt	#,##0	Calculates the total value of sales discounts given on order lines, expressed in the target currency. The result focuses only on a specific sales document type, as defined by a parameter, and ignores any filters on sales document types that might be applied elsewhere in the report. Useful for understanding how much discount is being provided for a particular kind of order, regardless of other filter selections.
Order Profit Margin	Auftrags DB	#,##0	Shows the total profit from sales orders by subtracting sales costs from sales amounts, specifically for the selected order type. This calculation ignores any filters on sales document types to ensure consistent comparison, and only includes orders matching the chosen order category. The result helps assess profitability for specific types of sales orders.
Order Qty	Auftragsmenge	#,##0	Represents the total number of items ordered, regardless of the type of sales document. It specifically filters the results to include only orders that match a selected sales document type, based on user input or report parameters. Useful for tracking how many units have been ordered for a specific type of sales transaction across the entire dataset.
OTD Rate	OTD Rate	#,##0.0 %	Share of orders, delivered on time
Profit	Deckungsbeitrag	#,##0	Shows how much profit your business makes after subtracting costs from sales revenue. Useful for understanding the profitability of products or services over a given period. Calculated by taking total sales revenue and subtracting the total sales costs, showing results in the same currency as sales.
Profit Margin %	Deckungsbeitrag %	#,##0.0 %	This KPI shows the percentage of profit earned for every dollar of sales. It helps assess how efficiently the company is turning sales into profit. The value is calculated by dividing total profit by total sales, expressed as a percentage, making it easy to compare profitability across different periods, products, or business segments.
Quote Amount	Angebotsbetrag	#,##0	Quote Amount excl. Discounts
Quote Amount	Angebotsbetrag Brutto	#,##0	Quantity x Unitprice
Quote Cost Amount	Kosten (kalk. Angebot)	#,##0	Quote Cost Amount
Quote Gross Wt	Bruttogewicht (Angebot)	#,##0
Quote Line Discount	Positionsrabatt (Angebot)	#,##0	Line discount of Quote position
Quote Profit Margin	Angebots DB	#,##0	Profit Margin on Quote
Quote Qty	Angebotsmenge	#,##0	Quantity on Quote
Sales Amount	Verkaufsbetrag	#,##0	Represents the total sales value after including any end-of-sale header discounts, shown in the target currency. Used to track actual revenue from sales transactions, accounting for both the original sales amount and additional header-level discounts applied at the end of the sale. This figure helps provide a more accurate view of overall sales performance for financial reporting and analysis.
Sales Amount	Verkaufsbetrag (Brutto)	#,##0	Represents the total sales revenue before any deductions, such as discounts or returns, expressed in the target currency. It helps track overall sales performance and compare sales figures across different regions or periods. The value reflects gross sales amounts without adjustments.
Sales Cost	Kosten (kalk.)	#,##0	Represents the total cost of goods sold, converted into the target currency, for all recorded sales. Useful for understanding overall spending on sold inventory and evaluating profitability. The calculation sums cost amounts across all sales transactions without additional filters.
Sales End Discount	Kopfrabatt	#,##0	Calculates the total end discounts applied at the sales order level, converted to the target currency. Useful for understanding how much discount is being given across all sales orders, helping assess pricing strategies and discount policies. The value reflects all final discounts before the completion of sales transactions, standardized in the target currency for accurate comparison.
Sales Discount	Positionsrabatt	#,##0	Represents the total amount of discounts given on sales, expressed in the target currency. This figure helps assess how much value is being reduced from sales due to discounts, supporting analysis of pricing strategies and discount effectiveness. The calculation is based on all sales transactions, reflecting the sum of discounts applied.
Sales Qty	Verkaufsmenge	#,##0	Represents the total number of units sold, providing insight into overall sales volume. Useful for tracking product performance and identifying sales trends over time. The value reflects the sum of all sales quantities recorded in the sales data.
Shipment Amount	Lieferscheinbetrag	#,##0	Represents the total sales amount for shipments, regardless of the sales document type filter applied elsewhere in reports. Used to track revenue specifically from shipped orders, ensuring only documents matching the specified shipment type are included. The value is shown in the relevant currency and ignores any other sales document type filters to provide a clear view of shipment-related sales.
Shipment Amount	Lieferscheinbetrag Brutto	#,##0	Represents the total gross sales amount from shipments, converted to the target currency. This calculation includes all types of sales documents but filters specifically for shipment transactions, making it useful for analyzing shipment-related revenue regardless of other document types. The result shows the gross value, helping track how much revenue is generated from goods shipped to customers.
Shipment Cost	Kosten (kalk. Lieferschein)	#,##0	Represents the total shipment costs, shown in the target currency, regardless of the type of sales document. Useful for understanding overall shipping expenses by focusing only on documents classified as shipments. The calculation ignores any filters on sales document types to ensure consistency and uses a specific parameter to identify shipment-related documents.
Shipment Gross Wt	Bruttogewicht (Lieferschein)	#,##0	Represents the total gross weight of goods shipped, regardless of the type of sales document. This figure specifically focuses on shipments that match the selected shipment document type, helping track logistics and transportation performance. The value is given in base weight units and is not affected by any other sales document type filters that might be applied elsewhere in the report.
Shipment Line Discount	Positionsrabatt (Lieferschein)	#,##0	Calculates the total value of sales discounts, converted to the target currency, given on shipment sales documents. Used to analyze discount amounts specifically for shipments, regardless of the original sales document type. The calculation ignores any existing filters on document types and focuses only on records classified as shipment documents.
Shipment Profit Margin	DB (Lieferschein)	#,##0	Calculates the total profit from shipments by subtracting sales costs from sales revenue, focusing only on documents classified as shipments. Ignores any filters on sales document type to ensure results always reflect all shipment transactions. Useful for analyzing the overall profitability of shipped orders regardless of other sales document categories.
Shipment Qty	Menge (Lieferschein)	#,##0	Shows the total number of items shipped, regardless of the sales document type filter applied elsewhere in the report. Useful for tracking overall shipment volumes based on a specific sales document type selected by the user, ensuring consistency in shipment reporting. The result is always in base units of quantity and reflects only shipments matching the selected shipment document type.

Basic (Invoice + CrMemo)

Measure (EN)	Measure (DE)	Format	Description
Revenue	Umsatz	#,##0	Revenue excl. Discounts (Invoices excl. Credit Memos)
Revenue PY	Umsatz PY	#,##0	Revenue excl. Discounts (Invoices excl. Credit Memos) of Previous Year
Revenue YoY	Umsatz YoY	#,##0	Deviation of Revenue excl. Discounts (Invoices excl. Credit Memos) vs. Previous Year
Revenue YoY %	Umsatz YoY %	#,##0 %	Deviation of Revenue excl. Discounts (Invoices excl. Credit Memos) vs. Previous Year in %

Basic\TimeIntelligence\PY

Measure (EN)	Measure (DE)	Format	Description
CrMemo Amount PY	CrMemo Amount PY	#,##0
OTD Rate PY	OTD-Rate VJ	#,##0.0 %	Shows the On-Time Delivery (OTD) Rate from the previous year, allowing you to compare current performance with last year’s results. This KPI helps identify trends and measure year-over-year improvements or declines in delivery reliability. The calculation specifically filters the data to only include values from the prior year.
Shipment Amount Gross PY	LS Betrag Brutto VJ	#,##0	Shows the total shipment revenue (gross) for the previous year, allowing you to compare past performance with current results. The calculation filters data to include only shipments from the prior year, helping track year-over-year changes in shipment amounts. Values are expressed in the same units as shipment revenue.
Shipment Amount PY	LS Betrag VJ	#,##0	Represents the total value of shipments made during the same period in the previous year. Useful for comparing current shipment performance against last year's results to identify trends or growth. The calculation filters data to only include shipment amounts from the prior year.
Shipment Cost Amount PY	Kosten VJ	#,##0	Shows the total shipment cost for the same period in the previous year. This helps compare current shipping expenses with last year’s performance to identify trends or changes. The calculation uses the same units and criteria as the current shipment cost but specifically looks at the prior year for accurate year-over-year analysis.
Shipment Gross Weight Previous Year	Sendungsbruttogewicht VJ	#,##0	Shows the total gross weight of shipments from the previous year. Useful for comparing shipment volumes over time, this value helps track year-over-year changes in shipping activity. The calculation specifically filters to include only data from the prior year for accurate historical comparison.
Shipment Line Discount PY	Versandposition Rabatt VJ	#,##0	Shows the total shipment line discounts given during the same period in the previous year. Useful for comparing current discount trends to last year’s performance, this KPI is filtered to only include data from the prior year’s timeframe. Results are typically shown in the same units as your discount measure (such as dollars or percentage).
Shipment Profit Margin PY	Marge VJ	#,##0	Shows the shipment profit margin from the previous year, allowing you to compare current performance with last year's results. Useful for tracking year-over-year changes in profitability related to shipments. The value reflects the profit margin percentage specifically for the same period one year ago.
Shipment Qty PY	Versandmenge VJ	#,##0	Shows the total number of units shipped during the same period last year, allowing you to compare current shipping performance with previous year results. Useful for identifying growth trends and seasonal patterns by analyzing year-over-year changes in shipment quantities. The calculation specifically filters data to only include shipments from the prior year.

Basic\TimeIntelligence\YoY

Measure (EN)	Measure (DE)	Format	Description
CrMemo Amount YoY	CrMemo Amount YoY	#,##0
OTD Rate YoY	OTD-Rate VJ	#,##0.0	OTD Rate YoY shows the year-over-year change in the On-Time Delivery (OTD) rate, comparing current performance to the same period last year. This helps businesses track improvements or declines in delivery reliability over time. The calculation specifically filters data to highlight only the YoY (year-over-year) comparison.
Shipment Amount Gross YoY	LS Betrag Brutto YoY	#,##0 %	Shows the year-over-year change in total gross shipment amount, helping you compare current performance to the same period last year. This KPI is useful for understanding growth trends in shipments over time. The calculation specifically looks at shipments where the time context is set to year-over-year.
Shipment Amount YoY	LS Betrag YoY	#,##0 %	Shows the total value of shipments compared to the same period in the previous year. Useful for tracking year-over-year growth or decline in shipment revenue. The calculation only includes shipment amounts flagged as "Year over Year" in the time intelligence settings.
Shipment Cost Amount YoY	Kosten YoY	#,##0 %	Shows the change in total shipment costs compared to the same period last year, helping to track year-over-year trends. Useful for analyzing how shipping expenses are evolving over time. The calculation compares shipment costs from the current period to those from the previous year, using year-over-year filtering.
Shipment Gross Weight YoY	Sendungsbruttogewicht YoY	#,##0 %	Compares the total shipment gross weight for the current period to the same period last year, showing year-over-year change. This helps track trends in the volume of goods shipped over time. The calculation uses only shipments that match the “Year over Year” filter for accurate comparison.
Shipment Line Discount YoY	Versandpositionsrabatt YoY	#,##0 %	Shows the year-over-year change in discounts given on shipment lines, helping to track how discount strategies are evolving annually. This value compares total discounts from the current year against the previous year, providing insight into trends or shifts in pricing or promotional activities. The calculation focuses specifically on shipment line discounts and uses a time-based filter to ensure accurate annual comparison.
Shipment Profit Margin YoY	Marge YoY	#,##0 %	Shows the year-over-year change in profit margin specifically for shipments, allowing you to compare profitability from one year to the next. This calculation helps track trends and identify whether shipment profitability is improving or declining over time. The result is filtered to show only the year-over-year (YoY) comparison, making it useful for performance analysis and reporting.
Shipment Qty YoY	Versandmenge YoY	#,##0 %	Shows the year-over-year change in the total number of items shipped. It helps compare current shipment volumes to the same period in the previous year, making it easy to track growth or declines over time. The calculation specifically looks at shipments marked for year-over-year analysis to provide accurate trend insights.

Basic\TimeIntelligence\YoY %

Measure (EN)	Measure (DE)	Format	Description
CrMemo Amount YoY %	CrMemo Amount YoY %	#,##0 %
OTD Rate YoY %	OTD-Quote YoY %	#,##0 %	Shows the year-over-year percentage change in the On-Time Delivery (OTD) Rate, helping you track how timely deliveries have improved or declined compared to the same period last year. This measure is useful for identifying long-term trends in delivery performance. The value is expressed as a percentage and specifically compares current results to those from the previous year.
Shipment Amount Gross YoY %	LS Betrag Brutto YoY %		Shows the percentage change in total gross shipment amount compared to the same period last year. This KPI helps track year-over-year growth or decline in shipments, making it useful for analyzing business trends over time. The value is expressed as a percentage, highlighting performance changes while filtering the data to focus specifically on the year-over-year comparison.
Shipment Amount YoY %	LS Betrag YoY %		Shows the year-over-year percentage change in shipment amounts, helping you track how shipments are growing or declining compared to the same period last year. This KPI is useful for identifying trends and measuring business performance over time. The calculation is based on comparing current and previous year shipment totals, expressed as a percentage change.
Shipment Cost YoY %	Kosten YoY %		Shows the year-over-year percentage change in total shipment costs, helping you compare current shipment expenses to the same period last year. This KPI is useful for tracking trends in shipping efficiency and cost management over time. The calculation expresses the change as a percentage, making it easy to spot increases or decreases in shipping costs year to year.
Shipment Gross Weight YoY %	Sendungsbruttogewicht YoY %		Shows the year-over-year percentage change in the total gross weight of shipments. This KPI helps track how the overall weight of goods shipped compares to the same period last year, highlighting trends in shipping volume growth or decline. The percentage is calculated by comparing the current period's shipment gross weight to the previous year's equivalent period.
Shipment Line Discount YoY %	Versandposition Rabatt YoY %		Shows the year-over-year percentage change in shipment line discounts, helping you compare how discount levels have changed from the same period last year. This measure highlights trends in discounting practices and supports analysis of pricing strategy effectiveness over time. The calculation focuses specifically on shipment line discounts and expresses the result as a percentage change compared to the previous year.
Shipment Profit Margin YoY %	Marge YoY %		Shows the percentage change in shipment profit margin compared to the same period last year. This helps track whether profitability from shipments is improving or declining year over year. The calculation compares profit margins for the current period against those from the previous year to highlight trends.
Shipment Qty YoY %	Versandmenge YoY %		Shows the percentage change in the number of items shipped compared to the same period last year. This KPI helps track year-over-year growth or decline in shipments, making it useful for understanding business trends over time. The calculation compares total shipment quantities between equivalent time periods to highlight performance changes.

Counts

Measure (EN)	Measure (DE)	Format	Description
Cnt. of Cr. Memo Lines	Anz. Gutschriftspos.	#,##0	Number of CrMemo Lines
Invoice Line Count	# Rechnungspositionen	#,##0	Counts the total number of invoice lines recorded in sales transactions, regardless of the sales document type filter applied elsewhere in the report. Useful for tracking invoicing activity across all sales documents classified as invoices. The calculation specifically includes only those document types identified as invoices, ensuring consistency in reporting.
# Order Line (Late Delivery)	# Auftr.Pos. (Lieferung verspätete)	#,##0	Counts the total number of order lines that were shipped late, focusing only on a specific type of sales document selected by the user or report context. The calculation ignores any other filters on sales document types to ensure consistency and accuracy. This KPI helps track operational performance related to timely shipments for a particular sales process.
Order Line Count	Anzahl Auftragspositionen	#,##0	Counts the total number of individual order lines from the sales data, regardless of the sales document type filter currently applied. This figure specifically reflects only the order type selected in the report parameters, making it useful for analyzing sales activity by chosen order categories. Each count represents a single line item within an order, providing insight into order volume and transaction detail for targeted sales documents.
Cnt. of Cr. Memos	Anz. Gutschriften	#,##0	Number of Cr Memos
# Unique Invoice Customers	# Rechnungskunden	#,##0	Counts the number of unique customers who have received at least one invoice within the selected time period. This helps track how many different customers are actively making purchases, giving insight into customer reach and engagement. Each customer is only counted once, even if they have multiple invoices.
# Unique Invoice Customers PY	# Rechnungskunden PY	#,##0	Counts the number of distinct customers who received invoices during the same period last year. Useful for year-over-year analysis of your customer base, this metric helps track how your reach to unique customers is changing over time by comparing it to the previous year. The calculation focuses specifically on the prior year, providing valuable context for performance trends.
# Unique Invoice Customers YoY	# Rechnungskunden YoY	#,##0	Shows the year-over-year change in the number of unique customers who received invoices. This helps track customer growth or retention over time by comparing the current year's customer count to the previous year's, focusing only on distinct customers who were invoiced. The calculation filters data to highlight annual trends.
Unique Invoice Customers YoY %	# Rechnungskunden YoY %	#,##0 %	Shows the percentage change in the number of unique customers who received invoices compared to the same period last year. This helps track customer growth or retention over time, focusing only on distinct invoiced customers. Results are expressed as a year-over-year percentage to highlight trends in customer engagement.
# Unique Invoices	# Rechnungen	#,##0	Counts the number of unique invoices issued, regardless of the sales document type filter currently applied to the report. This is useful for understanding the total volume of distinct invoices within a selected sales document type, as defined by a specific parameter. The calculation ignores any filters on sales document type to ensure consistent and accurate invoice counts.
# Unique Invoices PY	# Rechnungen PY	#,##0	Shows the total number of unique invoices issued during the previous year. This KPI is useful for comparing current sales activity against last year’s performance. The calculation only counts each invoice once and specifically filters results to reflect the same period in the prior year.
# Unique Invoices YoY	# Rechnungen YoY	#,##0	Shows the year-over-year change in the number of unique invoices issued, helping track business growth or decline compared to the previous year. The calculation specifically compares invoice counts for the same period across two consecutive years. Results are useful for identifying sales trends and evaluating performance over time.
# Unique Invoices YoY %	# Rechnungen YoY %	#,##0 %	Shows the percentage change in the number of unique invoices compared to the same period last year. This KPI helps track year-over-year growth or decline in invoicing activity, allowing businesses to monitor sales performance trends over time. The calculation uses invoice counts from both the current and previous year for an accurate comparison.
Unique Item Count	# Artikel	#,##0	Counts the number of different items sold, ensuring each item is only counted once, regardless of how many times it appears in the sales data. Useful for understanding product variety or range within the selected timeframe or filter. The result shows the total unique item count based on sales records.
# Unique Items Invoiced	# Artikel fakturiert	#,##0	Counts the number of unique items that have been invoiced, regardless of other sales document types. Useful for understanding the diversity of products sold on invoices within a specific context, as defined by the selected invoice type. The calculation ignores any filters on sales document type except for the designated invoice type, ensuring the result focuses solely on invoiced items.
# Unique Items Invoiced PY	# Artikel fakturiert PY	#,##0	Counts the number of distinct items that were invoiced during the previous year. This KPI helps track how product variety or sales activity has changed compared to the current year. The calculation only includes invoices that are specifically from the prior year, providing a direct year-over-year comparison.
# Unique Items Invoiced YoY	# Artikel fakturiert YoY	#,##0	Shows the year-over-year change in the number of unique items that have been invoiced. Useful for tracking how product variety or sales mix is evolving compared to the same period last year. The calculation only counts distinct items on invoices and compares the current period to the previous year.
Unique Items YoY %	# Artikel fakturiert YoY %	#,##0 %	Shows the year-over-year percentage change in the number of unique items that were invoiced. Useful for tracking growth or decline in product variety or customer purchasing patterns over time. The calculation compares the count of distinct items invoiced this year versus the previous year to highlight trends in sales activity.
# Unique Items PY	# Artikel PY	#,##0	Shows the total number of unique items sold or processed during the same period last year. This allows you to compare current performance against the previous year and track growth or changes over time. The calculation specifically filters the data to reflect only the results from the previous year.
YoY Unique Item Count	# Artikel YoY	#,##0	Calculates the year-over-year change in the number of unique items, allowing you to compare how many distinct items were present this year versus last year. Useful for tracking growth or decline in product diversity or offerings over time. The calculation specifically filters the data to show annual changes, focusing only on unique item counts.
Unique Items YoY %	# Artikel YoY %	#,##0 %	Shows the year-over-year percentage change in the number of unique items, helping you track growth or decline compared to the same period last year. This metric is useful for identifying trends and evaluating business performance over time. The calculation compares the total count of distinct items for the current period against the previous year's equivalent period.
# Unique Order Customers	# Auftragskunden	#,##0	Counts the number of individual customers who have placed orders, regardless of the type of sales document. This KPI is useful for understanding the breadth of your customer base over a selected period or filter, focusing specifically on orders that match a specified sales document type. The calculation ensures that each customer is only counted once, even if they have multiple orders, and applies a filter to isolate the relevant sales document type as defined by the report parameters.
# Unique Order Customers PY	# Auftragskunden PY	#,##0	Counts the number of distinct customers who placed orders during the same period last year. Useful for comparing customer engagement or growth over time, this metric focuses specifically on the previous year as defined by your time filters. The value reflects unique customers only, not total orders.
YoY Unique Order Customers	# Auftragskunden YoY	#,##0	Shows the year-over-year change in the number of distinct customers who have placed orders. This helps you track customer growth or retention by comparing the current year's unique ordering customers to the previous year. The calculation focuses only on customers with at least one order and highlights annual trends in your customer base.
Unique Order Customers YoY %	# Auftragskunden YoY %	#,##0 %	Shows the year-over-year percentage change in the number of unique customers who placed orders. This helps track customer growth or decline over time, making it easy to compare performance between the current and previous year. The calculation focuses only on customers who made at least one order and expresses the change as a percentage.
Unique Orders	# Aufträge	#,##0	Counts the number of unique sales orders, regardless of the sales document type filter currently applied. This KPI is useful for tracking the total distinct orders for a specific sales document type selected by the user, helping to analyze order volume and trends. The calculation ensures each order is only counted once and only for the chosen document type, making comparisons across different document types accurate.
# Unique Orders PY	# Aufträge PY	#,##0	Counts the number of unique orders placed during the same period last year. This helps compare current performance to the previous year and identify trends or changes over time. The calculation specifically looks at orders from the previous year, making it useful for year-over-year analysis.
YoY Unique Orders	# Aufträge YoY	#,##0	Shows the year-over-year change in the total number of unique orders placed. Useful for tracking growth or decline in customer activity compared to the same period last year. The calculation specifically filters results to display only the unique orders for the selected year and compares them to the previous year.
Unique Orders YoY %	# Aufträge YoY %	#,##0 %	Shows the percentage change in the number of unique orders compared to the same period last year. This helps track growth or decline in order volume year-over-year, making it easier to spot trends or seasonal patterns. The calculation focuses on unique orders and expresses the result as a percentage.

Customer Analytics\Churn

Measure (EN)	Measure (DE)	Format	Description
# Customers (next order overdue)	# Kunden (nächster Auftrag überfällig)	#,##0	Counts the number of customers whose next expected order is overdue, based on their average order frequency. This highlights customers who have not placed a new order within their typical time frame, allowing the business to identify and follow up with potentially inactive accounts. The calculation compares each customer’s last order date plus their average days between orders to today’s date, only including customers whose expected order date has already passed.
Churn Rate	Abwanderungsrate (einfach)	0.00\ %;-0.00\ %;0.00\ %	ChurnRate (simple) shows the percentage of customers who stopped doing business with your company, compared to the number of customers you had previously gained. It helps you track how well you are retaining customers over time. The rate is calculated by dividing the number of lost customers by the total number of customers you won earlier, expressed as a proportion.
Next Order Overdue Date	Nächster Auftrag überfällig am		Date when the next order is expected
Retention Rate	Kundenbindungsrate (simple)	0.00\ %;-0.00\ %;0.00\ %	This KPI calculates the customer retention rate by comparing the number of customers retained from a previous period to the total number of customers at the start of that period. It helps businesses understand how well they are keeping their existing customers over time. The measure only returns a value for dates up to the last recorded sale, ensuring that retention is not calculated for future periods.
Order Frequency (Days)	Auftragseingangsfrequenz (Tage)	#,##0	Shows the average number of days between customer orders within the selected period. It calculates the time from each customer’s first to last order, divided by the total number of their orders, and then averages this across all customers. Useful for understanding how frequently customers place orders, helping to identify trends in repeat purchasing behavior.

Customer Analytics\Classification

Measure (EN)	Measure (DE)	Format	Description
Customer ABC Class	Kunden-ABC-Klasse		Classifies each customer as "A", "B", or "C" based on their total sales contribution within the current selection or filter context. Customers are ranked by sales amount, with "A" representing the top 70% of total sales, "B" the next 20%, and "C" the remaining customers with non-zero sales. This KPI helps prioritize customers by their sales impact, commonly used for customer segmentation and sales strategy decisions.
Top N Customer	Top N Kunden		Indicates the sales ranking of each customer based on total sales amount, allowing you to identify top-performing customers. The measure assigns a rank to each customer, where a rank of 1 represents the customer with the highest sales. It works across different customer fields and tables, ensuring accurate ranking regardless of how customers are displayed in your report.

Customer Analytics\Cohort Analysis

Measure (EN)	Measure (DE)	Format	Description
Customer Retention %	Kundenbindung %	0\ %;-0\ %;0\ %	Shows the percentage of customers from a specific cohort (based on their first order month) who make repeat purchases after a certain number of months. This KPI helps track how well your business retains customers over time, using sales of a particular document type for accuracy. The calculation compares the number of returning customers in a future month to the original number in the cohort, providing insight into customer loyalty and retention patterns.

Customer Analytics\Loyalty

Measure (EN)	Measure (DE)	Format	Description
Lost Customers	# verlorene Kunden	#,##0	Counts the number of customers who are considered permanently lost within the selected period. A customer is defined as lost if they have not placed an order for a specified number of months, based on the "months considered as lost" parameter. This measure helps track customer attrition by showing how many customers reached their loss threshold during the current reporting period.
# New Customers	# Neukunden	#,##0	Counts how many customers placed their very first order during the selected month. This helps track customer growth by showing how many new clients were acquired in a given period. The number only includes customers whose first order date falls within the current month and excludes anyone with a first order before that period.
# Recovered Customers	# Kunden nach temp. Abwanderung	#,##0	Counts the number of customers who were previously considered temporarily lost but have made a new purchase within the selected period, indicating they have returned. This metric helps you track customer reactivation and the effectiveness of win-back efforts. Only actual sales orders are included, and the count is based on each customer’s first purchase date after their temporary loss status.
Returning Customer Count	# Wiederkehrende Kunden	#,##0	Counts the number of customers who make a purchase during a selected period after having previously bought from the company in an earlier period. Useful for understanding customer loyalty and repeat business, this measure only includes customers whose first purchase happened before the current period and have returned to buy again within the filtered timeframe and selected sales document type. The result helps track retention and the effectiveness of efforts to bring customers back.
Temporarily Lost Customer Count	# temp. verlorene Kunden	#,##0	Counts the number of customers who stopped buying for a period long enough to be considered lost but later returned and made a purchase. This helps businesses track customers who have lapsed temporarily rather than permanently, providing insights into customer recovery and re-engagement efforts. The calculation only counts customers as "temporarily lost" in the period when they were inactive and excludes those who never returned; it is typically used to analyze customer retention and win-back campaigns over time.
Lost Customer Sales	Auftragswert verlorener Kunden	#,##0	Represents the total order value from customers who are considered lost within a specific period, based on a set number of months since their last purchase. Useful for understanding the revenue impact of customer churn, it only includes customers whose last order date, plus the defined "lost" period, falls within the selected timeframe. The amount is shown as a negative value to highlight lost business.
New Customer Revenue	Auftragswert Neukunden	#,##0	This measure calculates the total order amount generated by customers who placed their first order during the selected month. It helps track revenue contributions from newly acquired customers, allowing you to assess the effectiveness of customer acquisition efforts. The calculation only includes customers whose first order date falls within the current month, and it sums their order amounts up to and including their first purchase.

Customer Analytics\Loyalty\tech

Measure (EN)	Measure (DE)	Format	Description
# New customers from previous periods	# Neukunden der Vorperioden	#,##0
Temporary Lost Customer Date	Temporär verlorener Kunde Datum

Customer Analytics\Loyalty\TimeIntelligence

Measure (EN)	Measure (DE)	Format	Description
# New Customers PY	# Neukunden VJ	#,##0	Counts the number of new customers acquired during the same period in the previous year. Useful for comparing customer growth trends over time, this figure helps assess year-over-year performance. The calculation specifically looks at last year’s timeframe to provide an accurate benchmark for current results.
New Customers YoY	# Neukunden YoY	#,##0	Tracks the year-over-year change in the number of new customers acquired, helping to compare current growth against the same period last year. The value shows how customer acquisition is trending annually, making it useful for monitoring long-term business growth. The calculation specifically filters data to only include new customers gained in the current year versus the previous year.
New Customers YoY %	# Neukunden YoY %	#,##0 %	Shows the percentage change in the number of new customers compared to the same period last year. This helps track growth or decline in acquiring new customers over time. The value is shown as a year-over-year percentage, making it easy to see trends and evaluate the effectiveness of customer acquisition efforts.

DailyOrders

Measure (EN)	Measure (DE)	Format	Description
Daily Orders Moving Ø 7D	Tgl. Auftragswert Ø 7D	#,##0	Calculates the average number of orders placed per day over the past 7 days, providing a smoothed view of recent sales activity. This rolling average helps identify short-term trends and fluctuations in order volume, making it useful for monitoring performance and making quick business decisions. The calculation considers only the most recent 7-day period, updating automatically as new data is added.
Daily Orders Avg. 7D PY	Tgl. Auftragswert Ø 7T VJ	#,##0	Calculates the average number of orders per day over a 7-day period, but looks at the same 7-day window from the previous year. This helps you compare current sales trends with the same time last year, highlighting year-over-year performance. The result is based on order amounts, averaged daily, using a rolling week from the prior year.
Daily Orders 7D Avg. Change	Tgl. Auftragswert ø 7T ∆.	#,##0	Shows the change in the 7-day average number of daily orders compared to the same period two weeks earlier. Useful for tracking recent trends in order volume and quickly spotting increases or decreases in demand. The calculation highlights short-term shifts by comparing current performance to past periods using a rolling weekly average.
Daily Orders 7D Avg. Change %	Tgl. Auftragswert ø 7T ∆%	#,##0.0 %	Shows the percentage change in the 7-day moving average of daily orders compared to the same period 14 days ago. This helps track short-term order trends and identify growth or decline over time, smoothing out daily fluctuations. The calculation expresses the change as a percentage, making it easy to compare performance across different time periods.
Daily Orders 7-14 Day Moving Avg	Tgl. Auftragswert ø 7-14T	#,##0	Represents the average number of orders placed each day during the 7-day period from 14 to 8 days ago, not including the most recent week. Useful for comparing current daily order trends with the previous period to spot changes in performance. The value is calculated by averaging daily order amounts over this specific past week.
Daily Orders Today	Heutiger Auftragswert	#,##0	Shows the total value of orders placed today, based on the current date in the calendar. Useful for tracking daily sales performance and monitoring business activity in real time. The calculation only includes orders that have a date matching today.
Daily Orders Today ∆	Tgl. Auftragswert Heute ∆	#,##0	Shows the change in the number of orders placed today compared to the previous day. This helps track day-over-day order growth or decline, allowing quick identification of sales trends. The value represents the difference in total orders between today and yesterday.
Daily Orders Today ∆ %	Tgl. Auftragswert Heute ∆ %	#,##0.0 %	Shows the percentage change in the number of orders placed today compared to yesterday. This helps track daily sales performance and identify trends or sudden changes in order volume. The result is shown as a percentage, and if there were no orders yesterday, the value will display as zero to avoid errors.
Daily Orders Yesterday	Gestriger Auftragswert	#,##0	Shows the total order amount recorded yesterday, helping track day-over-day sales performance. This value reflects all orders from the day before the current date, based on the business calendar. It is useful for daily sales monitoring and comparison with current or previous periods.
Daily Orders Day-over-Day ∆	Tgl. Auftragswert-1 ∆	#,##0	Shows the change in the number of orders between yesterday and the day before yesterday. This helps track short-term trends in daily order volume, making it easier to spot increases or decreases in customer activity. The value represents the difference in total orders from one day to the previous day.
Daily Orders Day-over-Day % Change	Tgl. Auftragswert-1 ∆%	#,##0.0 %	Shows the percentage change in the number of daily orders compared to the previous day. This helps track short-term order trends and identify sudden increases or drops in order volume. The value is expressed as a percentage and compares yesterday’s order change against the day before yesterday’s orders.
Daily Orders Today-2	Vorgestriger Auftragswert	#,##0	Shows the total order amount from two days prior to the current date, helping track recent sales trends and compare performance over time. The calculation focuses only on orders placed exactly two days before today, based on the business calendar. Results are expressed in the same units as order amounts, and only include data for that specific day.

DailySales

Measure (EN)	Measure (DE)	Format	Description
Daily Sales	Tgl. Verkäufe	#,##0	Daily Sales calculates the total value of sales made each day, based on invoice amounts. It helps track daily revenue performance and identify trends or patterns in sales activity. The result is shown in your chosen currency and summarizes all invoice amounts for each day.
Daily Sales Ø 7D	Tgl. Verkäufe Ø 7D	#,##0	Calculates the average daily sales over the past 7 days, providing a smoothed view of recent sales performance. This rolling average helps identify sales trends by minimizing the impact of daily fluctuations. The result is shown in monetary units and only includes the most recent 7-day period up to the latest date in the data.
Daily Sales Avg. 7D PY	Tgl. Verkäufe Ø 7D PY	#,##0	This KPI calculates the average daily sales over a 7-day period for the same time last year, providing a moving average that smooths out short-term fluctuations. It helps compare current performance to the previous year by looking at sales trends for each day, averaged across the prior week. The values are based on invoice amounts and reflect sales activity exactly one year ago, using a rolling 7-day window.
Daily Sales 7D Avg Δ	Tgl. Verkäufe Ø 7D ∆	#,##0	∆ compared to previous period (7D-14D)
Daily Sales 7D Avg Δ%	Tgl. Verkäufe Ø 7D ∆%	#,##0.0 %	∆ compared to previous period (7D-14D)
Daily Sales Avg 7-14 Days	Tgl. Verkäufe Ø 7D-14D	#,##0	Calculates the average daily sales for the week that is 7 to 14 days before the current date, helping track sales trends over time. Useful for comparing recent performance with past weeks to identify patterns or shifts in sales. The value is expressed in sales currency and specifically excludes the most recent 7 days, focusing on the prior week's activity.
Daily Sales Today	Heutige Verkäufe	#,##0	Shows the total value of sales invoices generated on the current day. Useful for tracking daily sales performance and monitoring today's revenue in real time. Only sales from today are included in the calculation.
Daily Sales Change Today	Tgl. Umsatz Heute ∆	#,##0	Shows the difference in sales between today and yesterday, highlighting whether sales have increased or decreased compared to the previous day. Useful for tracking short-term sales performance trends and identifying daily fluctuations. The result is given in sales units or currency, reflecting only today’s and yesterday’s figures without considering other dates.
Daily Sales Today ∆ %	Tgl. Umsatz Heute ∆%	#,##0.0 %	Shows the percentage change in today’s sales compared to yesterday. This helps track daily sales performance and spot trends or sudden shifts. The value is shown as a percentage, and if there were no sales yesterday, the result is zero to avoid errors.
Sales Yesterday	Tgl. Umsatz-1	#,##0	Shows the total sales amount from the previous day, helping you compare today’s performance with yesterday’s. The calculation looks at invoice amounts for the day before the current date, using your calendar table to identify the correct date. Results are displayed in the same units as your invoice amounts, filtered to only include data from one day prior to today.
Daily Sales Day-over-Day ∆	Tgl. Umsatz-1 ∆	#,##0	Shows the difference in daily sales between yesterday and the day before yesterday. This helps track short-term sales trends by comparing recent daily performance. A positive value indicates sales increased compared to two days ago, while a negative value shows a decrease.
Daily Sales Change %	Tgl. Umsatz-1 ∆%	#,##0.0 %	Shows the percentage change in sales from the day before yesterday to yesterday, helping track short-term sales trends. The value is calculated by comparing sales from yesterday to those from two days ago, expressing the difference as a percentage. This metric is useful for quickly spotting shifts in daily sales performance.
Sales 2 Days Ago	Vorgestrige Verkäufe	#,##0	Calculates the total invoice sales amount from two days ago, using the most recent date in the calendar as the reference point for “today.” This KPI helps track daily sales trends by showing performance specifically for the day before yesterday. The value is filtered to only include sales that occurred exactly two days prior to the current reporting date.

Discounts

Measure (EN)	Measure (DE)	Format	Description
Invoice Discount	Rechnungsrabatt	#,##0	Invoice Discount represents the total discount amount applied to an invoice, combining both line-level and overall invoice discounts. It helps businesses understand the full value of discounts given to customers on each invoice, whether the discount was applied to individual items or to the invoice as a whole. The calculation adds up all discounts from both sources to show the complete discount impact per invoice.
Invoice Discount %	Rechnungsrabatt %	#,##0.0 %	Shows the percentage of discounts given on invoices by comparing the total discount amount to the total invoiced amount. This helps assess how much value is being reduced through discounts and can be used to monitor pricing strategies or customer incentives. The result is expressed as a percentage of the invoice value.
Order Discount	Auftragsrabatt	#,##0	Order Discount calculates the total discount given on an order by combining discounts applied both at the individual product level and at the overall order level. It helps businesses understand the total amount of discount provided per order, regardless of where the discount was applied. The value reflects the sum of line item discounts and any additional end-of-order discounts.
Order Discount %	Auftragsrabatt (%)	#,##0.0 %	Shows the percentage of total discounts given on orders compared to the overall order value. Useful for tracking how much of sales revenue is being reduced due to discounts, helping to monitor pricing strategies and profitability. The result is expressed as a percentage of the total order amount.

Explicit KPI

Measure (EN)	Measure (DE)	Format	Description
Profit Margin % Prior Year	Deckungsbeitrag % PY	#,##0.0 %	Shows the percentage of profit earned in the previous year, allowing you to compare current performance to last year’s results. Useful for tracking year-over-year changes in profitability. The value is filtered to only include data from the prior year for accurate comparison.
Profit Margin % YoY	Deckungsbeitrag % YoY	#,##0.0" %p"	Shows the year-over-year percentage change in profit margin, helping you track how profitability has improved or declined compared to the same period last year. The value is displayed as a percentage rounded to one decimal place and focuses only on year-over-year performance. This measure is useful for identifying trends and evaluating the effectiveness of business strategies over time.
Profit Margin Previous Year	Deckungsbeitrag PY	#,##0	Shows the profit margin achieved during the previous year, allowing you to compare current profitability to last year’s performance. The calculation filters data to only include results from the prior year, providing valuable context for year-over-year analysis. Expressed as a percentage, it helps track trends and set future profit goals.
Profit Margin YoY	Deckungsbeitrag YoY	#,##0	Shows the year-over-year change in profit margin, comparing the current period's profitability to the same period last year. Useful for tracking how efficiently the company is generating profit over time, this metric applies a filter to focus specifically on annual comparisons. Results are expressed as a percentage, helping evaluate trends in profitability.
Profit Margin YoY %	Deckungsbeitrag YoY %	#,##0 %	Shows the year-over-year percentage change in profit margin, helping you track how profitability has improved or declined compared to the same period last year. The calculation expresses the change as a percent, making it easy to spot trends in profit performance over time. Useful for monitoring business growth and identifying areas needing attention.
Sales Amount PY	Verkaufsbetrag PY	#,##0	Represents the total sales amount from the previous year, allowing for year-over-year comparisons. Useful for tracking sales performance trends by comparing current results with those from the same period last year. The calculation only includes data labeled as "Previous Year" in the time intelligence table.
Sales Amount YoY	Verkaufsbetrag YoY	#,##0	Shows the total sales amount compared to the same period in the previous year, helping to track year-over-year growth or decline. Useful for identifying sales trends and seasonality. The calculation specifically focuses on yearly changes by filtering the data to only include year-over-year results.
Sales Amount YoY %	Verkaufsbetrag YoY %	#,##0 %	Shows the percentage change in sales amount compared to the same period last year. Useful for tracking sales growth or decline year over year, helping businesses identify trends and seasonality. The value is expressed as a percentage and uses a filter to focus on the year-over-year comparison.
Sales Qty PY	Verkaufsmenge PY	#,##0	Shows the total number of items sold during the same period in the previous year. This is useful for comparing current sales performance against last year's results, helping to identify growth or decline trends. The calculation uses a filter to ensure it only includes data from the prior year, matching the time frame being analyzed.
Sales Qty YoY	Verkaufsmenge YoY	#,##0	Shows the total number of units sold compared to the same period in the previous year. Useful for analyzing year-over-year growth or decline in sales volume, helping to spot seasonal trends or long-term changes. The calculation only includes sales categorized as "Year over Year" based on the selected time filter.
Sales Qty YoY %	Verkaufsmenge YoY %	#,##0 %	Shows the percentage change in the number of units sold compared to the same period last year. This KPI helps track growth or decline in sales volume over time, making it useful for identifying trends and evaluating business performance. The calculation compares total sales quantity year-over-year, providing insight into how sales are evolving annually.

InTime InFull (ITIF)

Measure (EN)	Measure (DE)	Format	Description
# Orders In-Time In-Full	# Aufträge Pünktlich & Komplett	#,##0	Counts the number of orders that were fully delivered on time and had no late shipments. This KPI helps track the volume of orders meeting both completeness and timeliness standards, making it useful for monitoring supply chain reliability and delivery performance. Only orders that are both complete and have zero late shipments are included in the calculation.
# Orders In-Full	# Aufträge Komplett	#,##0	Counts the number of orders that are either within due time fully delivered or not overdue as of the latest business date. This KPI helps monitor order fulfillment performance by identifying orders that are on track or completed, excluding those with overdue and outstanding quantities. The calculation considers only orders where the due date has not passed or, if it has, there are no remaining quantities to deliver.
Overdue Orders	Überfällige Aufträge	#,##0	Counts the number of sales orders that are overdue and still have outstanding quantities. It identifies orders where the due date has passed compared to today, and items have not yet been fully delivered. This KPI helps monitor delayed customer orders and highlights areas needing follow-up or action.
ITIF %	ITIF %	#,##0.0 %	Represents the percentage of orders which are In-Time In-Full delivered.
Late Shipment Order %	Verspätete Aufträge %	#,##0.0 %	Shows the percentage of orders that have at least one shipment line delivered late. Useful for monitoring delivery performance and identifying potential issues in the order fulfillment process. The result is calculated as the number of orders with late shipments divided by the total number of orders, expressed as a percentage.
Late Shipment Rate % (Sales Line)	Verspätungsrate % (Auftr. Pos)	#,##0.0 %	Shows the percentage of order lines that were shipped late compared to the total number of order lines. Useful for tracking delivery performance and identifying areas for improvement in order fulfillment. The calculation is based on all order lines and is expressed as a percentage.
Outstanding Order Amount	Offener Auftragsbetrag	#,##0	Represents the total value of all unpaid order amounts for a specific type of sales document, regardless of any filters applied to document types elsewhere in the report. Useful for tracking outstanding revenue tied to orders of a particular category, helping assess cash flow or collections performance. The calculation sums only those orders matching the selected sales document type, measured in currency units.
Outstanding Order Qty	Offene Auftragsmenge	#,##0	Shows the total number of units from sales orders that are yet to be delivered. This value is calculated regardless of the sales document type filter, but only for the specific document type selected by the user. Useful for tracking outstanding commitments and understanding future delivery requirements.

Item Classification

Measure (EN)	Measure (DE)	Format	Description
ABC Class	ABC-Klasse		This KPI classifies each product into categories A, B, or C based on its cumulative contribution to total sales within the current filter context. Items are ranked by sales value: "A" items are the top contributors (up to 70% of sales), "B" items contribute the next 20%, and "C" items make up the remaining 10%. This helps prioritize inventory or sales focus by highlighting which products drive the most revenue.
ABC Class Order Amount	ABC-Klasse Auftragswert		Represents the total order amount for items within a specific ABC classification group (A, B, or C), based on their contribution to overall sales. Useful for inventory and sales analysis, it helps identify which products fall into each ABC category according to predefined percentage thresholds. The calculation includes only the selected items and dynamically assigns them to ABC classes based on their cumulative share of total sales within the current filter context.
Top N Rank	Top N Items		Shows the ranking position of each item or item group based on their sales amount, with 1 being the highest sales. Useful for identifying the top-performing products or product groups within a report. The calculation dynamically adjusts to rank individual items or item groups, depending on the level you are viewing in the report.

KPIs

Measure (EN)	Measure (DE)	Format	Description
Quote to Order CR	Angebot-Auftrags Rate	#,##0.0 %	Shows the percentage of quoted value that is successfully converted into actual orders. This KPI helps track how effectively quotes are turning into sales, indicating sales team performance and customer commitment. It is calculated by dividing the total order value by the total quoted value for a given period.

Shopping Basket Analysis

Measure (EN)	Measure (DE)	Format	Description
Order Count	# Aufträge	#,0
# Orders (SBA)	# Aufträge (SBA)	#,0
# Orders with Both Items	# Aufträge mit beiden Artikeln
# Orders Both	# Aufträge Beide	#,0
# Orders Total	# Aufträge Gesamt	#,0
Orders Confidence %	Bestellvertrauen %	0\ %;-0\ %;0\ %
Orders Support %	Bestellunterstützung %	0\ %;-0\ %;0\ %
Orders Lift	Orders Lift	0\ %;-0\ %;0\ %

Shopping Basket Analysis v2

Measure (EN)	Measure (DE)	Format	Description
# Orders A	# Aufträge (A)		Number of Orders containing Item A
# Orders B	# Aufträge (B)		Number of Orders containing Item B
# Orders Both	# Aufträge (A & B)		Number of Orders containing both, Item A & Item B
# Orders Total	# Aufträge (gesamt)		Total Number of Orders
% Confidence Item A	Konfidenz Artikel A %	0.00\ %;-0.00\ %;0.00\ %	Likelihood of buying Item B when Item A is already in the basket.
% Confidence Item B	Konfidenz Artikel B %	0.00\ %;-0.00\ %;0.00\ %	Likelihood of buying Item A when Item B is already in the basket.
% Orders Support	Unterstützung Warenkorb %	0.00\ %;-0.00\ %;0.00\ %	Share of Orders containing Item A & B related to Total Number of Orders
% Support A	Unterstützung Artikel A %		Share of Orders containing Item A related to Total Number of Orders
% Support B	Unterstützung Artikel A %		Share of Orders containing Item B related to Total Number of Orders
Orders Uplift	Auftrags Uplift		Gives the strength of the relationship between two products in a basket. Indicates how much more likely the other Item is to be bought when the first Item is already in the basket. e.g. Lift of 1.5 means that the Items A & B are bought together about 1.5 times more than if would happen by chance.

General

Measure (EN)	Measure (DE)	Format	Description
Avg Sales Price Development Label	Avg Sales Price Development Label
Back Label	Back Label
by Customer Page Label	by Customer Page Label
by Employee Page Label	by Employee Page Label
by Item Page Label	by Item Page Label
Churn Early Warning Label	Churn Early Warning Label
Client Label	Client Label
Cohort Analysis Label	Cohort Analysis Label
Customer Cluster FrequencyMonetary Label	Customer Cluster FrequencyMonetary Label
Customer Documents Label	Customer Documents Label
Customer Loyalty Label	Customer Loyalty Label
Customer Order History Label	Customer Order History Label
Customers Next Order Overdue Label	Customers Next Order Overdue Label
DailySales Label	DailySales Label
DeliveryReliability Report Label	DeliveryReliability Report Label
Details per Order Label	Details per Order Label
Document Type Label	Document Type Label
Employee Label	Employee Label
ExecSummary Label	ExecSummary Label
Flop 10 Customers Label	Flop 10 Customers Label
Flop 10 Items Label	Flop 10 Items Label
FrequencyMonetary Label	FrequencyMonetary Label
In-Time In-Full Trend Label	In-Time In-Full Trend Label
Invoice Customer Label	Invoice Customer Label
Invoice Label	Invoice Label
Item Category Label	Item Category Label
Item Label	Item Label
Item(category) A Label	Item(category) A Label
Item(category) B Label	Item(category) B Label
ItemPage Label	ItemPage Label
ITIF by DueDate Label	ITIF by DueDate Label
Last Refresh Label	Last Refresh Label
Map Label	Map Label
MonthlySales Label	MonthlySales Label
MTD Label	MTD Label
New and Lost Customer Label	New and Lost Customer Label
Number of Orders by Dealsize Label	Number of Orders by Dealsize Label
Order Customer Label	Order Customer Label
Overdue OrderLines Label	Overdue OrderLines Label
Overdue Orders Label	Overdue Orders Label
OverdueOrders Report Label	OverdueOrders Report Label
OverviewPage Label	OverviewPage Label
Period Label	Period Label
Profit and Sales by Employee Label	Profit and Sales by Employee Label
Profit by Item Label	Profit by Item Label
QAPage Label	QAPage Label
Quotes by Customer	Quotes by Customer
Quotes by Items	Quotes by Items
Report Label	Report Label
Report Label eCommerce	Report Label eCommerce
Report Label KYC	Report Label KYC
Report Label Retail	Report Label Retail
Revenue & Profit by Item Label	Revenue & Profit by Item Label
Revenue by Employee Label	Revenue by Employee Label
Revenue Profit Bridge Label	Revenue Profit Bridge Label
Sales Amount and development by Location Label	Sales Amount and development by Location Label
Sales Amount by Document Type Label	Sales Amount by Document Type Label
Sales Amount vs PY by Item Category Label	Sales Amount vs PY by Item Category Label
Sales Amount vs PY Label	Sales Amount vs PY Label
Sales and Profit by Primary Vendor Label	Sales and Profit by Primary Vendor Label
Sales and Profit development by Employee Label	Sales and Profit development by Employee Label
Sales Funnel Label	Sales Funnel Label
Sales Invoices Label	Sales Invoices Label
Sales Orders Label	Sales Orders Label
Sales Price development Label	Sales Price development Label
Sales Shipments Label	Sales Shipments Label
Sales trend Label	Sales trend Label
Sales trend vs. Plan	Sales trend vs. Plan
Sales trend vs. PY	Sales trend vs. PY
Share of Profit Label	Share of Profit Label
ShoppingBasketAnalysis Details Label	ShoppingBasketAnalysis Details Label
ShoppingBasketAnalysis ItemNetwork Lift Label	ShoppingBasketAnalysis ItemNetwork Lift Label
ShoppingBasketAnalysis Label	ShoppingBasketAnalysis Label
ShoppingBasketAnalysis Network Label	ShoppingBasketAnalysis Network Label
ShoppingBasketAnalysis Order Support & Lift Map Label	ShoppingBasketAnalysis Order Support & Lift Map Label
Statistic by Customer Label	Statistic by Customer Label
Statistic by Employee Label	Statistic by Employee Label
Statistic by Item Label	Statistic by Item Label
Statistic by ItemCategory Label	Statistic by ItemCategory Label
Statistic by Weekday Label	Statistic by Weekday Label
Statistics byItem Label	Statistics byItem Label
Summary Page Label	Summary Page Label
Today Label	Today Label
Top 10 Customers Label	Top 10 Customers Label
Top 10 Items Label	Top 10 Items Label
Top 5 Customers Label	Top 5 Customers Label
Top 5 Items Label	Top 5 Items Label
Top/Flop Report Label	Top/Flop Report Label
Unit Label	Unit Label
YTD Label	YTD Label

Tech

Measure (EN)	Measure (DE)	Format	Description
App Version	App Version
Current User	aktueller User
DaysInFilter	Tage gefiltert
DynMeasure	DynMeasure
EffectiveDate	Datum (effective)
Last Refresh	Letztes Update
Last Refresh Card	Last Refresh Card
Max Order Frequency (Days)	Max Order Frequency (Days)
Max Ø Order Amount by Customer	Max Ø Order Amount by Customer
MeasureDumpFilter	MeasureDumpFilter
SalesRowCount	# Verkaufspositionen
Today Card	Today Card

Tech\Demo

Measure (EN)	Measure (DE)	Format	Description
Service Revenue	Service Revenue	#,##0
Share Return Orders	Share Return Orders	#,0.0\ %;-#,0.0\ %;#,0.0\ %
Webshop Revenue	Webshop Revenue	#,##0

Tech\Demo\TimeIntelligence\PY

Measure (EN)	Measure (DE)	Format	Description
Service Revenue PY	Service Revenue PY	#,##0
Share Return Orders PY	Share Return Orders PY	#,0.0\ %;-#,0.0\ %;#,0.0\ %
Webshop Revenue PY	Webshop Revenue PY	#,##0

Tech\Demo\TimeIntelligence\YoY

Measure (EN)	Measure (DE)	Format	Description
Service Revenue YoY	Service Revenue YoY	#,##0
Share Return Orders YoY	Share Return Orders YoY	#,##0.0
Webshop Revenue YoY	Webshop Revenue YoY	#,##0

Tech\Demo\TimeIntelligence\YoY %

Measure (EN)	Measure (DE)	Format	Description
Service Revenue YoY %	Service Revenue YoY %	#,##0 %
Share Return Orders YoY %	Share Return Orders YoY %	#,##0 %
Webshop Revenue YoY %	Webshop Revenue YoY %	#,##0 %

Tech\Formatting

Measure (EN)	Measure (DE)	Format	Description
# New Customers YoY CF	# New Customers YoY CF
# New Customers YoY Icon	# New Customers YoY Icon
# Unique Order Customers YoY CF	# Unique Order Customers YoY CF
# Unique Order Customers YoY Icon	# Unique Order Customers YoY Icon
ConstLine Mid Ø Order Amount	ConstLine Mid Ø Order Amount
ConstLine Mid Ø Order Frequency	ConstLine Mid Ø Order Frequency
CrMemo Amount YoY CF	CrMemo Amount YoY CF
CrMemo Amount YoY Icon	CrMemo Amount YoY Icon
Daily Orders Moving Ø 7D ∆ CF	Daily Orders Moving Ø 7D ∆ CF
Daily Orders Moving Ø 7D ∆ Icon	Daily Orders Moving Ø 7D ∆ Icon
Daily Orders Today ∆ CF	Daily Orders Today ∆ CF
Daily Orders Today ∆ Icon	Daily Orders Today ∆ Icon
Daily Sales Moving Ø 7D ∆ CF	Daily Sales Moving Ø 7D ∆ CF
Daily Sales Moving Ø 7D ∆ Icon	Daily Sales Moving Ø 7D ∆ Icon
Daily Sales Today ∆ CF	Daily Sales Today ∆ CF
Daily Sales Today ∆ Icon	Daily Sales Today ∆ Icon
Invoice Amount YoY CF	Invoice Amount YoY CF
Invoice Amount YoY Icon	Invoice Amount YoY Icon
Invoice Profit Margin YoY CF	Invoice Profit Margin YoY CF
Invoice Profit Margin YoY Icon	Invoice Profit Margin YoY Icon
Order Amount Open YoY CF	Order Amount Open YoY CF
Order Amount Open YoY Icon	Order Amount Open YoY Icon
OTD Rate YoY CF	OTD Rate YoY CF
OTD Rate YoY Icon	OTD Rate YoY Icon
Profit Margin YoY CF	Profit Margin YoY CF
Profit Margin YoY Icon	Profit Margin YoY Icon
Sales Amount YoY CF	Sales Amount YoY CF
Sales Amount YoY Icon	Sales Amount YoY Icon
Sales Quantity YoY CF	Sales Quantity YoY CF
Sales Quantity YoY Icon	Sales Quantity YoY Icon
Service Revenue YoY CF	Service Revenue YoY CF
Service Revenue YoY Icon	Service Revenue YoY Icon
Share Return Orders YoY CF	Share Return Orders YoY CF
Share Return Orders YoY Icon	Share Return Orders YoY Icon
Webshop Revenue YoY CF	Webshop Revenue YoY CF
Webshop Revenue YoY Icon	Webshop Revenue YoY Icon
Ø Order Amount YoY CF	Ø Order Amount YoY CF
Ø Order Amount YoY Icon	Ø Order Amount YoY Icon

Tech\Formatting\IBCS

Measure (EN)	Measure (DE)	Format	Description
Order Amount Delta	Order Amount Delta	#,##0	Order Amount excl. Discounts (Status Open)
Order Amount Delta %	Order Amount Delta %	#,##0 %	Order Amount excl. Discounts (Status Open)
Order Amount DeltaColor	Order Amount DeltaColor
Order Amount GreenMax	Order Amount GreenMax	#,##0
Order Amount MaxValue	Order Amount MaxValue	#,##0
Order Amount RedMax	Order Amount RedMax	#,##0

Tech\Formatting\IBCS\Budget

Measure (EN)	Measure (DE)	Format	Description
Invoice Amount Delta Bud	Invoice Amount Delta Bud	#,##0	Order Amount excl. Discounts (Status Open)
Invoice Amount Delta Bud %	Invoice Amount Delta Bud %	#,##0 %	Order Amount excl. Discounts (Status Open)
Invoice Amount DeltaColor Bud	Invoice Amount DeltaColor Bud
Invoice Amount GreenMax Bud	Invoice Amount GreenMax Bud	#,##0
Invoice Amount MaxValue Bud	Invoice Amount MaxValue Bud	#,##0
Invoice Amount RedMax Bud	Invoice Amount RedMax Bud	#,##0

Tech\Formatting\IBCS\PY

Measure (EN)	Measure (DE)	Format	Description
Invoice Amount Delta	Invoice Amount Delta	#,##0	Order Amount excl. Discounts (Status Open)
Invoice Amount Delta %	Invoice Amount Delta %	#,##0 %	Order Amount excl. Discounts (Status Open)
Invoice Amount DeltaColor	Invoice Amount DeltaColor
Invoice Amount GreenMax	Invoice Amount GreenMax	#,##0
Invoice Amount MaxValue	Invoice Amount MaxValue	#,##0
Invoice Amount RedMax	Invoice Amount RedMax	#,##0