Forum Discussion

Milozebre's avatar
Milozebre
Helper V
8 years ago
Solved

Week Number is INCORRECT

Good morning Community,    I have a problem with the week numbers. As you see, I see some measure for week 44 and we are in week 33.   SQL :  ,datepart(ww,A.D_CLOTTECH) AS WEEK_CLOTTECH    I ...
Need Help
  • Milozebre's avatar
    Milozebre
    8 years ago

    Hello Lydia, 

     

    Sorry for the delay.

    I found the solution.

     

    here is the line in my query for the weeknumber : 

    ,datepart(ww,A.D_CLOTTECH) AS WEEK_CLOTTECH

     

    I look in internet and i found some solution and the easyer is change something in my query : change ww to ISO_WEEK

    ,datepart(ISO_WEEK,A.D_CLOTTECH) AS WEEK_CLOTTECH

     

    Now, its working :) 

     

    Thank you 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Milozebre,

Please share me the exported excel file and explain that what fields you use to create the visual.

Regards,
Lydia

Milozebre's avatar
Milozebre
Helper V
8 years ago

Hello Lydia, 

 

Sorry for the delay.

I found the solution.

 

here is the line in my query for the weeknumber : 

,datepart(ww,A.D_CLOTTECH) AS WEEK_CLOTTECH

 

I look in internet and i found some solution and the easyer is change something in my query : change ww to ISO_WEEK

,datepart(ISO_WEEK,A.D_CLOTTECH) AS WEEK_CLOTTECH

 

Now, its working :) 

 

Thank you