Is it possible for ThingTweet to ignore NULL values? | ThingSpeak Apps | Forum

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.
Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —





— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
sp_RankInfo
sp_Feed sp_TopicIcon
Is it possible for ThingTweet to ignore NULL values?
No permission to create posts
August 25, 2018
10:32 am
Avatar
AussieBattler
New Member
Members
Forum Posts: 1
Member Since:
August 25, 2018
sp_UserOfflineSmall Offline
Go to Top
1sp_Permalink sp_Print

Hi. Hope somebody can help. It's quite simple, I am bringing in data from a temperature sensor and when it is below 25 degrees it posts a tweet. However, occasionally the value returned from the sensor is null and it tweets when it shouldn't. Is there a way to have ThingTweet ignore NULL values?

August 30, 2018
5:07 pm
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 885
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline
Go to Top
2sp_Permalink sp_Print

Your plan is definitely possible, it requires just a little bit of administration, and it may increase the delay. I would create another channel for filtered data. Then create a MATLAB analysis that reads the data from your temperature sensor channel. If the value is normal, it writes to the refined channel If the value is NULL, you can have it repeat the previous value or do a running average. You can use a React or TimeControl to trigger the Analysis. Then you can set up your react to trigger on the refined channel, and it wont have the problem with NULL values. You can only have one react run 'On data insertion' so one of the two operations will need to be on a regular schedule.

Let us know if that works for you.

No permission to create posts
sp_Feed
Go to top
Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
27 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

Advantagetreeexperts, laundrydaddyuk, techhhelp5, ken, tran, huldacormier

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457