Hi Chris, You may assign value_format or value_format_name to dimensions to format Looker cells using built-in or custom format names. Once those are applied in the view file, they should appear on the front-end. Cheers, Sami

Hi Conor, Anika wrote a great post on this question here: Max or Min Date Measure In short, we end up taking the raw timeframe and making a measure of type: date and putting the MAX() in the sql parameter. Cheers, Sami

Hi, Adapted the block for redshift. filter: date_filter { description: "Use this date filter in combination with the timeframes dimension for dynamic date filtering" type: date } dimension_group: filter_start_date { type: time timeframes: [raw,date] ...

Hi Mark, The correct syntax for Postgres would be the following: view: test_interval { dimension: current_date { type: date sql: NOW() ;; } parameter: date_type { type: string } parameter: period_length { type: number } dimension: both { type: date s...

Hi Mark, Thanks for that! To better help you with the issue, may I see the the entire code for the parameters you have defined to use in the given SQL? Also, if you could provide me with the SQL generated that would be very helpful. I’m thinking that...