cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

Cannot show line chart

DR_10558933
5-Regular Member

Cannot show line chart

I get data from Kepware in DWORD and want to show in mashup but doesn't show. How to solve it?

 

 

 

 

 

 

ACCEPTED SOLUTION

Accepted Solutions

You have to few more steps to show data in line chart,

  • Log the Thing property values
    • Options: ValueStream, Stream, External Table
    • Easiest way to log the property values is Value Stream method
  • Use "QueryPropertyHistory()" service to pull all logged values.

 

To log into Value stream:

  1. Create value stream with "ValueStream" as Thing Template.

Sathishkumar_C_1-1696572235514.png

2. Attach the Value Stream into the Thing where the properties needs to be logged.

 

Sathishkumar_C_9-1696572602419.png

3. Make property to be "Log"

Sathishkumar_C_0-1696572174276.png

4. Now, you can use QueryPropertyHistory()

 

 

View solution in original post

8 REPLIES 8

Hi @DR_10558933 ,

 

Can you please explain us more about the data binding that done in your line chart? Service and Chart binding properties snap may help us to understand clearly. 

DWORD from kepware will automatically consider as NUMBER basetype in thingworx so that you can able to view the values in Remote Thing level.

 

Thanks & Regards,

Arun C

DR_10558933
5-Regular Member
(To:Arun_C)

I want to be like this X-Axis is Time and Y-axis is data number. if possible i want to show about 6 line in one graph. this i answer you correctly? Thank you

Screenshot 2023-10-06 140313.png

Hi @DR_10558933 ,

 

I did replica of your case in my local TWX 9.4.0. Can you please confirm you TWX version and check below image like the same you are preparing?

 

UI Design:

Arun_C_1-1696584675478.png

 

Output:

Arun_C_2-1696584747437.png

Thanks & Regards,

Arun C

 

You have to few more steps to show data in line chart,

  • Log the Thing property values
    • Options: ValueStream, Stream, External Table
    • Easiest way to log the property values is Value Stream method
  • Use "QueryPropertyHistory()" service to pull all logged values.

 

To log into Value stream:

  1. Create value stream with "ValueStream" as Thing Template.

Sathishkumar_C_1-1696572235514.png

2. Attach the Value Stream into the Thing where the properties needs to be logged.

 

Sathishkumar_C_9-1696572602419.png

3. Make property to be "Log"

Sathishkumar_C_0-1696572174276.png

4. Now, you can use QueryPropertyHistory()

 

 

DR_10558933
5-Regular Member
(To:Sathishkumar_C)

I follow you step in form of grid is work but in form of graph doesn't show anything. Have anything i make mistake?

Screenshot 2023-10-06 135418.png

select timestamp field in XAxisField 

Sathishkumar_C_0-1696590460941.png

 

DR_10558933
5-Regular Member
(To:Sathishkumar_C)

I have more question. How about "log" system that Thingworx used? How long that system record?

Announcements


Top Tags