Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
Thank for your quick response.
Yes. Correct. I want to format a single measure conditionally based on a dimension. For example the record type is A display the measure value as integer else display the measure as a decimal value.
I see that currently not all of the possible values are being displayed in the filter dropdown in case if the corresponding database field to which the filter is mapped to has more values (like for example 1000 values)…Looker filter is currently pulling only few of them may be a 100 or so (but i’m able to search for missing values and i see them)…is there anyway that i can have Looker filter on the dashboard display ALL of the possible values from the database field instead of just limiting to some values (like 100) ? Appreciate your help here.
Is there any way to conditionally specify the “Value format” based on the dimension? For example if i will need to display the counts based on a specific record type as Whole number(0) and decimal (0.00) based on another dimension. How can i refer to the "Value format " option in HTML tag to conditionally do this based on dimension value is my question. Appreciate your help.
Can you please let us know if this Tool tip functionality for Dimensions is now available/ will be available in a future release?
Thank you all for your help 🙂
Yes I’m using pivot on a column. Also I’m using type of count_distinct. Whenever there are no records for specific category in pivot column, i see that the count is displayed as phi symbol instead of zero. In my case I want the count to be displayed as 0 if there are no records for that pivot category instead displaying a phi symbol. Any way to display 0 in this scenario?
Hi…i see that Looker is not defaulting NULL values in Sum to 0. I still see the ‘Phi’ symbol. Is there any way that i can override this behavior so that i can display 0 instead of Phi?
Already have an account? Login
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.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
