How to Change the Date format to Sep - 2022

I copied and pasted the code into my LookML from this support page and put in my timestamp field. It does not return the same output in the screenshots. Is this support page out-of-date?

# My original dimension group
dimension_group: created {
hidden: yes
type: time
timeframes: [date,week,month]
sql: ${TABLE}.created_at ;;
}

# My customized timeframes, added under the group "Created"
dimension: date_formatted {
group_label: "Created" label: "Date"
sql: ${created_date} ;;
html: {% verbatim %}{{ rendered_value | date: "%b %d, %y" }};;
}

dimension: week_formatted {
group_label: "Created" label: "Week"
sql: ${created_week} ;;
html: {{ rendered_value | date: "Week %U (%b %d)" }};;
}

dimension: month_formatted {
group_label: "Created" label: "Month"
sql: ${created_month} ;;
html: {{ rendered_value | append: "-01" | date: "%B %Y" }};;
}

Here is my output:

4058ee98-40c4-4222-9ddd-af77e90e9848.png

https://cloud.google.com/looker/docs/best-practices/how-to-use-liquid-to-format-dates

In LookML, how I can keep the date sort ordering by render the date as “Mon-Year” i.e.) “Sep-2022”?

0 1 279
1 REPLY 1

Dawid
Participant V

they doon’t really explain where this {% verbatim %} tag comes from - have you tried removing it?

Top Labels in this Space
Top Solution Authors