Add WK before Week Number

Looker Q&A Looker
1

Hi Team,

I am having week number column which is part of date dimension as 1,2,…. 52.

Now my requirement is to add WK as prefix before weeknumber.

Week : 1, 2, 3, …. 52 and i am looking for Week: WK01,WK02…..WK52.

Could you please suggest on the above requirement.

Thanks,

Pavan

2

Have you tried creating a Custom Dimension and do

concat(“WK”, ${field_week_of_year})
3

I tried the one you mentioned, but no use.

Actually I am using the column in parameter , so how i should achieve this in parameter.

4

I don’t really know without seeing your code. You didn’t mention parameter before. What are you trying to do?