Forum Discussion

CNH's avatar
CNH
Helper I
8 years ago
Solved

Fiscal year - Area Chart, by Week

  The aforemention is an area chart that deplicts data by week number.   However as the data is for a Fiscal year beginning in July, the use of week number is not correct, ie data for January ...
Need Help
  • CNH's avatar
    CNH
    8 years ago

    After further research I have found a solution to my problem by cresting a "Week Ending Column" by  using this formula

     

    Dates[Date]+(7-Dates[*** Weekday Number])

     

     

    This achieves the outcome I am after. A bit of perserverance pays off :smileyhappy:

CNH's avatar
CNH
Helper I
8 years ago

I have progressed on this issue with the creation of a new column as follows:

WeekYearOrder = Year([Date])*100 + WEEKNUM([Date],2).

 

This produces the following chart. The issue is that the chart is inserting in a range covering 201754 to 201800 which produces the erroneous flat line in the following chart.

 

 

Any advice on  how to eliminate this would be welcome.

 

Alternatively is there another way to approach this issue.

CNH's avatar
CNH
Helper I
8 years ago

After further research I have found a solution to my problem by cresting a "Week Ending Column" by  using this formula

 

Dates[Date]+(7-Dates[*** Weekday Number])

 

 

This achieves the outcome I am after. A bit of perserverance pays off :smileyhappy: