[Beta] Quick Chart - Chart your data, quickly and easily

JustinL · July 14, 2022, 1:37pm

Is there an existing way to chart a device's attribute strictly on a daily basis? Take mowing duration as an example. I'm trying to get one bar for today's mowing duration, one bar for yesterday's mowing duration, another bar for the day before yesterday's mowing duration, etc. And today's mowing duration bar gets bigger the more i mow today. This would require that quick charts accumulates and groups values of the mowing device's duration attribute on a day by day basis.

I'm guessing that's not possible yet, right? If it's within the realm of possibility with this API, and if others would find it useful too, maybe put it on the back burner for a feature at some point? Otherwise, if it's not something that the quick charts API could handle itself, but there would be a way to do it by feeding quick charts the right data at the right time, i'm all ears!

bptworld · July 14, 2022, 3:31pm

Not yet, remember this is still a beta. Just want to get the basics working with the raw event data that each device accumulates. Once that is done, the sky is the limit on data collection.

The next beta will be a huge upgrade to the charting abilities.

JustinL · July 14, 2022, 3:34pm

Certainly - just making sure I'm testing all available features Good to hear about expandability. Must be a pretty extensive API that quick charts offers.

bptworld · July 14, 2022, 10:04pm

New bundle...

0.0.4 - 07/14/22 - Rewrite, rewrite, rewrite...

Can now choose as many devices and attributes that you want on any chart.

mjruotolo · July 16, 2022, 5:01am

I love this idea. This might be a dumb question but how do I add this to a dashboard? I am asuming i add the virtual device but what template do I use?

cometfish · July 16, 2022, 5:20am

Use the Attribute template, and select the chart number from the attribute dropdown that appears.

mjruotolo · July 16, 2022, 5:38am

That’s what I thought but it doesn’t show.

mjruotolo · July 16, 2022, 5:41am

These are my settings

amithalp · July 16, 2022, 8:30am

Same thing for me. No attributes to select from in the dashboard tile and no events or logs seems to be captured in the virtual device page

bptworld · July 16, 2022, 11:53am

Adding a Tile to the Dashboard

amithalp · July 16, 2022, 8:59pm

Hi @bptworld
From your instructions:

Be sure to go into the Device and visually CHECK to make sure the Attribute actually contains the data you want to display on the tile
This is my setup:

image685×724 40.6 KB

image732×739 29.7 KB

But when I look at the virtual device that was created I see no events and looking at the log I get:

image1591×559 154 KB

What is wrong?

bptworld · July 16, 2022, 9:01pm

Go to the DEVICE
Show me the Attribute

amithalp · July 16, 2022, 9:11pm

Device page:

bptworld · July 16, 2022, 9:13pm

Thanks.

Working on a BIG update right now, should have something out in a little bit.

(hint: data collection)

amithalp · July 16, 2022, 9:15pm

Do you want me to delete the current config and reset them after the update? Or will your fix work on current setup?

sburke781 · July 16, 2022, 9:17pm

Any chance that will be in the same json format as the events returned by Maker API?

bptworld · July 16, 2022, 9:21pm

Yes, while in beta it's always best to delete and start again with new builds

Nope. I have no idea what Maker API returns BUT if you send me an example we might be able to come up with some sort of converter.

sburke781 · July 16, 2022, 9:30pm

Sorry, I should have disclosed my intentions first,.... Poor form on my part....

I am also looking at a charting solution, using a HTML page that reads recent device events from Maker API (at the moment), and I was wanting to make use of local storage for recording longer timeframes. I was thinking if I could read in the events in the same format as I am retrieving them from Maker API, I wouldn't need to write the code differently when interpretting the events, just use a different source.

So I was interested in whether you would consider separating out the storage of the events from the charting, so the storing of the event data could be used for any number of other purposes, not just charts.

bptworld · July 16, 2022, 9:49pm

Ha, that's how I'm doing it now. I wrote a separate child app to collect the data and write it to a file. Then that file is read back into the charting child app to produce the charts.

Right now I just finished setting the options for raw data like temp, humidity, etc. It simply adds to a text file when there is new data.

ie.

New temp reading is found
It adds the new Data: the Device, the Attribute, DateTime, Event (reading) into a text file.
Then the charting child reads the file, sorts/combines all the data and makes the chart.

Going to work on time duration next. ie. How long a device has been on/active/open,etc per day.

The only difference is going to be how the collector child app works, no changes will be needed to the charting child app.

Probably not making much sense but it'll be cool when it's done!

sburke781 · July 16, 2022, 9:53pm

Here's an example of what Maker API returns. I wouldn't need every key/value pair for what I am doing... It's basically an array of json elements (I'm probably not using the right terms there....

Example Data