(Q)charting sql query with null(s)
-
While (line-)charting a sql query (a sample output as below, to give you an idea of what the query looks like) with qchart, I have noticed that when the query output contains null value (in bid_vwap column), the qchart plots nothing. What are the ways to deal with such issue? If possible, I'd like qchart to charting non-nulls and skip charting nulls.
min | bid_vwap---------------------+------------------------
2010-07-01 00:00:00 | 0.84670294117647058824