4 Replies Latest reply: Mar 3, 2017 1:12 AM by Chanty 4u RSS

    Week Number Issue

    Chanty 4u

      Hi All,

      Tresesco B

      Settu Periyasamy

      Henric Cronström

      adam davies

      Sunny Talwar

      Marco Wedel

      I am facing one issue regarding Week Number's are missing  like  below

      week filter: 1 to 52 weeks  it is showing

       

      but in all charts its missing only 48,49 week's only .....

      Note: for 48,49 weeks data is available still it is not showing

       

      exp used: Count({<$(vSelectedYearWeek)>} if(ClosedYearWeek=YearWeek,[INumber]))

       

      Variable: YearWeek= {">=$(=FirstSortedValue(Distinct YearWeek,-YearWeek,12)) <=$(=Max(YearWeek))"}