Skip to content
Deem Docs

KPI Examples

Overview

Section titled “Overview”

This section provides practical examples of KPI configurations. Each example includes the complete script and a description of what it does.

Example 1: Basic Result KPI

Section titled “Example 1: Basic Result KPI”

KPI example 1

$olap.addKpi("1", "Result", "[time_period]", "",
  "(SUM([budget_amount_dcur]) * -1) + 1000",
  "(SUM([accounted_amount_dcur]) * -1)",
  "0.8", "1.0", "1", "");
$olap.setKpiFormat('1', '###,###');
$olap.setKpiTargetRealName("1", "Budget", "Real");
$olap.setKpiSize("1", "XS12", "SM3", "MD3", "LG3");

Description:

  • Compares budget vs actual result
  • Uses custom labels “Budget” and “Real”
  • Yellow threshold at 80%, green at 100%
  • Shows icon and trend line
  • Responsive sizing: full width on mobile, 3/12 on larger screens

Example 2: Profit Percentage KPI

Section titled “Example 2: Profit Percentage KPI”

KPI example 2

$olap.addKpi("2", "Profit %", "[time_period]", "",
  "(SUM([budget_amount_dcur]) * -1) / (SUM(CASE WHEN [dim_1] BETWEEN '3000' AND '3999' THEN [budget_amount_dcur] ELSE 0 END) * -1)",
  "(SUM([accounted_amount_dcur]) * -1) / (SUM(CASE WHEN [dim_1] BETWEEN '3000' AND '3999' THEN [accounted_amount_dcur] ELSE 0 END) * -1)",
  "0.8", "1.0", "1", "");
$olap.setKpiFormat('2', '##0.00 %');
$olap.setKpiTargetRealName("2", "Budget", "Real");
$olap.setKpiSize("2", "XS12", "SM2", "MD2", "LG2");

Description:

  • Calculates profit as percentage of turnover
  • Uses percentage format with 2 decimals
  • Filters accounts between 3000-3999 for turnover calculation
  • Smaller size (2/12) for side-by-side display

Example 3: COGS as Percentage of Turnover

Section titled “Example 3: COGS as Percentage of Turnover”

KPI example 3

$olap.addKpi("3", "COGS as % of turnover", "[time_period]", "",
  "(SUM(CASE WHEN [dim_1] BETWEEN 4000 AND 4999 THEN [budget_amount_dcur] ELSE 0 END)) / (SUM(CASE WHEN [dim_1] BETWEEN 3000 AND 3999 THEN [budget_amount_dcur] ELSE 0 END) * -1)",
  "(SUM(CASE WHEN [dim_1] BETWEEN 4000 AND 4999 THEN [accounted_amount_dcur] ELSE 0 END)) / (SUM(CASE WHEN [dim_1] BETWEEN 3000 AND 3999 THEN [accounted_amount_dcur] ELSE 0 END) * -1)",
  "1.2", "1.0", "1", "");
$olap.setKpiFormat('3', '##0.00 %');
$olap.setKpiTargetRealName("3", "Budget", "Real");
$olap.setKpiSize("3", "XS12", "SM2", "MD2", "LG2");
$olap.setKpiIcons("3", "align_justify", "align_justify", "align_justify");

Description:

  • Calculates Cost of Goods Sold as percentage of turnover
  • Uses account ranges: 4000-4999 for COGS, 3000-3999 for turnover
  • Inverted thresholds (1.2 yellow, 1.0 green) - lower is better
  • Custom icon for all statuses

Example 4: Wages as Percentage of Turnover

Section titled “Example 4: Wages as Percentage of Turnover”

KPI example 4

$olap.addKpi("4", "Wages as % of turnover", "[time_period]", "",
  "(SUM(CASE WHEN [dim_1] BETWEEN 5000 AND 5999 THEN [budget_amount_dcur] ELSE 0 END)) / (SUM(CASE WHEN [dim_1] BETWEEN 3000 AND 3999 THEN [budget_amount_dcur] ELSE 0 END) * -1)",
  "(SUM(CASE WHEN [dim_1] BETWEEN 5000 AND 5999 THEN [accounted_amount_dcur] ELSE 0 END)) / (SUM(CASE WHEN [dim_1] BETWEEN 3000 AND 3999 THEN [accounted_amount_dcur] ELSE 0 END) * -1)",
  "1.2", "1.0", "1", "");
$olap.setKpiFormat('4', '##0.00 %');
$olap.setKpiTargetRealName("4", "Budget", "Real");
$olap.setKpiSize("4", "XS12", "SM2", "MD2", "LG2");
$olap.setKpiIcons("4", "users", "users", "users");

Description:

  • Calculates wages as percentage of turnover
  • Uses account range 5000-5999 for wages
  • Custom “users” icon for all statuses
  • Inverted thresholds for cost ratio

Example 5: Operating Expenses as Percentage of Turnover

Section titled “Example 5: Operating Expenses as Percentage of Turnover”

KPI example 5

$olap.addKpi("5", "Operating expenses as % of turnover", "[time_period]", "",
  "ROUND((SUM(CASE WHEN [dim_1] BETWEEN 6000 AND 7999 THEN [budget_amount_dcur] ELSE 0 END)) / (SUM(CASE WHEN [dim_1] BETWEEN 3000 AND 3999 THEN [budget_amount_dcur] ELSE 0 END) * -1), 3)",
  "ROUND((SUM(CASE WHEN [dim_1] BETWEEN 6000 AND 7999 THEN [accounted_amount_dcur] ELSE 0 END)) / (SUM(CASE WHEN [dim_1] BETWEEN 3000 AND 3999 THEN [accounted_amount_dcur] ELSE 0 END) * -1), 3)",
  "1.2", "1.0", "1", "");
$olap.setKpiFormat('5', '##0.00 %');
$olap.setKpiTargetRealName("5", "Budget", "Real");
$olap.setKpiSize("5", "XS12", "SM3", "MD3", "LG3");

Description:

  • Calculates operating expenses as percentage of turnover
  • Uses account range 6000-7999 for operating expenses
  • Uses ROUND function to 3 decimals for precision
  • Medium size (3/12) for better visibility

Example 6: Female Employees Percentage

Section titled “Example 6: Female Employees Percentage”

KPI example 6

$olap.addKpi("3", "Female employees", "[time_period]", "",
  "0",
  "(SUM(CASE WHEN [sex] = 'Female' THEN [degree_of_occupation] ELSE 0.000001 END) * 100) / SUM(CASE WHEN [degree_of_occupation] > 0 THEN [degree_of_occupation] ELSE 0.0001 END)",
  "1.2", "1.0", "0", "");
$olap.setKpiFormat('3', '##0.00 %');
$olap.setKpiSize("3", "XS12", "SM2", "MD2", "LG2");
$olap.setKpiIcons("3", "female", "female", "female");
$olap.hideKpiTargetInfo("3");

Description:

  • Calculates percentage of female employees
  • No target value (set to 0)
  • Hides target info (only shows actual value)
  • Uses “female” icon for all statuses
  • Calculates percentage from degree of occupation
  • Icon only mode (no trend line)
Section titled “Related”