Scientific notation with n significant figures in table calc

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

Last tested: Oct 25, 2018

You can replace n with the number of sig figs in this formula:

concat(round(${view_name.field_name}/power(10, floor(log(${view_name.field_name}))), n-1), " x 10^", floor(log(${view_name.field_name})))

Example with n=2:

concat(round(${orders.count}/power(10, floor(log(${orders.count}))), 1), " x 10^", floor(log(${orders.count})))