yadoms icon indicating copy to clipboard operation
yadoms copied to clipboard

Published 20 hours ago • verified publisher icon Yadoms

Widget chart : daylight saving time in cumulative display

Open jmberhault opened this issue 7 years ago • 3 comments

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

changement d heure

jmberhault avatar Mar 26 '17 19:03 jmberhault

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 avatar Mar 28 '17 06:03 jmberhault

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

image

jmberhault avatar Mar 28 '17 07:03 jmberhault

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 ?

sgallou avatar Oct 04 '17 21:10 sgallou