Senseforce 2.0 Manual
  • Welcome to Senseforce 2.0
  • SF MQTT API
  • SF Edge
    • Edge Package Overview
    • Edge Installation
      • Using the SF Edge Service installer in command shell
      • Headless SF Edge Servie execution
    • Edge Configuration
      • Which Plugins to load (appsettings.xml)
      • Edge Data Routing (EventDefinition.xml)
      • OTA configuration (otasettings.xml)
      • Edge Logging
      • Input plugins
        • SQL Plugin
        • SQLite Plugin
        • OPC UA Plugin
          • OPC UA server browser
        • SIEMENS S7/SINUMERIK Plugin
          • Creating connection definition file
        • S7 Plugin
        • REST Plugin
        • TCP Listener Plugin
        • XML File Parsing Plugin
        • Heidenhain Plugin
      • Output Plugins
        • MQTT Plugin
        • SQLite Plugin
    • Edge Compute plugins
      • Creating compute plugins
      • Using compute plugins
  • SF Edge Asset Management
    • Edge version repository
  • SF Platform
    • Navigation
      • Overview Screen
    • Dataset Builder
      • Filters, Aggregations and Groupings
      • Functions of the Formula Editor
      • Additional Settings
      • Special Events
      • FAQ and Troubleshooting
    • Script Editor
      • Details of the Script Editor
      • Installed Packages
      • Working with Timestamps
        • Working with Timestamps in Python
        • Working with Timestamps in R
      • FAQ and Troubleshooting
    • Widgets
      • Text
      • Headline
      • Image
      • Progress Bar & Gauge Chart
      • Table
      • Map
      • Line, Bar, Scatter and Area Chart
      • Pie Chart
      • Gantt Chart
      • Histogram
      • Overview
      • Log
      • Default colors and color conditions
      • FAQ and Troubleshooting
    • Dashboards
      • Dashboard Filters
      • Favorites
      • Data Drilldown & Widget Interaction
      • Editing multiple dashboard widgets
      • Time Zones
      • Synchronized Zooming
      • Sharable Dashboard URL
      • Multi-chart layout options
      • Default sort for table widgets
      • Releases
      • Reporting
      • FAQ and Troubleshooting
      • Applying zoom to global timestamp filter
      • Optimise the layout for different devices
    • Machine Master Data
      • Dimensions
      • Instances
      • Things
      • Use Case
      • FAQ and Troubleshooting
    • Automation
      • Trigger
      • Scheduling overview
      • Actions
      • Test your Automation
      • Zapier integration (necessary internal steps)
      • Zapier integration
      • Subscriptions
      • FAQ and Troubleshooting
    • Event Schema Management
      • Importing a Event Schema
      • FAQ and Troubleshooting
    • Virtual Events
      • Creating a Virtual Event
      • Scheduling Overview
      • Permissions and Data Access
      • FAQ and Troubleshooting
    • Details modal for elements
    • Copy / Duplicate elements
    • Whitelabeling
    • Edge Device Management
    • Element History
    • Public API
      • Get your access token
      • Endpoints
      • Debugging scripts
      • FAQ and Troubleshooting
    • User & Group Management
      • FAQ and Troubleshooting
    • Active Directory & SSO Setup
Powered by GitBook
On this page
  • Function Editor
  • Exporting Data
  • Where is my data?
  • I did select some columns but there are no rows displayed or they are not updated.
  • Where is my dataset used?
  • How can I apply to the data itself instead of the aggregation result?
  • Why can't I see the LOCF setting?
  • Why are there some entries at the dataset borders not filled up when using the LOCF function?

Was this helpful?

  1. SF Platform
  2. Dataset Builder

FAQ and Troubleshooting

Collection of various tips and tricks concerned with the dataset editor.

PreviousSpecial EventsNextScript Editor

Last updated 3 years ago

Was this helpful?

Function Editor

If there is a statistic function in one branch with events, then you also need a statistic function in other branches that include events.

The division of an integer or long is executed as a division with remainder. If you want to execute a division without remainder cast the dividend to double.

I do not like the way my timestamp is displayed. Use the Time > Format function in the function editor (for details in the function see: ) to set the format you want. If you want your timestamp displayed as a number, keep in mind that we are using a UNIX timestamp in milliseconds.

How can I display the difference between two timestamps in a useful way? There is a specific data type for this in the function editor. Pick Time as a data type in the output settings of your function to display your time difference in a readable format. Of course, you can also display the difference as a number by choosing Integer/Long as a data type. Keep in mind that the timestamps are in milliseconds, so if you want your result in seconds additionally divide the time difference by 1000.

Exporting Data

You have the option to export your data in .csv format. Just click on the three dots in the top right corner of the data set editor and select "Export as CSV" to export all the data from this query up to the specified limit (the order is the same as the one displayed).

If I would export the first 5 rows of the above result I would get the following result, (S7Data) Thing;(S7Data) Timestamp;Speed DemoMachine1;1568648445276;18 DemoMachine1;1568648441555;20 DemoMachine1;1568648440670;18 DemoMachine1;1568648434326;14 DemoMachine1;1568648433015;10

As you can see, we use ; as a separator, the timestamp is exported in the UNIX timestamp format in milliseconds and the header is included in the .csv.

Where is my data?

You can not see your new dimensions in the dataset editor? Have you synchronized your dimensions? You can do so by clicking on the three dots in the top right corner and then selecting "Sync Dimensions".

I did select some columns but there are no rows displayed or they are not updated.

Did you get an error message, at the bottom of your screen? If your system is using timescale DB a popular reason is the use of columns from two different event schemas. If this is the case you need to include the metadata.Timestamp column to join the two event tables together.

Where is my dataset used?

How can I apply to the data itself instead of the aggregation result?

Why can't I see the LOCF setting?

The gap-filling feature called LOCF (Last Observation Carried Forward) is only available on environments using the Timescale database. So maybe you are running on Crate instead.

Why are there some entries at the dataset borders not filled up when using the LOCF function?

The LOCF function always fills up the gaps with the previous entry in respect of time. If the previous entry within this column is not known because it is cut off due to data limitations like a timestamp filter the previous entry is not known. In this case, it is not possible to fill up these entries.

Are you missing your newly defined event schema? Have you synchronized your event schema? You can do so by clicking on the three dots in the top right corner and then selecting "Sync Event Schema". If you see the schema but there is no data, then you might have a problem with the , or the data is invalid by the definition of your schema (you can check for invalid messages in the Event Schema overview).

Some of the columns have a red dot displayed in the header, like this By hovering over the red dot you can get detailed information about the problem. Some examples are unfinished or invalid function columns, not all columns having a grouping or aggregation, the use of only columns from the metadata event.

You did not get an error message nor do you see a red dot in one of the columns? Please check your filters , maybe the restrictions on the query do not return any data.

Go to the overview screen of the dataset builder (for example by clicking on the dataset builder in the left navigation sidebar). In the overview screen, you can see next to every dataset. Click on it and then on show details. Now a window should pop up. There is a section called usage where you can find the information about the usage of this dataset.

You can do this by using the Show data option. For detailed information see .

SF Edge
Functions of the Function Editor
Additional Settings