Analytics
Analytics liefert konsolidierte Kennzahlen aus dem Live-System. Aggregations-Werte werden im Hintergrund vorberechnet; CRUD-Endpoints existieren primär für Konfiguration (Widgets, Dimensionen, Custom- Berechnungen).
Resources – Modell & Daten
| Resource | Pfad | Permission-Präfix |
|---|---|---|
| Datasources | /api/v1/analytics_datasources | analytics_datasource |
| Datenmodelle | /api/v1/analytics_data_models | analytics_data_model |
| Beziehungen | /api/v1/analytics_relationships | analytics_relationship |
| Metric-Definitionen | /api/v1/analytics_metric_definitions | analytics_metric_definition |
| Calculated Measures | /api/v1/analytics_calculated_measures | analytics_calculated_measure |
| Queries | /api/v1/analytics_queries | analytics_query |
| Snapshots | /api/v1/analytics_snapshots | analytics_snapshot |
| Retention-Policies | /api/v1/analytics_retention_policies | analytics_retention_policy |
Resources – Dashboards & Widgets
| Resource | Pfad | Permission-Präfix |
|---|---|---|
| Dashboards | /api/v1/analytics_dashboards | analytics_dashboard |
| Widgets | /api/v1/analytics_widgets | analytics_widget |
| Annotationen | /api/v1/analytics_annotations | analytics_annotation |
| Kommentare | /api/v1/analytics_comments | analytics_comment |
| Share-Links | /api/v1/analytics_share_links | analytics_share_link |
Resources – Reports & Alerts
| Resource | Pfad | Permission-Präfix |
|---|---|---|
| Report-Templates | /api/v1/analytics_report_templates | analytics_report_template |
| Report-Schedules | /api/v1/analytics_report_schedules | analytics_report_schedule |
| Report-Runs | /api/v1/analytics_report_runs | analytics_report_run |
| Alert-Rules | /api/v1/analytics_alert_rules | analytics_alert_rule |
Resources – Domänenspezifische Aggregate
| Resource | Pfad | Quelle |
|---|---|---|
| Benchmark-Beiträge | /api/v1/analytics_benchmark_contributions | Branchen-Benchmarks |
| License-Reconciliations | /api/v1/analytics_license_reconciliations | Software-Lizenz-Audit |
| Remediation-Logs | /api/v1/analytics_remediation_logs | Compliance |
| Service-Time-Profiles | /api/v1/analytics_service_time_profiles | SLA-Profile |
| Simulationen | /api/v1/analytics_simulations | Szenario-Analysen |
Permissions folgen dem Schema <resource>_view / _create / _update /
_delete.
Schemas — Konfiguration
Datasource
name
description
type
postgresqlmysqlmssqlrest_apicsvexcelgoogle_sheets connectionConfig
Connection parameters (host, port, database, URL, ...). Secret-named fields (password, apiKey, token, bearerToken, accessToken, refreshToken, privateKey, clientSecret, secret) are transparently encrypted at rest using AES-256-GCM via ANALYTICS_DATASOURCE_KEY. API responses mask these fields as "***".
syncInterval
manualhourlydailyweekly syncCron
Optional 5-field cron expression overriding syncInterval. Evaluated in UTC. When set, the scheduler uses this instead of the interval preset.
lastSyncAt
lastSyncStatus
successerrorrunning lastSyncError
lastSyncDurationMs
nextSyncAt
schemaMapping
transformRules
isActive
cachedRowCount
uploadMetadata
CSV/Excel-only: metadata about the latest uploaded file (Phase B). Filled by the upload-complete handler and consumed by the ingest job.
Keine Felder passen zum Filter.
Data-Model
name
description
isActive
tags
Keine Felder passen zum Filter.
Metric
name
key
description
category
service_desktechnicianfinancecrmsalestelephonyprojectshrassetscompliancecontractsfleetacademydmsvaultwebhostingeventsescalationexecutive formula
dataSource
collection
pipeline
unit
countpercentcurrencyduration_minutesduration_hoursdaysscoreratio higherIsBetter
isSystem
refreshFrequency
realtimehourlydailyweekly Keine Felder passen zum Filter.
Calc-Measure
Keine Felder passen zum Filter.
Query
name
description
pipeline
fieldProjections
groupBy
limit
isSystem
tags
Keine Felder passen zum Filter.
Dashboard
title
description
category
service_desktechnicianfinancecrmsalestelephonyprojectshrassetscompliancecontractsfleetacademydmsvaultwebhostingeventsescalationexecutivecustom visibility
personalteamglobal teamIds
tags
isPredefined
predefinedKey
tabs
id
label
description
filterPane
variableKeys
collapsed
refreshInterval
Keine Felder passen zum Filter.
Widget
title
description
dashboardId
predefinedDashboardId
scope
tenantuser ownerUserId
x
y
w
h
tabId
queryId
chartType
kpi_cardlinebarhorizontal_barstacked_bargrouped_bardoughnutpieareastacked_areaheatmapscattergaugefunneltablepivot_tabletreemapradarwaterfallhistogram markdownlist inlineQuery
config
xField
yField
seriesField
valueField
labelField
unit
currency
precision
invertColors
showTrend
showSparkline
comparisonPeriod
previous_periodprevious_year colorScheme
brandtableau10d3cat10okabeItoviridisbluesorangesrdYlGnsemanticpastel colorMapping
sortMode
semanticlabelvalue-descvalue-asccustomnone sortOrder
refreshInterval
drillThrough
entityType
fieldMapping
Keine Felder passen zum Filter.
Alert-Rule
name
description
metricKey
collection
pipeline
valueField
severity
infowarningcritical isActive
cooldownMinutes
lastTriggeredAt
lastValue
consecutiveBreaches
requiredConsecutiveBreaches
escalationPolicyId
schedule
activeHoursOnly
timezone
Keine Felder passen zum Filter.
Report-Template
name
description
format
pdfexcelcsvhtml variables
headerHtml
brandingEnabled
Keine Felder passen zum Filter.
Simulation
name
description
scenarioType
customer_onboardingprice_changeheadcountcontract_renewallicense_optimizationcustom parameters
Input parameters (e.g., { churnRate: 0.05, priceIncrease: 0.1 })
baselineData
Snapshot of current state at simulation time
results
Computed simulation results
comparisonMode
vs_baselinevs_scenario Keine Felder passen zum Filter.
Custom-Endpoints (/api/v1/analytics/...)
Über CRUD hinaus gibt es ~17 dedizierte Analytics-Endpoints für Live-Queries und Aggregations-Trigger. Auszug:
| Operation | Hinweis |
|---|---|
POST /api/v1/analytics/query | Ad-hoc-Query gegen Dimensionen + Maßzahlen |
POST /api/v1/analytics/widgets/<id>/recalculate | Re-Calc eines Widgets |
GET /api/v1/analytics/datasources | Verfügbare Datenquellen |
GET /api/v1/analytics/benchmarks/<dimension> | Branchen-Benchmark abrufen |
POST /api/v1/analytics/simulations | Szenario starten |
Die vollständige, immer aktuelle Liste finden Sie in der OpenAPI-Spec.
Custom-Widgets
User-erstellte Widgets liegen in analytics_widgets. Der Body trägt:
{
"name": "Tickets pro Woche, Top-10-Kunden",
"kind": "bar_chart",
"query": {
"dimensions": ["week", "partyId"],
"measures": ["ticket_count"],
"filters": [],
"limit": 10,
"sortBy": "ticket_count:desc"
}
}
Verwandt
- Konventionen
- Module-Seiten — jede Aggregat-Tabelle hängt an einem Modul