nipunn1313 commented on issue #2110:
URL:
https://github.com/apache/incubator-superset/issues/2110#issuecomment-746526464
Hi - I've continued to notice this issue in Dec 2020. I made a line chart
with a group-by and the NULL values aren't represented as data points. When I
poke at the query created - I see this
```
SELECT "git_wrapper_version" AS "git_wrapper_version",
date_trunc('day', CAST("day" AS TIMESTAMP)) AS "__timestamp",
COUNT(*) AS "count"
FROM "default"."pal_git_wrapper_metrics"
WHERE "day" >= '2020-12-09'
AND "day" < '2020-12-16'
GROUP BY "git_wrapper_version",
date_trunc('day', CAST("day" AS TIMESTAMP))
ORDER BY "count" DESC
LIMIT 50000;
```
But I don't see a line in the resulting graph for when git_wrapper_version =
NULL.
Note that the following slightly different query w/o a GROUPBY does show a
line. The moment you add git_wrapper_version to the group-by the null line goes
away.
```
SELECT date_trunc('day', CAST("day" AS TIMESTAMP)) AS "__timestamp",
COUNT(*) AS "count"
FROM "default"."pal_git_wrapper_metrics"
WHERE "day" >= '2020-12-09'
AND "day" < '2020-12-16'
AND "git_wrapper_version" IS NULL
GROUP BY date_trunc('day', CAST("day" AS TIMESTAMP))
ORDER BY "count" DESC
LIMIT 50000;
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
