Question

Showing values

  • 11 December 2017
  • 3 replies
  • 850 views

I am having data like 5,200,000; 1,590,000,000; 2,500 is there any way to show this data as 5.2 M; 1.5 B; 2.5K in visualisation?


3 replies

Userlevel 2

Hi @Swapnil_Pimple,


Looker uses spreadsheet format codes which can be found here here. I don’t think you can get exactly what you are asking but you can do something very close




Hope this helps,


Sasha

Thanks for response.

I also wanted display B for billion, M for million, k for Thousands after number.

Userlevel 3
Badge

Hey @Swapnil_Pimple, I think this article may be what you look for:



This shows how to use the value_format parameter to change based on the underlying values of your data.


eg:

value_format: "[>=1000000]$0.00,,\"M\";[>=1000]$0.00,\"K\";$0.00"

Reply