[Lizmap] Dataviz problem

[Immo Blecher]

Hi Everyone,

I have a weird Dataviz problem: I am using a PostgreSQL view to extract 
data from a database with Date/Time as X-axis and different values on 
y-axis. So basically ID, sitenr, date, value fields. The Dataviz charts 
work perfectly, but: as soon as I add a join with other tables to add 
additional fields, the charts stop working.

Is it supposed to work like that? Are joins not allowed for the charts 
to keep working? Or what must I do to keep the charts working?

Setup:

Linux server with PostgreSQL and QGIS 3.16 LTR, Lizmap 3.5 RC2, QGIS 
3.16 LTR desktop on Ubuntu 20.04

Thanks

-- 

*Immo F. Blecher**
*/*Mobile:*///+27 83 272 6791 |+491512639 6176
*Email:*_immo at blecher.co.za_ <mailto:immo at blecher.co.za> | 
_immob19 at gmail.com_ <mailto:immob19 at gmail.com>
*Internet:*_https://www.blecher.co.za/_ <https://www.blecher.co.za/>

Please consider your environmental responsibility. Before printing this 
e-mail message, ask yourself whether you really need a hard copy.

*IMPORTANT*: The contents of this email and any attachments are 
confidential. They are intended for the named recipient(s) only. If you 
have received this email by mistake, please notify the sender 
immediately and do not disclose the contents to anyone or make copies 
thereof.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20210923/69720c97/attachment.html>