Custom Date Range in Web App Power Meter Tab

I didn’t see this anywhere but when viewing the Web App we can
choose 15 minutes. hour. day. week and month. If we could
we could specify a date range we could match it to a billing cycle.
Then we could really compare accuracy.
Note: I get texts everyday from the power company about previous
days use and when I have had a full day of sense without dropouts.
its been 10 to 20 percent below what the power company says.

Are your billing cycles coincident with the same day of the month, every month ? Or do the start/end dates move around every month ??

For me. it’s not really a problem. my read date is always
the 1st of the month. So i’ll just be off by one day for accuracy
but with it including the last day from the previous month. it
will be close. I was thinking about how people have middle
of the month read dates and those that fluctuate based on
number of day in that month. If you could set the web app
to display January 15th through March 13th then March 15th
through April 12th then it would a;lways line up.
I was looking at my bank account when I got the idea. searching
for a transaction and it asked the date range to display.

There’s something to be said for the online bank statement / Quicken / Mint model for custom reporting where you specify date range and maybe also select categories or tags plus deposits / withdrawals. Probably would be useful to a lot of people.

I’m kind of hoping that Sense will add additional smarts to their built-in billing cycle reporting. Today you can specify monthly start date of every billing cycle, but mine move around (below_. I have picked the 20th, but I can be off by as much as 3 days.

12/22/16
1/19/17
2/20/17
3/21/17
4/20/17
5/21/17
6/20/17
7/20/17
8/21/17
9/20/17
10/19/17
11/17/17
12/19/17
1/18/18
2/19/18
3/20/18
4/19/18
5/20/18
6/19/18
7/19/18
8/20/18
9/19/18
10/21/18
11/19/18
12/19/18

I’m not following how your able to pick a date
In sense. I can go to export and get a month
But if I want the 20th then I have to do it on
The 20th. If it were the 5th and I want data from
The 10 th of last month to the 1st of this month
That’s not available anywhere I have found.

There’s a difference right now between the app and the Webapp. The app allows you to specify a Billing Start Date for reporting in the settings. When you click on the “Bill” range option in the Usage Reports you see everything in terms of your monthly billing cycle (if your cycle is aligned with months). Not in the Webapp or export yet.

As I said, the 20th is only my nominal start date. Plus I have TOU pricing so I can charge our EVs at a much lower rate at night, while
producing higher value solar during the day. So usage and cost don’t exactly line up.

I forgot about that in the phone app. I have been using the laptop
a lot lately (hate it) so I can come to the community. there is still
a bug with the iPhone, sense and discourse right now.
The phone app kind of does it but you can’t export or print unless
its a screenshot. I still would le to export so I can see it detailed.

My power company uses smart meters so I can download hourly demand data (actually they do every 15min) from them, then compare directly against Sense exported data on an hourly basis. Makes it a little easier to pinpoint where/when the differences are coming from. I’ve had a year and one half to figure out out how to correlate Sense against my utility’s revenue meter and Sense has generally been within 3% of my revenue meter, on an hourly basis except for dropouts hours and when I was experiencing pin corrosion issues that Sense detected and rectified for me.

https://community.sense.com/t/does-anybody-have-any-cool-graphs-or-analytics-using-sense-data-please-share/3302/38

ps: Hourly comparison has proved easier than billing cycle comparison for me, because it’s a bit painful to breakup export data into billing cycle ranges (so your custom range suggestion is appreciated)

1 Like

On the app usage page and looking at any of the options
for day, week, month or year it gives you a monetary cost
but doesn’t give KWH. How hard would it be to have that
show. The app has just multiplied cost per KWH by usage
so all the information is there.
I’d like to see totals of KWH. that’s what I’m watching.

We got smart meters but they only share data down to the daily total.
They told me they have the capabilities for detailed information but
said I’m then only person that has asked about it.
They offer flat rate service by KWH or time of day (on peak. off peak)
I’m getting ready to switch to time of day ad they told me I would be the
first although it’s been an option for years. They also said it could take
a couple months because they don’t even know how to do it yet.
That’s rural Kentucky for you.
I grew up in Phoenix and we had this kind of time of day service 30
years ago and not by choice. We also had load controllers that would
shut appliances down if using too much during times of high demand.
The electric company is now offering a one time $25 credit if they can
install a controller on my water heater and another for my heat pump.
No thanks! If I am paying for it then I’ll make the decisions.

1 Like

Take a look at my Usage screen above. If you click on one of the entries on the bottom, like Usage or Solar, etc., the app will give both $ and kWh, but just for that entry. Tap another and you can see both for that entry.

On my screen, Usage shows both, all others just cost.

1 Like

Oh he’s, I see that now, thank you @kevin1

My interest in KWH is mainly for bill and some day to day for weekend vs weekday.
That something I don’t care for, the lack of a manual that I feel should come with sense. They just want you to get it hooked up and have 16 pages to describe a one paragraph procedure.

Looks like you figured out what you were trying to do, but Custom Date Ranges are a great idea for the Web App in general. Personally, I’d make use of this. Curious what others think.

4 Likes

I agree, a custom date range would be more helpful than the neutered “Bill” (billing period function). But I’m sure it comes with additional complications in terms of what actual time increments are used for the bar charts, etc. I think Mint and Quicken have good user models for more generalized reporting where you can select date range, bar chart increment, plus select all or only certain categories or user-defined tags for display the graph.

2 Likes

You probably right @kevin1I’m sure there is much more to it than
I’m thinking. I also use Mint and that is exactly what I’m talking
about in specifying date ranges.
The product wishlist is neverending. I have a heated floor I’m trying
to calculated cost of use on. When it was first detected it reported
and tagged for several days without fail. Like the rest of my devices,
things went straight downhill after the last update,
If there was a notification for a sudden jump or drop in used watts then I
could figure it out even without detection.
If I could set it to say 500 watts and if there was that drop or jump then I
could go see if the floor turned on or off. So if I had the on notification
and the off notification then could easily calculate total time with KWh.
Probably wouldn’t draw much interest and they have enough “wishes”
to work with already.

I deleted the floor today. My first deleted device. Is there a support
group?