Info
This question is closed. Reopen it to edit or answer.
I am not able to do, sum of data of last 10 days, please help, it only displays data of 10 days. i want to add all the datas and display the total sum.
1 view (last 30 days)
Show older comments
% Enter your MATLAB Code below
% Enter your MATLAB Code below
% Read Output Water Quantity over the past month from a ThingSpeak channel and write
% the average to another ThingSpeak channel.
% Channel 1035265 contains data from the MathWorks water supply station, located
% in Natick, Massachusetts. The data is collected once every day. Field
% 3 contains output liquid quantity data.
% Channel ID to read data from
readChannelID = 1035265;
% Output Liquid Quantity Field ID
outputliquidqantityFieldID = 3;
% Channel Read API Key
% If your channel is private, then enter the read API Key between the '' below:
readAPIKey = '';
% Get Output Liquid Quantity data for the last 30 days from the MathWorks water supply
% station channel. Learn more about the THINGSPEAKREAD function by going to
% the Documentation tab on the right side pane of this page.
meter_reading = thingSpeakRead(readChannelID,'Fields', outputliquidqantityFieldID,'NumDays',10,'ReadKey',readAPIKey);
% Calculate the Cost
Billing_cost = 5*(meter_reading/1000);
display(Billing_cost,'Total Billing Cost (INR)');
% Start by setting the channel ID and Alert key. All alert key start with TAK.
formatSpec = "The Water consumption bill is: %d,%d";
A1 = 5*(meter_reading/1000);
A2 = meter_reading
apiKey = 'TAK14ZOZGAXZQMR05';
alertURL = "https://api.thingspeak.com/alerts/send";
options = weboptions("HeaderFields", ["ThingSpeak-Alerts-API-Key", apiKey ]);
alertBody = sprintf(formatSpec,A1,A2)
alertSubject = sprintf(" Water consumption exceeded 100 l!");
if meter_reading >= 100
webwrite(alertURL, "body", alertBody, "subject", alertSubject, options);
end
4 Comments
Christopher Stapels
on 29 May 2020
sum(meter_reading) worked for me. THere were 64 values, summing to 49321.
Answers (0)
Communities
More Answers in the ThingSpeak Community
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!