Hey,
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.’
Any pointers?
Cheers
Will