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.
[B]
Filter
Here you can select which data from which assettypes you want to see.
[C]
Sorting
Here you can select whether the subassets should be displayed in geological or functional sorting.
[D]
Go to...
Here you can jump to the map, to Tickets and Analytics of the Assets .
[E]
Search
Here, as in the Asset list, you can search for Assets .
[F]
Current data
Here the most recently written data in the asset are displayed.
[G]
Show aggregated data
To see the aggregated data, you can click on the small clock. Then [H] the aggregated data will open on the right.
[H]
Aggregated data
Here you can see the aggregated data and their time periods. -> Show aggregated data
[I]
to the data details
To see all data sorted by date, click on the name of a Assets. The chronologically sorted Data view of the selected Assets will then open.
Data details
[J]
Data filter
Allows filtering the displayed data by various categories such as "All", "Input", "Output", and "Status".
[K]
Data table
Shows the raw data of the selected Assets in tabular form.
[L]
Aggregated data
Button to aggregate data in [K] display.
[M]
Export
Button to export the displayed data as CSV.
[O]
Time filter
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.
[Q]
bulk editing of data
Open the window to change past data for a value on a larger scale. -> Bulk editing of data
[R]
Edit individual historical data
Click the pencil icon on the value you want to change to manually modify this data point. -> Edit individual historical data
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
Click on [L], to display the aggregated data . ▷ The view switches from raw data to the aggregation view.
Set period: In [L1] you can define for which period the data should be aggregated.
Select aggregation interval: In [L2] select which time steps the data should be aggregated in (e.g. hourly, daily, weekly).
Select attribute: In [L3] you can determine which attribute should be aggregated.
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.
Apply settings: Click on [L5], to apply the changes made.
Reset settings: If necessary, you can reset the filters with [L6] .
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
Add new entry Click on Add new entry [P]. ▷ The "Add new data entry" window opens.
Select attribute Select the desired Attribute from [S].
Enter value Enter the desired value in the corresponding field [T].
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
Show pencil icon Move the mouse over the desired data entry. ▷ A pencil icon appears next to the entry.
Edit data entry Click on the Pencil icon [R], to edit the data entry. ▷ The "Edit asset data entry" window opens.
Enter new value Enter the new value for the entry.
Save changes Click on Save, to apply the changes. ▷ The new value replaces the old value in the record
Be careful which data you overwrite. Changes to existing records can be irreversible and permanently replace important information.
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.
Open bulk edit window Click on [Q], to open the window bulk editing of data to open.
Set period Enter the of- and todate as well as the times to define the period in which the data should be changed.
Select attribute Select the attribute whose data you want to change.
Set value Enter the new value that should replace the existing data.
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:
Data structure with Timescale
With TimescaleDB we only store the values that have actually changed. This reduces redundant data and improves performance:
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.
Was this helpful?