redash is rounding numeric/float results to two decimal places?

[astewart-twist]

I think redash is forcing floats/numerics in query results to two decimal places? The following example should be returning division results to 10 decimal places.

https://demo.redash.io/queries/659/source

Is there a way to override this?

[arikfr]

Unfortunately there is no way. I'm hoping to add options for the table visualization, that will allow overriding this and some other options. But that currently only in the planning phase.

[astewart-twist]

Glad to know I'm not going crazy on the SQL side at least :) Could you point me to where in the code that rounding is happening? I may try to patch a copy for myself. That or just use percentages.

[arikfr]

It's this line:
https://github.com/EverythingMe/redash/blob/master/rd_ui/app/scripts/visualizations/table.js#L71

[jvyduna]

We use a temporary hack for this - casting to string. For MySQL:

2 decimals shown:
SELECT ROUND(1/9,10);

10 decimals shown:
SELECT CAST(ROUND(1/9,10) AS CHAR);

[arikfr]

Configuration for table visualization

[arikfr]

Closing in favor of #1356.