I was wondering if someone wouldn't mind pointing me in the right direction, the first step of which would be to confirm this is even possible.
I would like to be able to scrape an entire set of data points via XML and then be able to plot those in an excel report. The data I will be pulling in is hourly predicted consumption rates that some energy entity posts. They post an entire week of predictions at a time and I'd like to be able to pull those into Mango, analyze each reading to see if it crosses some set value, and then plot the entire data set in a report.
I'm not asking for a solution to the problem but rather some ideas on how I would be able to store that data set. Alternatively I'm thinking that instead of needing to plot it I could just read in the points one by one, compare to my threshold and then just report about what time and day that threshold was exceeded.
Thank you forum!