Delete bad data from a field / channel | General | 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.

Please consider registering

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

sp_Feed sp_TopicIcon
Delete bad data from a field / channel
No permission to create posts
December 22, 2018
6:24 am

Forum Posts: 5
Member Since:
December 22, 2018
sp_UserOfflineSmall Offline

Hi, is there any way to delete bad data point from a field in a channel. if not, is there a way to specify a filter (max , min) at a channel / field level (not in a chart, but at the time of recording data tself)?

January 15, 2019
8:46 am

Forum Posts: 885
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

At present there is not a way to delete a single feed. One option is to download all the data and then delete the single point and then re write all the data, to the same channel or to a new channel. This may consume a lot of messages, depending how much data is in your channel.

You can filter the data in several ways on the chart, by setting a data max or min, or by using median or averaging. If the bad data point is not the first in a particular block of data, you may be able to filter it using the timescale setting as well. (for the chart, which I understand is not what you asked)

For input filter, the best way is to create a second channel for the filtered data. You can set a react to run on data insertion for the first field and then have the react trigger a MATLAB analysis that applies the filter and then writes the filtered data to the new channel.
Since you can have only one React on data insertion, it may be better to have the react trigger on a time control and then process a batch of data each time the analysis runs.

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
24 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:

huldacormier, bogart, estebanmateo93, mikewrite, onlinebusiness, winzy99

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457