Can we have the Y axis scale abbreviated?

[thedataguy]

Hi,

My Y axes are usually in billions, and often requires me to verbally say it in presentation without having people count the tiny zeroes. Any chance we can abbreviate it in looker directly?

[David_P1]

Hi @thedataguy,

Have a look here: https://docs.looker.com/exploring-data/visualizing-query-results/column-options#y_axis_format

[thedataguy]

Hi David, this doesn't help as my data fluctuates between Millions and Billions. Hard coding wouldn’t be the best practice for my dashboard unfortunately. Pretty shocked that Looker doesn’t have this by default.

[David_P1]

The custom format follows the excel formatting, you can try something like this:

 [<999950000]0.0,, "M";0.0,,, "B"

and then it would automatically adjust to both million and billion values