Add WK before Week Number

Pa11
Participant I

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

0 3 293
3 REPLIES 3

Dawid
Participant V

Have you tried creating a Custom Dimension and do

concat(“WK”, ${field_week_of_year})

Pa11
Participant I

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.

Dawid
Participant V

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

Top Labels in this Space
Top Solution Authors