Redash: Table displays empty/null numeric values as zeroes

Created on 29 Mar 2018  路  3Comments  路  Source: getredash/redash

Issue Summary

The table visualization in version 4.0 displays empty/null values in numeric fields as zeroes. This is potentially bad because a null value can mean something very different than a zero value in certain contexts.

Steps to Reproduce

  1. Run a query that returns null or empty values in a numeric field

Expected Results

The value should be displayed as empty, or null.

Actual Results

The value is displayed as 0.0.

Technical details:

  • Redash Version: pre-beta 4.0.0
  • Browser/OS: Chrome/Mac
  • How did you install Redash: script on Ubuntu
UX Visualizations

Most helpful comment

Looks like this could be addressed by adding n.nullFormat('-') on or around this line. Would be willing to do a PR with this change.

All 3 comments

Looks like this could be addressed by adding n.nullFormat('-') on or around this line. Would be willing to do a PR with this change.

@chriszs maybe just n.nullFormat('') to remain backward compatible? And a PR will be mostly welcomed. 馃憤

I seem to be having this problem as well:

Containers:
redash:7.0.0.b18042

Is this still an issue?

Was this page helpful?
0 / 5 - 0 ratings