Display variables in tabular foprmat | General | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
Display variables in tabular foprmat
Avatar
dhananjay
New Member
Forum Posts: 1
sp_UserOfflineSmall Offline
1
July 18, 2017 - 5:30 am
sp_Permalink sp_Print

Dear Expert,

I have to show the PLC variables value in tabular format in ThingSpeak. Now i can see only the trend view in thingspeak.

Sr No Date and Time Variable 1 Variable 1
1 18/07/2017 10:10:10 24 78
2 18/07/2017 10:10:30 25 77
3 18/07/2017 10:10:50 26 76

Plz suggest how i can display this variable in tabular format. Also i need to do data logging in thingspeak

 

Thank you in advance 🙂

 

Regards,

Dj

Avatar
cstapels

Gold
Forum Posts: 39
sp_UserOfflineSmall Offline
2
July 18, 2017 - 9:07 am
sp_Permalink sp_Print

You can use the uitable function of MATLAB.

 For example, if you wanted to read the cheerlights Hex values and color names for the last 15 points: (you could replace with a read to your channel, don't forget the Read API key if it is a private channel) 

Paste this code into a blank MATLAB visualization and add it to your channel view.

data=thingSpeakRead(1417,'OutputFormat','Table','NumPoints',15)
uitable('Data', [data.CheerLightsHEXColor data.LastCheerLightsCommand], 'ColumnName', {'Hex', 'Name'});

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
19 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 247

Vinod: 140

piajola: 71

vespapierre: 63

Adarsh_Murthy: 59

chrisjmears: 54

Newest Members:

DFence

HariKrishan

guya

Vicky66

RobO

Gottmoz9

Forum Stats:

Groups: 4

Forums: 17

Topics: 1209

Posts: 4235

 

Member Stats:

Guest Posters: 1

Members: 5480

Moderators: 0

Admins: 2

Administrators: Hans, lee