search

Yadoms / yadoms

Yadoms is open source, simple, powerfull, flexible and multiplatforms domotic solution.
https://www.yadoms.com
Other
63 stars 17 forks source link

Widget chart : daylight saving time in cumulative display #209

Open jmberhault opened 7 years ago

jmberhault commented 7 years ago

The daylight saving is +1 hour. In cumulative display, the first hour after the jump, take the two hours delta.

changement d heure

jmberhault commented 7 years ago

The trouble come from the historization side. You will find below an extract of the databae :

"date" "keywordId" "value" "20170326T015959.703769" "27" "7274433" "20170326T015959.703769" "28" "1" "20170326T015959.703769" "29" "AllHours" "20170326T015959.703769" "30" "290" "20170326T030002.340518" "27" "7274433" "20170326T030002.340518" "28" "1" "20170326T030002.340518" "29" "AllHours" "20170326T030002.340518" "30" "290"

jmberhault commented 7 years ago

An extract of the summary table, we could see the gap :

image

sgallou commented 7 years ago

I think database is correct. In local hour (what we are working with, and what is expected by user), in the first case 2:00 doesn't exist and in the second case 2:00 exist 2 times. I don't know how to do exactly, but I think that the chart must be adapted to take account of this specific behavior. Or as temporary workaround, just remove the bad data. Maybe a solution already exists in the highchart library ?