Pivot Table: If a value in a cell is NULL and has a Suffix it will display in the table as "null Suffix" #42867
Labels
.Frontend
Priority:P3
Cosmetic bugs, minor bugs with a clear workaround
.Team/DashViz
Dashboard and Viz team
Type:Bug
Product defects
Visualization/Tables
Raw, summarized, and pivoted tables
Describe the bug
If a pivot table has a cell with a NULL value it displays an empty cell in the visualization unless a suffix has been configured. In that case it displays "null" with the suffix appended on the end.
Without suffix:
With Suffix:
To Reproduce
(SELECT
"PUBLIC"."PRODUCTS"."ID" AS "ID",
"PUBLIC"."PRODUCTS"."EAN" AS "EAN",
"PUBLIC"."PRODUCTS"."TITLE" AS "TITLE",
"PUBLIC"."PRODUCTS"."CATEGORY" AS "CATEGORY",
"PUBLIC"."PRODUCTS"."VENDOR" AS "VENDOR",
"PUBLIC"."PRODUCTS"."PRICE" AS "PRICE",
"PUBLIC"."PRODUCTS"."RATING" AS "RATING",
"PUBLIC"."PRODUCTS"."CREATED_AT" AS "CREATED_AT"
FROM
"PUBLIC"."PRODUCTS"
where "PUBLIC"."PRODUCTS"."CATEGORY" <> 'Gizmo'
LIMIT 50)
union all
( SELECT
"PUBLIC"."PRODUCTS"."ID" AS "ID",
"PUBLIC"."PRODUCTS"."EAN" AS "EAN",
"PUBLIC"."PRODUCTS"."TITLE" AS "TITLE",
"PUBLIC"."PRODUCTS"."CATEGORY" AS "CATEGORY",
"PUBLIC"."PRODUCTS"."VENDOR" AS "VENDOR",
null AS "PRICE",
"PUBLIC"."PRODUCTS"."RATING" AS "RATING",
"PUBLIC"."PRODUCTS"."CREATED_AT" AS "CREATED_AT"
FROM
"PUBLIC"."PRODUCTS"
LIMIT 50)
Expected behavior
The cell should still be empty
Logs
No response
Information about your Metabase installation
Severity
It's not pretty
Additional context
No response
The text was updated successfully, but these errors were encountered: