If your chart has a time dimension on the x-axis, you can change the formatting of the x-axis label by using the Time Label Formatsetting in the Xtab of the visualization options.
Time label expressions
You can format time values in Looker charts by using the syntax in the following table.
Format Type
Description
Expression
Time
Time
Milliseconds as a decimal number: 000 to 999
%L
Time
Second as a two-digit number: 00 to 59
%S
Time
Minute as a two-digit number: 00 to 59
%M
Time
Hour as a decimal number (24-hour clock): 00 to 23
%H
Time
Hour as a decimal number (12-hour clock): 01 to 12
%I
Time
Either AM or PM
%p
Date
Date
Day of the year as a decimal number: 001 to 366
%j
Date
Zero-padded day of the month: 01 to 31
%d
Date
Space-padded day of the month (equivalent to
%_d
): 1 to 31%e
Date
Full weekday name: Monday, Tuesday, Wednesday
%A
Date
Abbreviated weekday name (3-letter): Mon, Tue, Wed
%a
Date
Weekday as a decimal number (Sunday as the first day of the week): 0 to 6
%w
Week
Week
Week number of the year (Sunday as the first day of the week) as a two-digit number: 00 to 53
Note
: %U
uses the ISO week date
standard offset by one day.
%U
Week
Week number of the year (Monday as the first day of the week) as a two-digit number: 00 to 53
Note
: %W
uses the ISO week date
standard.
%W
Month
Month
Two-digit month: 01 through 12 (1-12 format not supported)
%m
Month
Abbreviated month name: Jan, Feb, Mar
%b
Month
Full month name: January, February, March
%B
Year
Year
Two-digit year: 00 to 99
%y
Year
Four-digit year: 2000, 2001, 2002
%Y
Combination
Combination
Full time, of the form "%H:%M:%S": 23:56:12
%X
Combination
Full date, of the form "%m/%d/%Y": 01/27/2014
%x
Combination
Datetime format with the following: "%a %b %e %H:%M:%S %Y": Mon Jan 1 23:56:04 2014
%c
Examples
You can combine expressions together to create custom time formats, such as in the examples in the following table.
| Input | Time Label Format | Output |
|---|---|---|
|
August 14, 2014 10:31 PM
|
%b '%y, %H:%M
|
Aug '14, 22:31 |
|
August 14, 2014 10:31 PM
|
%B %Y, %I:%M %p
|
August 2014, 10:31 PM |
|
August 14, 2014 10:31 PM
|
%x %X
|
08/14/2014 22:31:00 |
|
August 14, 2014 10:31 PM
|
%I:%M:%S %p
|
10:31:00 PM |
