Versionen im Vergleich

Alte Version 38

changes.mady.by.user Franziska Näther [X]

Gespeichert am

verglichen mit

Neue Version 39

changes.mady.by.user Franziska Näther [X]

Gespeichert am

Schlüssel

  • Diese Zeile wurde hinzugefügt.
  • Diese Zeile wurde entfernt.
  • Formatierung wurde geändert.

...

Sv translation
languageen

In this article, we explain to you how to export the values of one or multiple data points as a CSV file.  The exported file can then be opened and edited in Excel or other programs.


Inhalt


1. How and where can I export data point values?

Data points can be exported as Benchmarks benchmarks in the Analysis analysis area.

Follow these steps to export your data:

  1. Click on the "plus-"button to add a new Benchmark benchmark or choose an existing one
     
  2. Configure the benchmark
    • Add data pointpoints
    • Configure data points
    • Select a time period
       
  3. Press the "Export"-button button above your data point list
     
  4. Configure the CSV file
     
  5. Click on "Download"


2. Exportable types of data points

Only numeric data points can be exported in benchmarks.


3. Configuration possibilities

There are multiple ways to choose and adjust the data points you would like to export.

ConfigurationDescription
Time range

Global time filter

  • By default, data is exported for the time range set in the global time filter
  • The global time filter can be found at the top of the screen, next to the QBRX logo

Fixed benchmark time range

  • You can also set a fixed time range in the benchmark configurations
  • The benchmark data and the data of the exported CSV-file are aggregated for this time range only
  • The chosen time range is shown below the name of the benchmark
  1. Click on the "Change time Time range" button
  2. Select "Use custom time range"
  3. Choose time rangeThe chosen time range is shown below the name of the benchmark
  4. The fixed time range stays the same, even after changing the global time range
Aggregation levelDetermine the level of aggregation for your data. The aggregation is applied to all data points in your list.
Data point selection

Choose the data points for your benchmark.

You can add as many data points as you like. However, please note that you can only choose numeric data points.

How to restrict the data point search

  • You look It's possible to search for the name of the data point and its facility at the same time
  • Use the global facility filter to restrict your search results
Calculation Aggregation methodThis feature indicates how values are calculatedaggregated. This can be changed for every data point separately.





Image RemovedImage Added

4. Formatting of the exported CSV file 

There are multiple options for the configuration of the exported CSV fileto configure the SV file that will be exported. Depending on your choices, more or less data will be in the CSV written to the CSV file or it is displayed in different way. The exported file can then be opened and edited in Excel or other programs. 


ConfigurationDescription

Included fields

Facility name

Data point name

Unit

Select one of these options to include the information in the CSV file.

Attention: You Your selection is not saved and has to be made again for each export.

Decimal separatorChoose the punctuation mark to separate decimal digits.
Time stamp

The two available time stamps look like this:

Default time stamp: dd.hh.yyyy hh:mm:ss

Time stamp ISO 8601: yyyy-mm-ddThh:mm:ss+01:00


Example

Image Removed   Image Removed



5. Example: Export of load profiles of multiple sites

In this example, we want to export a CSV file with the values of load profiles of different sites with values every 15 minutes via CSV.  We want the data of the last 30 days, aggregated to show an entry every 15 minutes. 

  1. Create new benchmark
     
  2. Add the data point points "Load profile" of multiple sites
     
  3. Set the aggregation level to "15 minutes"
     
  4. Set global time filterrange
    • You can also use the fixed time filter of the benchmark
       
  5. Click on button "Download data point values as CSV file"the button Export button above your data point list 
     
  6. Select the information that should be included in the file
     
  7. Choose dezimal decimal separator
     
  8. Choose the type of time stamp
     
  9. Click on "Download" to export your data

Image Added

Image Added

Image RemovedImage Added