Question

Add WK before Week Number

  • 9 June 2022
  • 3 replies
  • 50 views

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


3 replies

Userlevel 7
Badge +1

Have you tried creating a Custom Dimension and do

concat(“WK”, ${field_week_of_year})

 

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.

 

Userlevel 7
Badge +1

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

Reply