CODEWITHSUNDEEP
looker-studio
ALi Raza Darr
ALi Raza Darr

Reputation: 169

Looker showing different view to different users - Not showing compact data

I have a dashboard for my team which shows me the correct view with compact numbers: enter image description here

But to some of my team members, it does not show the compact numbers. enter image description here

Can someone know how I can fix that so it always show the compact numbers to all the users?

Thank you so much!

Upvotes: 0

Views: 44

Answers (1)

Max_Stone
Max_Stone

Reputation: 659

Nucci is right, it is to do with user settings. These can be a pain to sort out because you need to get the user to change there settings. To get round this I would convert the number to text, that way it will not be impacted by local number settings.

Something like this should do the trick.

CASE
  WHEN Value >= 1000000 THEN CONCAT(ROUND(Value / 1000000, 1), "m")
  WHEN Value >= 1000 THEN CONCAT(ROUND(Value / 1000, 1), "k")
  ELSE CAST(Value AS STRING)
END

Upvotes: 1

Related Questions