Deleting old (bad) values from a chart? | ThingSpeak API | Forum

Avatar

Please consider registering
Guest

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
Deleting old (bad) values from a chart?
No permission to create posts
February 5, 2015
3:46 pm
Avatar
capolaris
New Member
Members
Forum Posts: 4
Member Since:
February 5, 2015
sp_UserOfflineSmall Offline

Hi everyone!

I'm writing with a quick question. As I'm trying to learn more about how ThingsSpeak works by playing with the plotting data on charts (this is my 1st post!), I was wondering about how everyone deals with "bad" data points. Say, for example, that I have a series of air temperature data points showing 60 (deg. F) , and in the middle these numbers I have a single value that is "-2". Since the "-2" is obviously a bad data point (due to a problem with my sensor), is there a way to "remove" it from the chart that is being plot?

Thanks in advance,

Luke

February 5, 2015
4:56 pm
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi Luke,

You can apply the "min" parameter to the feed, and results below that value won't be shown: https://thingspeak.com/docs/charts . You can also specify this parameter by going to your public or private channel view, clicking on the edit chart icon, and specifying "Data Min" or "Data Max".

Here's an example:
https://api.thingspeak.com/channels/9/charts/1
https://api.thingspeak.com/channels/9/charts/1?min=160

lee

February 5, 2015
5:48 pm
Avatar
capolaris
New Member
Members
Forum Posts: 4
Member Since:
February 5, 2015
sp_UserOfflineSmall Offline

Hi Lee

great... thanks for letting me know about the "min" function. I was not aware of that. Since some of my bad data values are somewhat random, some of them are close to the temperature that I was recording (e.g.: I get a continuous 65.3 and all of a sudden it goes to 60, and then immediately jumps back to the 65.3 level. But then, during the evening, as it gets colder and the real values get to ~53, if I was to set the "min" I would be chopping off these good values along with the bad data.

Therefore... I was wondering if there might be a better way of going around to do this? Is there a way to delete specific data point(s) (which I know represent bad data?

Thanks!

February 6, 2015
8:24 am
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi Luke,

We currently don't have a way to delete the bad data points, but we are internally discussing how to handle this and hope to have a solution in the future, whether that be deleting the data points directly or providing smarter analysis and visualization of existing data (or both).

lee

April 14, 2015
3:54 am
Avatar
jass
New Member
Members
Forum Posts: 3
Member Since:
February 14, 2014
sp_UserOfflineSmall Offline

Hi,

I would like to see this available too.

Thanks,

July 13, 2015
8:44 pm
Avatar
fishmastaflex

Silver
Members
Forum Posts: 11
Member Since:
June 18, 2015
sp_UserOfflineSmall Offline

Hey Lee,

Would it be possible to delete all data in a particular field, instead of all data in a channel? I know you can go into channel settings page and click on the remove radio button under a particular field, but the data doesn't permanently go away when I tried that.

Maybe a future improvement.

July 14, 2015
8:39 am
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi,

Deleting all possible data in a single field is not possible right now, but will be taken into account when we start working on a feature to allow selective deletion of data.

lee

November 2, 2016
7:28 am
Avatar
rberkelm

Silver
Members
Forum Posts: 13
Member Since:
June 23, 2016
sp_UserOfflineSmall Offline

Hi Lee

Just wondering if there is any update to this thread, i.e. ability to delete specified data points from a field. and all data points from a field (without deleting the entire channel)? Apologies if I've missed any subsequent postings on this!

January 12, 2017
7:43 am
Avatar
svicar
New Member
Members
Forum Posts: 1
Member Since:
January 12, 2017
sp_UserOfflineSmall Offline

Helo

I can give you the way to do it...

1. Go to data inport/export and export the data to csv file. Use notepad to delete or modify unwanted rows.

2. Go to channel setting and "clear channel" delete all data (only velues)

3. inport the modifyed csv file.

 

thats the way I deleted unwanted data...

January 15, 2020
1:49 pm
Avatar
Deimos

Silver
Members
Forum Posts: 6
Member Since:
January 2, 2018
sp_UserOfflineSmall Offline

So 5 years later and it is still not possible? nice. I wanted to start using MQTT instead of HTTP, but now one mistake, and all my 1474569 data entries will be ruined. ThingSpeak could become a standard in IoT, but it looks like you just wasting your potential. There are small things that ruin everything. For example what the hell with the charts? is it really that difficult to add Highcharts or something similar? yes I can use the API and get what I want for myself, but why not do it for everyone? It would be great just to add a full-screen chart to see the data for 1 day, 1 week, 1, month, etc. I don't know who your average customer is, but from my point of view, I just don't get it. (sorry for emotions).

Forum Timezone: America/New_York

Most Users Ever Online: 166

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

anis, 43994554AKS, suda, marisol, qkpham, SANGAMNATH B

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457