Basic Concepts

Pimcore Statistics Explorer is a lightweight statistics tool designed for easy integration into applications. It allows users to analyze data, generate reports, and explore information using configurable data sources.

Reports can be created in two modes: simple listings or aggregated data with pivot tables.

The Statistics Explorer is not a full-featured BI or data science tool but provides a straightforward and flexible way to analyze data within Pimcore.

It includes a user-friendly UI that can be embedded into custom applications, enabling users to create, save, and share reports.

One application of the Statistics Explorer is its integration into Pimcore's Portal Engine.

Data Sources

Statistics Explorer supports multiple data backends as data sources to generate reports. A data source is always a single table or index — joins and complex queries are not supported.

Data sources must be set up by developers and can come from different backends, including databases and search indexes.

Supported Data Backends:

• Opensearch index
• Elasticsearch index
• MySQL table

Statistic Modes

Statistics Explorer supports two modes for generating reports, each suited for different use cases. Choose the appropriate mode based on your requirements and configure the report by selecting relevant data attributes from the data source.

Supported Modes:

• Statistics Mode – Aggregates data, calculates metrics, and supports pivot tables. Example use cases:

  • Time series reports (e.g., logins over time).
  • Products per category.
  • Assets per type.

• List Mode – Creates basic listings with filtering and sorting. Example use cases:

  • Assets with expiring licenses.
  • Products without images.

Visualization

Reports can be used as a basis for visualizations. In Statistics Mode, data can be displayed in charts using the same dataset shown in the table.

Supported Chart Types:

• Pie
• Bar
• Line
• Area

Choose the most suitable visualization based on the use case.