Forum Discussion

YuanG's avatar
YuanG
Icon for Helper I rankHelper I
10 years ago
Solved

Show data by week number

  Hi Everyone,   I'm working on a line chart with some data calcul by week ,and i want the data not show  in format dd/mm/yyyy, but with the number of weeks in year. Like this chart, in 27 June 20...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Not quite clear on the issue but you can create a week number from a date field using a calculated column such as:

 

WeekNum = WEEKNUM([Date])

Then you can create a column like:

 

Week = "Week " & [WeekNum]

Set your sort by for this column to the "WeekNum" column and then use the "Week" column in you Axis.

 

 

  • sxlubinoff's avatar
    sxlubinoff
    Regular Visitor
    9 years ago
    I follow what you advised below, however, what if I have data from different years?? Sort I have been trying is not working ..for example : I have 2016- (WK)51 /2016-(WK)52 / 2017-(WK)1 / 2017-(WK)2 ...as soon I uploaded 2017- (WK)10 problems started.. Now the sort is showing : 2016-51 / 2016-52 / 2017-1 /2017-10 / 2017-2.... Would you please advise how to resolve it ?
  • YuanG's avatar
    YuanG
    Icon for Helper I rankHelper I
    10 years ago

    Hi Greg_Deckler

     

    First of all, thanks for the reponse.

    With the column Week, when i creat a line chart, it will not in the right ordre, i've try to make the week number in type character, but it not works, so do you know how can i do with this?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      10 years ago

      YuanG - Select your Week column to have a "Sort By" of your WeekNum column.

      • YuanG's avatar
        YuanG
        Icon for Helper I rankHelper I
        10 years ago

        Greg_Deckler

         

        i've try with the sort by, it's not correct neither, and the order is weird

         

  • sxlubinoff's avatar
    sxlubinoff
    Regular Visitor
    9 years ago

    Hello,

     

    Hope you can help me.

    What if I need to sort weeks from different years ?

     

    Example _

     

    2016 (WK) 51- 2016 (WK) 52 - 2017 (WK) 1 - 2017 ( WK) 2 ) ...Sort problems started when I upload data for 2017 (WK )10 

     

    Now sort is showing as below :

     

    201651 -201652 - 201701-201710-20172-20173-20174 ....

     

    Hope you can help me to resolve it ..I tried everything..!!

    • cmonnette's avatar
      cmonnette
      New Member
      9 years ago

      Have you been able to resolve this? I am having the same issue sorting weeknumbers across multiple years.

       

       

    • cmonnette's avatar
      cmonnette
      New Member
      9 years ago

      Have you been able to resolve this? I am having the same issue sorting weeknumbers across multiple years.

       

       

      • cmonnette's avatar
        cmonnette
        New Member
        9 years ago

        I was able to resolve this by adding the following column to my data table and then sorting in default order.

         

        "WorkWeek",  YEAR([date]) &  format(WEEKNUM ( [Date] ),"00")