Help to configure my first Timeserie property

Ask the Community
1

Hello,

During my first attempt to implement a Timeserie property in my object type I faced trouble probably due to my miss understanding of one point.

Can some one help me to understand if I’m right or wrong ? I can’t test my idea before 2 weeks and I will be glade to hear I’m on the good way.

What I did:

  • Create an object type with a PK and 2 other props from a dataset : e.g pk = Jig_Sensor, entry_into_service_date, status
  • Created a Timeserie of each sensor daily metrics dataset with : Série ID (=machine_sensore, same has PK above), Date (=measure date), value (=measured value)
  • Added a TIME SERIE property “sensor_metrics” in my object type from Object Manager and pairing with the URI of my Time serie dataset

My expectations:

  • Sparklines in object table ( Insight, workshop)
  • Quick Time serie chart displaying metric of selected objects

What I get :

  • empty column in table and empty chart in quiver
  • No time série values found by the system

What I’m thinking now :

  • Property “sensor_metrics” should be field with value equal to the SERIE ID (directly build from the backing dataset)
  • link between Object and time série is not performed by the PK (that was my expectations untill now)

I’m still wrong ? Or is it correct?

2

Hey I think your updated understanding is correct.

Basically two things:

  1. The primary key property cannot be a time series property. You want to have a separate property on your object type which will act as your series ID column

  2. The way that the series is loaded is that when you construct a time series property and link it to the backing time series sync, the “link” to the sync is the value of the series ID within that column/property.

This image from the docs page is helpful. the temperatureID column becomes the time series property and seeing the series ID of temp1 will tell it to go load that series from the backing time series sync:

image
image3428×1864 219 KB