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: 96
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:
16 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 252

Vinod: 164

cstapels: 96

piajola: 75

vespapierre: 63

Adarsh_Murthy: 59

Newest Members:

donj51

trilee

Bfletche

stuartWAI

shivmkatiyar

AidanThing

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

 

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee