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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Time series graph binding

akesana
1-Newbie

Time series graph binding

Hi,

We have have data as below table

                                                              

PlantWeight in tonsTime
P15006/9/2017
P26006/10/2017
P37006/11/2017
P48006/12/2017
P19006/9/2017
P210006/10/2017

We what to bind the above data to graph as below, X-access time is fine when it comes to Y-access we are getting data for all in single column but we want to show different lines based on Plant type (P1,P2,P3 etc).

How can we achieve this please help us?

Regards,

Anil Kesana

3 REPLIES 3
ankigupta
5-Regular Member
(To:akesana)

Hi Anil Kesana​,

You are trying to create a Time Series Chart based on P1, P2, P3, P4. So, P1, P2, P3, P4 should be columns to show then in Time Series chart

The Data should be something below:

Time                           P1_Weight_in_tons     P2_Weight_in_tons     P3_Weight_in_tons     P4_Weight_in_tons

6/09/2017 01:00         500

6/09/2017 02:00         900

6/10/2017 01:00                                             600

6/10/2017 02:00                                             1000

6/11/2017 01:00                                                                                    700

6/12/2017 01:00                                                                                                                         800

You might need to iterate through the Tables to make it like above.

Hi Ankit,

Thanks for your quick response,  I understood what your saying we need to write a service which takes current table iterate it and gives us output table as you mentioned. For these I believe need to use info tables in our service to achieve this . If  you can  send sample code how to iterate, It would be helpful us,meanwhile we are also exploring the same

Thanks in advance

Regards,

Anil Kesana

Hi Ankit,

Do you have any code sinppets for this please send if you have any sample?

Regards,

Anil Kesana

Top Tags