---
title: Viewing Event properties as a table
slug: how-tos/H6Yb-tr
docTags: HM2rWeeWAO1-Dgm69CZmi,8EU_tNMQjMdJ8KLDWLfi-
createdAt: 2025-09-05T08:28:55.486Z
---

## Prerequisites

Before displaying events in Grafana, ensure:

- [Events are configured](docId\:E9BJfTgiZ2M1bxQPPz3qx) in Factry Historian.
- [The Factry Historian datasource plugin](docId\:q9t7hXoxsKNYLaWPorfdD) is correctly set up in Grafana.

:::hint{type="info"}
To learn more about [Events](docId:0Ith2zLcAIs5YYwhSdTjE), consult the Concepts documentation.
:::

## Why use the Factry datasource for simple properties?

The Factry Grafana datasource is built to make **event data exploration simple**. It allows you to:

- Query events and their simple properties directly, without writing custom SQL.
- Display events as **tabular overviews** with start/end times and context.
- Use built-in support for **Assets** and **WHERE filters** to focus on the data that matters.
- Seamlessly combine event data with time-series data for **end-to-end process analysis**.

## Default usage

![](https://api.archbee.com/api/optimize/SMPo4IS9FkillUAMsur2c/3cja5ONtXQpk-a2tOeAwE-20250925-110236.png)

To display simple properties of events, either create a new dashboard or use the explore functionality. Open or create a new Table panel in Grafana. Select the Factry Historian datasource plugin as the Data source.

If it's not selected by default, then select the **Events** tab.

- Select `Simple` as the Query type.
- Select an asset (with events configured on it) from the asset tree by clicking the Assets field.
- Select the Event type.
- Select the event's simple properties from the Properties field.
- Optionally filter on status (e.g. only processed events).
- Optionally include a [WHERE clause](docId\:H6YbVqvQPr4V1M_xXdNpo)
- Optionally include simple properties from parent events.

![](https://api.archbee.com/api/optimize/Kv2gMHbxov7nKub4ri53o-P7Fe8AD2eLxVGZwbGE_3_-20250905-112958.png)

### Filtering event tables by event values

Event tables often contain many runs. Filters help you focus on the relevant ones.

- **Filter by asset** → Use the Assets field in the query editor.
- **Filter by other event properties** → Use the WHERE clause.

Syntax:
&#x20;WHERE \<COLUMN> = \<Value>
&#x20;WHERE \<COLUMN> IN ('Value1', 'Value2')

Examples:

- WHERE Product = 'IPA'
- WHERE BatchID IN ('12345', '12346')
- WHERE Shift = 'Night'
- WHERE Usage >= 5

![](https://api.archbee.com/api/optimize/Kv2gMHbxov7nKub4ri53o-pNuemLJWERZXIOGAUdVTa-20250905-114645.png)

### Transforming timestamps

Event start and end times are returned in UTC timestamp format. To display them in a user-friendly way:

1. In the panel editor, go to Transform.
2. Add a Convert field type transformation.
3. Select the timestamp fields and format them as Date/Time.

:::hint{type="warning"}
If you filter on event state, exclude open events (events that are still running).
&#x20;Otherwise, the missing end time may cause errors in timestamp transformations.
:::

![](https://api.archbee.com/api/optimize/Kv2gMHbxov7nKub4ri53o-UUxk0Ag-yzXfmRjpZY1YB-20250905-135528.gif)