# Asset data

## Data view 

The *Data view* in Eliona provides a detailed overview of the *asset* raw data written into a **aggregated** data from sensors or devices. Unlike graphical representations (e.g. lines or graphs), the *Data view* displays the values in tabular form so that the numbers are directly visible.

The *Data view* is particularly useful for:

* Monitoring the status of a *Assets* based on specific measured values in **real time**.
* Individual **to track data points precisely** and verify them.
* Providing data foundations for reports and detailed analyses.

Chronological sorting of the data makes it easier to recognize time-based patterns and identify irregularities more quickly.

<div data-full-width="true"><figure><img src="https://content.gitbook.com/content/Nyvwhz1kEMXcHf4HLuZ8/blobs/UX6Xvpu2dvuF0rNkM9a1/Asset%20Daten.png" alt=""><figcaption></figcaption></figure></div>

<table data-full-width="true"><thead><tr><th width="87"></th><th width="253"></th><th></th></tr></thead><tbody><tr><td><strong>[A]</strong></td><td>Data</td><td>After opening the <a href="asset-details">-> Asset details</a> the data view can be opened via the "Data" tab.</td></tr><tr><td><strong>[B]</strong></td><td>Filter</td><td>Here you can select which data from which <em>asset</em>types you want to see.</td></tr><tr><td><strong>[C]</strong></td><td>Sorting</td><td>Here you can select whether the <em>subassets</em> should be displayed in geological or functional sorting.</td></tr><tr><td><strong>[D]</strong></td><td>Go to...</td><td>Here you can jump to the map, to <em>Tickets</em> and <em>Analytics</em> of the <em>Assets</em> .</td></tr><tr><td><strong>[E]</strong></td><td>Search</td><td>Here, as in the <em>Asset list</em>, you can search for <em>Assets</em> .</td></tr><tr><td><strong>[F]</strong></td><td>Current data</td><td>Here the most recently written data in the <em>asset</em> are displayed.</td></tr><tr><td><strong>[G]</strong></td><td>Show aggregated data</td><td>To see the aggregated data, you can click on the small clock. Then <strong>[H]</strong> the aggregated data will open on the right.</td></tr><tr><td><strong>[H]</strong></td><td>Aggregated data</td><td>Here you can see the aggregated data and their time periods. <a href="#aggregierte-daten-anzeigen">-> <strong>Show aggregated data</strong></a></td></tr><tr><td><strong>[I]</strong></td><td>to the data details</td><td>To see all data sorted by date, click on the name of a <em>Assets</em>. The chronologically sorted <em>Data view</em> of the selected <em>Assets</em> will then open.</td></tr></tbody></table>

## Data details

<div data-full-width="true"><figure><img src="https://content.gitbook.com/content/Nyvwhz1kEMXcHf4HLuZ8/blobs/hT3WR3DwXtYqwEqkhjQ1/Asset%20Daten%20(1).png" alt=""><figcaption></figcaption></figure></div>

<table data-full-width="true"><thead><tr><th width="103"></th><th width="180"></th><th></th></tr></thead><tbody><tr><td><strong>[J]</strong></td><td>Data filter</td><td>Allows filtering the displayed data by various categories such as "All", "Input", "Output", and "Status".</td></tr><tr><td><strong>[K]</strong></td><td>Data table</td><td>Shows the raw data of the selected <em>Assets</em> in tabular form.</td></tr><tr><td><strong>[L]</strong></td><td>Aggregated data</td><td>Button to aggregate data in <strong>[K]</strong> display.</td></tr><tr><td><strong>[M]</strong></td><td>Export</td><td>Button to export the displayed data as CSV.</td></tr><tr><td><strong>[O]</strong></td><td>Time filter</td><td>Allows detailed searching of data by selecting a start and end date as well as the respective time. The filters can be applied or reset.</td></tr><tr><td><strong>[P]</strong></td><td>Add new entry</td><td>Add a new data entry at the current time. <a href="#neuen-dateneintrag-hinzufugen">-> Add new data entry</a></td></tr><tr><td><strong>[Q]</strong></td><td>bulk editing of data</td><td>Open the window to change past data for a value on a larger scale. <a href="#massenbearbeitung-von-daten">-> Bulk editing of data</a></td></tr><tr><td><strong>[R]</strong></td><td>Edit individual historical data</td><td>Click the pencil icon on the value you want to change to manually modify this data point. <a href="#einzelne-historische-daten-bearbeiten">-> Edit individual historical data</a></td></tr></tbody></table>

***

## **Show aggregated data**

In Eliona, measured values can be displayed not only as raw data, but also in **aggregated form** . Aggregations make it possible to **present large amounts of data clearly and in different time intervals** .

### **Enable aggregated data**

1. Click on **\[L]**, to display the **aggregated data** .\
   ▷ The view switches from raw data to the aggregation view.
2. **Set period**: In **\[L1]** you can define for which period the data should be aggregated.
3. **Select aggregation interval**: In **\[L2]** select which time steps the data should be aggregated in (e.g. hourly, daily, weekly).
4. **Select attribute**: In **\[L3]** you can determine which attribute should be aggregated.
5. **Set aggregation mode**: In **\[L4]** various **aggregation modes** are available:
   * Average
   * Counter of sums
   * Cumulative counter
   * Minimum
   * Maximum

     ▷ you can find more about this [-> here](https://docs.buildings.ability.abb/collection/english-v14/academy/aggregations-in-eliona).
6. **Apply settings**: Click on **\[L5]**, to apply the changes made.
7. **Reset settings**: If necessary, you can reset the filters with **\[L6]** .
8. **Show aggregated data**: The calculated values appear in **\[L7]** in a tabular view.

Aggregated data enable **a better overview of long-term developments** and help to **analyze data flows efficiently**.

***

## Add new data entry

<figure><img src="https://content.gitbook.com/content/Nyvwhz1kEMXcHf4HLuZ8/blobs/tGHs2iVsXWAbXXfiNDyV/Asset%20Daten%20(5).png" alt=""><figcaption></figcaption></figure>

1. **Add new entry**\
   Click on **Add new entry** \[P].\
   ▷ The "Add new data entry" window opens.
2. **Select attribute**\
   Select the desired **Attribute** from \[S].
3. **Enter value**\
   Enter the desired value in the corresponding field \[T].
4. **Confirm entry**\
   Click again on **Add new entry**, to confirm the entry.\
   ▷ The entry for the attribute is written to the heap with the current timestamp.

## Edit individual historical data

<figure><img src="https://content.gitbook.com/content/Nyvwhz1kEMXcHf4HLuZ8/blobs/zadWFbXMlcWWsCbiP2uq/image.png" alt=""><figcaption></figcaption></figure>

1. **Show pencil icon**\
   Move the mouse over the desired data entry.\
   ▷ A pencil icon appears next to the entry.
2. **Edit data entry**\
   Click on the **Pencil icon** \[R], to edit the data entry.\
   ▷ The "Edit asset data entry" window opens.
3. **Enter new value**\
   Enter the **new value** for the entry.
4. **Save changes**\
   Click on **Save**, to apply the changes.\
   ▷ The new value replaces the old value in the record

{% hint style="danger" %}
Be careful which data you overwrite. Changes to existing records can be irreversible and permanently replace important information.
{% endhint %}

## bulk editing of data

If you want to change data in large quantities, e.g. because a device delivered incorrect data on a certain day, you can easily do this. With the bulk editing function, all data within a defined period can be set to a desired value.

<figure><img src="https://content.gitbook.com/content/Nyvwhz1kEMXcHf4HLuZ8/blobs/KmcL5hq5GMSmgtGO3JCM/image.png" alt=""><figcaption></figcaption></figure>

1. **Open bulk edit window**\
   Click on **\[Q]**, to open the window **bulk editing of data** to open.
2. **Set period**\
   Enter the **of**- and **to**date as well as the times to define the period in which the data should be changed.
3. **Select attribute**\
   Select the attribute whose data you want to change.
4. **Set value**\
   Enter the new value that should replace the existing data.
5. **Save change**\
   Click on **Save**, to apply the changes.\
   ▷ All data of the selected attribute in the specified period will be set to the new value.

### Using Timescale for storing time-based data

The use of **TimescaleDB** in *Eliona* enables efficient storage and management of time-based data, especially for changing values. By storing only values that have actually changed, storage space is optimized without compromising data integrity.

**Example: Changes over time**

Let's look at the data recorded at regular intervals:

**Original data without Timescale**

Each time record contains all values, even if they have not changed:

```yaml
ts: 2024-07-24T16:20: {cop: 36, jaz: 56, power: 18.83, energy: 461.51}
ts: 2024-07-24T16:21: {cop: 50, jaz: 56, power: 18.83, energy: 461.51}
ts: 2024-07-24T16:22: {cop: 100, jaz: 56, power: 18.83, energy: 461.51}
```

**Data structure with Timescale**

With **TimescaleDB** we only store the values that have actually changed. This reduces redundant data and improves performance:

```yaml
ts: 2024-07-24T16:20: {cop: 36, jaz: 56, power: 18.83, energy: 461.51}
ts: 2024-07-24T16:21: {cop: 50}
ts: 2024-07-24T16:22: {cop: 100}
```

{% hint style="info" %}
**Good to know:**\
When "**null**" values are written to Eliona as data from your devices, then these are **filtered out** and not written to the trend.
{% endhint %}