Customizing Column Headers

Looker Q&A Looker
,
1

We have a column where the title needs to read Date of Service vs Date of Service Date.

The BI Programmer stated that there is a problem with date dimensions specifically, they stick the word of the specific timeframe you are using at the end. So if we want to show Week of Service it will show “Week of Service Week”.

Please advise if there is a fix for this - or, how to customize the column headers that include any reference to “week”, “day’, “month”.

Thank you,

2

Hi,

Suggesting 2 options for your query.

  1. Try setting a label to your date dimension_group as ‘Service frequency’ or just keep as ‘Service’. The values should then appear as

Service frequency date / Service frequency month / Service frequency week OR Service date / Service month / Service week.

  1. Create 3 separate date_time dimension. One for each frequency. Here every dimension can hold the exact label like

Date of Service / Month of Service / Week of Service