Create a workbook that displays the total number of readings per house and appliance

[carlosparadis]

This is a refinement of #1, to allow the usage of filter and colors to see the sensors. I would also like you to look on the web if there is not a better method to visualize the data that is not so slow to explore the sensors as plotting everything together.

Since this is the main plot that @ryantanaka and @jygh98 can use to inspect if something goes wrong, this is high priority.

[kathrynparadis]

Hey, so do you want this to be filtered for just egauges? Or for all sensors.

Also, if just for egauges, there are 2 ways I can do it. The easiest being to apply a unit filter, and select for kw. However, if this is to be used for other databases it may not work properly (eg. FrogUhm database would not work because the egauges are not the only devices that use kw, in this case I would have to specifically find each egauge, and filter by purposeID)

Which way would you like it to be filtered?

(But again the purposeIDs would be different for each database more than likely)

[carlosparadis]

Filtering by units is likely a bad idea, it is not future proof either, as this project used Apollo sensor before, and ibis, which both measures energy (kwh) data.

Use the purpose ids in the database. You should be able to find them sitting in the sensor_info table. It is fine that they are different, so long the logic is consistent it should require minimal modifications.