Folks,
I thought this would be a very simple task but am struggling. I have a pivot table that looks like the following:
I want to be able to center the formatted dates for each column without impacting the values of the column as I need them to be right justified.
Here is the LookML for the attributes.
dimension_group: date_data {
type: time
timeframes: [raw, date, week, month, quarter, year]
convert_tz: no
datatype: date
sql: ${TABLE}.date_data ;;
}
dimension: formatted_date_data {
type: string
sql: FORMAT_DATE('%m/%d/%Y',${TABLE}.date_data) ;;
}
As a bonus, I would also like the values of the measures (names in column 1) be left justified.
I thought this could all be down by editing the series in the visualization but the selection of left, center, or right justify updates the row names and the values in the columns.
HELP!
Folks,
I tried this approach in the LookML:
Here are the results.
Any other suggestions?