Hello. I have 2 SQL questions which separately work great in a line chart, but when I add one to the other the dates get messed up going as far as 1970. Any help would be greatly appreciated.
Hi @komsinica
Please post “Diagnostic Info” from Admin > Troubleshooting.
It would help a lot to see the table for both questions as to better understand what’s going on and to reproduce.
Could it be that you have a result, which is null, which is then converted to epoch starting time?
@komsinica Try ordering by date on both questions - perhaps it’s some combination of mixed ordering and irregular intervals that causes problems. I cannot reproduce.