Understand figures of Anomaly List of Studio

Product
#1

Dear all,

I would like to share how to understand columns of Anomaly List in Studio components.

As prerequisite, I created Record/KPI/Anomaly in Knowledge Model.

records:
  - id: salesOrderRecord
    displayName: Sales Order Record
    customAttributes:
      flags:
        - id: smallAmountOrder
          displayName: Small Amount Order
          pql: ABS(VBAK.NETWR) < 1 AND VBAK.NETWR <> 0
          rootCauseFeatures:
            - id: salesOrganization
kpis:
  - id: netValue 
    displayName: netValue
    description: ""
    pql: SUM(VBAK.NETWR)
    unit: ""
    format: ""
    desiredDirection: INCREASE # mandatory for anomaly list
    type: KPI
anomalies:
  - id: smallAmountOrderAnomaly
    displayName: Anomary Small Amount Order
    flag: smallAmountOrder # in flags
    kpiIds:
      - netValue # in kpis
    knowledgeObjectId: smallAmountOrderAnomaly
    type: ANOMALY

Then I setup anomaly list in my view and get below picture.

components:
- id: "anomalyList"
  type: "anomaly-list"
  settings:
    kpi: "netValue"
    name: "Anomalies"

image

How to calculate each value in list ?

Occurrence (2) : count of record (salesOrderRecord) filtered by pql of flag (smallAmountOrder).

netValue (0.51) : calculation value of KPI (netValue) filtered by pql of flag (smallAmountOrder).

Impact (-100%) : first calculate KPI (netValue) without filter, in my case it is 65M. second calculate (netValue with filter - netValue w/o filter), in my case it is (0.51 - 65M) almost equal to -65M. third divide previous value by netValue w/o filter, means -65M/65M = -1.0(=-100%)

Shortly, impact value means how worsen KPI by anomaly condition.

Best regards,
Kazuhiko

1 Like