Currency Conversion Parameter and Formatting
It’s common to want to switch between currencies in Looker. This is usually achieved by having your results/ta...
Forum Posts
Custom field formats with and without commas
I accidentally added two “identical” custom fields using the three dots to the right of an String field → Aggr...
Converting String to Date
dimension: ticket_start_date{ type: date_time sql: cast(${TABLE}.start as timestamp);;I’ve tried using the fun...
Dynamic named_value_Format
is there anyway to make this code work from this thread: https://community.looker.com/lookml-5/dynamic-value-f...
Decimal
Hi, is there a Looker formatting option that excludes decimals numbers and does not round the result?For examp...
Remove scientific notation for ID fields
Hi, I came across a field that are unique identifiers that have both characters and digits like this: 201220Z0...
Change Value format display in bps
Hi,I want to customize value format to be display in bps. For example, 0.0123 will be displayed as 123 bps. Is...
Date filtering formatting
When I select timeframe filter in dashboards, the date displayed here in the filter is in the format: YYYY/MM/...
How to set default date format?
I have the following dimension group for dates. Currently, the default dates that appear on charts are 2021-07...
Value Format Name validation issue
Hi,I have added a named_value_format in my model:named_value_format: gbp_with_comma { value_format: "\"£\"#,##...
Any plans for a Prettier plugin?
Prettier would really help to achieve consistent formatting.
What is the value_format of negative percent?
I have a measure which would turn out to be a percentage of negative values e.g. -40%. The value_format I put ...
Date formatting
Hi,How to change the date format from ‘02-jan-20’ to ‘2020-01-02’ in the dimension?