Raw and aggregated data

Access every value at spreadsheet speed.

Raw and aggregated data views, historical queries and clean exports for BI and ERP — a precise, tabular window into everything PixelCore stores.

PixelTables data table

Precise answers, on demand

Filter and group
→ Query across every object type simultaneously
Historical queries
→ Explore any time window at full granularity
Clean exports
→ Download CSVs or access data via API for BI and ERP
See it work

From a whole estate down to one exact value

Slice across every object type, reach back through full history, and hand clean data off to BI and ERP — here it is, exactly as an analyst sees it.

Slice and dice your data

Master your data in one view

Query across all object types in a single grid. Filter, sort and group to pinpoint exactly the rows you need, whether raw or aggregated.

  • Filter, sort and group across types
  • Raw and aggregated views
  • Spreadsheet-grade precision
PixelTables grouped by device with the columns panel open
History

Reach back across full history

Run queries over any time window, backed by complete TimescaleDB history where nothing is ever lost or downsampled.

  • Historical queries and time windows
  • Full-resolution series
  • Backed by TimescaleDB
PixelTables historical query results across a date range
Export

Hand-off clean data to BI and ERP

Export to CSV or use the API — structured, consistent and ready to integrate seamlessly with your existing reporting tools.

  • Export options: CSV and API exports
  • Consistent schema for BI
  • Feeds ERP & downstream systems
PixelTables export view
Built on data. Driven by Intelligence.

Get precise export-ready numbers