Lineage — 68

model: axoquant, status: ready

Request

build a dashboard of notifications by month

Dataset snapshot

period_label: 2018-Q1..2025-H2 workbook + PDF transcripts
normaliser_ver: 2026-08-29-ndb-migration
canonical_hash: b58e6eca4d69a55306ff4f301c21ee2eb213b41401467aec4123f3ea5467cc4b
fact_count: 363
source files:
- (derived)
- data/sources/*.xlsx

Tool-call transcript

1 · query_dataset · monthly

in:  {
  "op": "monthly"
}
out: {
  "basis": "month",
  "months": [
    "2025-07",
    "2025-08",
    "2025-09",
    "2025-10",
    "2025-11",
    "2025-12"
  ],
  "values": [
    117,
    99,
    116,
    122,
    99,
    117
  ]
}

2 · query_dataset · kpis

in:  {
  "op": "kpis"
}
out: {
  "notifications_prev": {
    "basis": "period",
    "value": 595.0
  },
  "notifications_latest": {
    "basis": "period",
    "value": 670.0
  },
  "malicious_share_latest": {
    "basis": "period",
    "value": 60.4
  },
  "large_scale_australians": {
    "basis": "period",
    "value": 3.0
  },
  "human_error_share_latest": {
    "basis": "period",
    "value": 29.0
  },
  "individuals_lte100_share": {
    "basis": "period",
    "value": 61.3
  },
  "notifications_change_pct": {
    "basis": "period",
    "value": 12.6
  },
  "system_fault_share_latest": {
    "basis": "period",
    "value": 5.2
  },
  "cyber_incident_share_latest": {
    "basis": "period",
    "value": 37.8
  }
}

Computed figures

figure · notifications_latest rows: 2 · hash: e156935283221fcea90b9b2d94833b90286e0ea11a561b9bbba7aea44b53c70d

670.0

figure · notifications_prev rows: 2 · hash: e156935283221fcea90b9b2d94833b90286e0ea11a561b9bbba7aea44b53c70d

595.0

figure · notifications_change_pct rows: 2 · hash: e156935283221fcea90b9b2d94833b90286e0ea11a561b9bbba7aea44b53c70d

12.6

figure · notifications_monthly rows: 35 · hash: 8ad766267ac033eaf929668f1111b7bf22598d5243edc668223191b8fb29ee9a

{
  "basis": "month",
  "notes": [
    "Month totals and source rows are the published workbook figures.",
    "Across the six months the source rows sum to 673 against the published grand total of 670; the dashboard shows the published rows and discloses this source quirk."
  ],
  "series": [
    {
      "name": "total",
      "values": [
        117,
        99,
        116,
        122,
        99,
        117
      ]
    },
    {
      "name": "Malicious or criminal attack",
      "values": [
        68,
        62,
        63,
        77,
        63,
        72
      ]
    },
    {
      "name": "Human error",
      "values": [
        35,
        28,
        39,
        31,
        29,
        32
      ]
    },
    {
      "name": "System fault",
      "values": [
        3,
        5,
        10,
        5,
        4,
        8
      ]
    },
    {
      "name": "Other",
      "values": [
        7,
        3,
        1,
        6,
        2,
        5
      ]
    },
    {
      "name": "Currently unknown",
      "values": [
        4,
        1,
        3,
        3,
        1,
        0
      ]
    }
  ],
  "categories": [
    "2025-07",
    "2025-08",
    "2025-09",
    "2025-10",
    "2025-11",
    "2025-12"
  ]
}

figure · notifications_trend rows: 20 · hash: f4067dd476d9f5f0eff631a0137fc6241449e3b92d2ed5c731c60330f652ac33

{
  "basis": "period",
  "notes": [
    "2018-H1 and 2019-H1 are platform sums of the two published quarterly reports.",
    "No report was published for January to June 2025: the dashboard replaced the PDF cycle before it was released."
  ],
  "series": [
    {
      "name": "total",
      "values": [
        305.0,
        507.0,
        460.0,
        532.0,
        512.0,
        530.0,
        436.0,
        460.0,
        393.0,
        486.0,
        407.0,
        485.0,
        518.0,
        595.0,
        null,
        670.0
      ]
    }
  ],
  "categories": [
    "2018-H1",
    "2018-H2",
    "2019-H1",
    "2019-H2",
    "2020-H1",
    "2020-H2",
    "2021-H1",
    "2021-H2",
    "2022-H1",
    "2022-H2",
    "2023-H1",
    "2023-H2",
    "2024-H1",
    "2024-H2",
    "2025-H1",
    "2025-H2"
  ],
  "gap_categories": [
    "2025-H1"
  ],
  "derived_categories": [
    "2018-H1",
    "2019-H1"
  ]
}

← back to dashboard