Question

Plotting a Datetime Measure - Value Format Datetime to Time on chart

  • 7 September 2018
  • 1 reply
  • 142 views

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


1 reply

Hi @willbaker


I’d like to know more details on this issue, what database are you using and what Looker Version are you currently working on? Could you possibly email these details to help.looker.com or come to our chat support for a quick response?


Best,

Sara

Reply