search

rilldata / rill

Rill is a tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. BI-as-code.
https://www.rilldata.com
Apache License 2.0
1.73k stars 117 forks source link

feat: big num new formatting rules #6106

Closed djbarnwal closed 23 hours ago

djbarnwal commented 1 day ago

Format big numbers based on https://www.notion.so/rilldata/Formatting-the-display-of-metrics-for-higher-precision-in-tables-and-other-contexts-28371608b0924fd99be243110b12f32c?pvs=4#12fba33c8f5780c18ac5e89fbbf2853e

Ex - image

djbarnwal commented 1 day ago

I am a bit conflicted on this because something like 10^(-20) is very different that let's say 10^(-5) but both would be then represented as "<0.0001". The context behind these big numbers is important but I would say it's a safer choice to show exponential formatting for extremely large and extremely small numbers. I will update this Order of magnitude to 10^(-10) for showing exponents for getting this PR out for the release. In the meanwhile we can discuss offline what limit/rules make more sense.