Beware that row id 6655 isn't correct (total_kwh is suddenly decreasing). This inconsistancy maybe related to row 6654 missing: manipulated data? So you'd have to sanitize your data first.
ID TIMESTAMP TOTAL_KWH 6653 2019-08-06 22:23:26.000 1494.00 6655 2019-07-30 22:32:26.000 150.00 <-- 6656 2019-08-07 18:58:17.000 1673.90 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
