ThingSpeak

关注

Hi everyone, I am having issues with my ThingSpeak Channel only displaying certain portion of my table. When I run the visualization code on its own, I get the full table as shown here: However, when I refresh the page to check the ThingSpeak channel, only the last row of the table is displayed. I have tried to adjust the Display Settings on the Visualization side, but I am still getting the same issue. I have attached my code to the bottom of this post for any clarity. Any help would be appreciated!

I've got below timetable with daily measurements from my gas meter at home: Timestamps GasM3 ____________________ _____________ 14-Aug-2019 00:00:00 331.15 25-Aug-2019 00:00:00 332.37 26-Aug-2019 00:00:00 332.74 27-Aug-2019 00:00:00 333.97 I would like to know the daily consumption, so I tried playing with "differentiate" & "diff" to get these values in a new table. I've tried Test1 = differentiate(DailyGasDataTimeTable) which gave the following error: Error using Visualization: Differential test</a> (line 17</a>) 'differentiate' requires Curve Fitting Toolbox and Test2 = diff(DailyGasDataTimeTable) which gave the following error: Undefined function 'diff' for input arguments of type 'table'. Error in Visualization: Differential test (line 17) Unfortunately I'm stuck, please advise. Kind regards, Daniel

Using windspeedexample, I created an app to read data from selected public Thingspeak channel and use it to plot. I also wanted to add a table to store currently read records, which works, but has one significant problem - data in the table is getting rewritten in the first row. How do I make it so that every new input creates new row? App is in the attachments in .mlapp form. Sorry for the language, it's in polish but every input is filled so you can see what is going on. If there is no data logging, change channel ID (upper input) to 12397, dropdown to position 2, time intervals (lower position) to 5.