2 Replies Latest reply: Jan 15, 2015 10:44 AM by ralph snijckers RSS

    Minute value trending

    ralph snijckers

      Hello,

       

      In my dashboard I want to see a value trending in time.

      Each minute we get a value out of the building management system.

      For each sensor, in total 40 sensors, there is a text file with two parameters: Date and value

      Like:

      Date; Value

      08-01-2015 15:06:00; 33

      08-01-2015 15:07:00; 35

      08-01-2015 15:08:00; 38

      In the script the text file are combine together by the date.

      For 1 month we have about 45.000 rows and 40 columns.

      The problem is that the file is very slow and I thinks its due the script.

       

      The file is attach.

      Can you help me to make the file faster?

       

      Thanks.