ThingSpeak Channel Table Error

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!

[Frederic FERRIEU]

same troubles is there an issue? Table format does not seem to work furthermore matlab has seen the transmission problem explaining whts happening but no solves it..

[Christopher Stapels]

@Frederic FERRIEU Im sorry, Im not sure what your issue is. Can you start a new thread and describe your problem?

[Frederic FERRIEU]

hello i have a lot of trouble with this

time_space = 2000;

[data, timestamps, chInfo] = thingSpeakRead(readChannelID, 'Fields', [thickFieldID, co2FieldID], 'NumPoints', time_space);

and then need to extract the Nan data with e.g.

% Read Humidity Data humiditydata = data(:, 1); humiditydata = humiditydata(~isnan(humiditydata)); ilen = size(humiditydata);

with two array co2data humidity ect... size are different what is the max value?

[Frederic FERRIEU]

%'DateRange',[startDate endDate]

myData= thingSpeakRead( readChannelID,...

'Fields', [3, 1],'DateRange',[startDate endDate]);

% Read Data other reading

disp(myData)

myData = thingSpeakRead( readChannelID,...

'Fields', [6, 1],'NumPoints',[12]);

disp(myData)

TString = evalc('disp(myData)');

TString = strrep(TString,'<strong>','\bf');

TString = strrep(TString,'</strong>','\rm');

TString = strrep(TString,'_','\_');

FixedWidth = get(0,'FixedWidthFontName');

% Output the table using the annotation command.

annotation(gcf,'Textbox','String',TString, ...

'Interpreter','Tex',...

'FontName',FixedWidth,...

'Units','Normalized',...

'Position',[0 0 1.5 1],'FontSize',7);

NaN NaN

NaN NaN

NaN NaN

NaN NaN

NaN 268.6447

[Christopher Stapels]

@frederic can you make a new post with your issue? It seems different than the OP.

Answer 1

[Christopher Stapels]

I suggest using a timetable. The uitable element is really not right for ThingSpeak.

dataTimeTable = ...
    thingSpeakRead(channelId, 'OutputFormat','TimeTable','NumPoints',3,'ReadKey',readAPIKey)

Then use the second suggestion in this answer.

I did it for some traffic monitor data.

myCarData = thingSpeakRead( 38629,'numpoints',3,'outputFormat','TimeTable' );

TString = evalc('disp(myCarData)');
TString = strrep(TString,'<strong>','\bf');
TString = strrep(TString,'</strong>','\rm');
TString = strrep(TString,'_','\_');


FixedWidth = get(0,'FixedWidthFontName');
% Output the table using the annotation command.
annotation(gcf,'Textbox','String',TString,'Interpreter','Tex',...
    'FontName',FixedWidth,'Units','Normalized','Position',[0 0 1.5 1],'FontSize',7);

I had to change the font size to get thigns to fit due to the long field names. You might be able to make that larger.

[Frederic FERRIEU]

ok let me see just discover your answer now... thats why i sent this last message... by the way in matlab why the fontsize is always so tiny... with my laptop yoga 14" i need to use a microscope to read the menu options.....