This trick worked by using an expression in the SQL SELECT statement. Unfortunately, that ability got lost in V4.0.
Nevertheless, there's no good reason why it should not be allowed. Commit e76e374 <https://github.com/weewx/weewx/commit/e76e374595fe9a8cbaf3adc85ca7513f9a393f5c> brings this ability back. Give it a try. Swap your version of xtypes.py (probably located in either /usr/share/weewx/weewx/xtypes.py or /home/weewx/bin/weewx/xtypes.py) with this one <https://raw.githubusercontent.com/weewx/weewx/master/bin/weewx/xtypes.py>. Let me know how it goes. -tk On Mon, May 18, 2020 at 12:31 PM Mic G77 <micg77...@gmail.com> wrote: > Hello, > > Last weekend, I moved from weewx3.8 to weewx4.0 and I'm not any more able > to produce graph with data calculated from the database. > If someone can help.... > > Thank you in advance. > > > > > Le mardi 4 juin 2019 23:31:52 UTC+2, Thomas Keffer a écrit : >> >> That is very clever! It occurs to me you could probably combine SQL data >> types. It doesn’t have to be just one type. >> >> On Tue, Jun 4, 2019 at 1:03 PM Mic G77 <micg...@gmail.com> wrote: >> >>> Hello, >>> i've been looking for a way to produce graph with data calculated from >>> the database. >>> I Finally find a solution. So I share it with you. >>> >>> This is an exemple : >>> >>> [[[dayPoid]]] >>> yscale = None, None, None >>> [[[[extraTemp2]]]] >>> [[[[extraTest]]]] >>> data_type = 18.3+0.03*extraHumid2 >>> >>> In this case, i'm able to see a graph of the function : 18.3 >>> +0.03extraHumid2. >>> I hope it could help. >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "weewx-user" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to weewx...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/5689249a-ef2b-4c38-ad2a-72a1a2b643dc%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/5689249a-ef2b-4c38-ad2a-72a1a2b643dc%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> -tk >> > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/eab7c178-93f5-4ccc-accc-d83c818a285b%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/eab7c178-93f5-4ccc-accc-d83c818a285b%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDmQV8oJ38GPqewyMc_pmOKxDczEfCSfVz38ZjmRLHLw%40mail.gmail.com.
