Skip to main content
D
DR_105589338-Gravel
8-Gravel
October 6, 2023
Solved

Cannot show line chart

  • October 6, 2023
  • 2 replies
  • 3757 views

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

 

 

 

 

 

 

Best answer by Sathishkumar_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()

 

 

2 replies

A
Arun_C16-Pearl
16-Pearl
October 6, 2023

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

D
DR_105589338-GravelAuthor
8-Gravel
October 6, 2023

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

    A
    Arun_C16-Pearl
    16-Pearl
    October 6, 2023

    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

     

      S
      Sathishkumar_C17-PeridotAnswer
      17-Peridot
      October 6, 2023

      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()

       

       

      D
      DR_105589338-GravelAuthor
      8-Gravel
      October 6, 2023

      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

      S
      Sathishkumar_C17-Peridot
      17-Peridot
      October 6, 2023

      select timestamp field in XAxisField 

      Sathishkumar_C_0-1696590460941.png

       

        Terms & ConditionsAccessibility statement