3 Replies Latest reply on Jun 9, 2017 5:30 AM by akesana RSS
    akesana Explorer

    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

      • Re: Time series graph binding
        Ankit Gupta Ninja

        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.

          • Re: Time series graph binding
            akesana Explorer

            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

          • Re: Time series graph binding
            akesana Explorer

            Hi Ankit,

             

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

             

             

             

            Regards,

            Anil Kesana