I have a measure of date time which I would like to format as a time within a chart.
Here you see my measure 🙂
I have been referencing the material on time formatting for charts https://docs.looker.com/exploring-data/visualizing-query-results/time-formatting-for-charts.
From what I understand I should be able to use “%H:%M:%S” to return only HH:MM:SS of my date-time measure, however when I try this I receive the below message:
'Invalid Format String
Format strings follow standard spreadsheet format using ECMA-376 spreadsheet format codes.’