Replies posted by Pieter_DeVries
Why can't I access chat?Knowledge Drop
Updating this to address Looker Version updates.From our docs here.Who can access Looker Support?Looker Support is available to administrators and developers on your Looker instance. This allows us to focus on your most involved users, who may need in-depth help with the Looker product. You should develop your own internal process for helping your users, especially because you'll know the ins and outs of your data better than anyone.Chat support is available on Looker instances that are running an officially supported Looker version. Looker-hosted instances automatically update to supported releases. If your Looker instance is customer-hosted, and running an unsupported Looker version, update your Looker instance to a supported Looker version to gain access to chat support.In the supported releases page it shows that we currently support 22.0, however check that page for the currently supported versions as it will change naturally as we push out new versions.
@Pieter_DeVries On a surface level this seems to work but showing value labels in, for example, a line chart still does not use the proper formats. Is there a way to get that done as well? I get the impression that right now Looker just can’t do proper number formatting all to the end. :/ Hi @LukasM, unfortunately you are correct for the value label, as shown below.In the case of using value labels, we need to edit the value format for the visualization, and it is closer to the lookml value format, so like this;The logic here being,[>1000000]$#,,"M";$#,"K"If larger than 1million, then truncate 2 commas worth of data and add a M to the end, if not then truncate 1 comma worth of data and add a K.Because this is basically the same as value_format the maximum amount of logic is 2 ifs and an else.
What is your name? Pieter deVries What is your job title and industry? DCL at Looker! How long have you used Looker? Just over a year :) Trailing or Leading commas in your SQL queries? Trailing looks sexy but leading is better for commenting out! What’s the 1 Looker/Data related subject that you’d consider yourself an expert on and would love to help others with? Table Calcs! (optional) Any other info about yourself that you’d like to include… I have two cats, and they are cute.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.