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?
Userlevel 2
Hi
Have a look here: https://docs.looker.com/exploring-data/visualizing-query-results/column-options#y_axis_format
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.
Userlevel 2
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.