Forum Discussion
Fiscal year - Area Chart, by Week
Area Chart by Weeknumber
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 – May 2018 is showing before the data from July – December 2017
I have created week numbers as follows - Week Number = WEEKNUM([Date],2)
My questions are:
1. How to sequence data July- December 2017 and then follow it January to June 2018, and
2. Rather than showing week number, 0, 10, 20, etc how can I get it to show a date, eg 1 Jul 2017, 1 Sep 2017, 1 Jan 2018, 1 Mar 2018
The data that is visualised on a daily basis is:
Fiscal YTD Performance BY DAY
Whilst I am happy with the daily visualisation, it takes an inordinate amount of time to view on a Dashboard when I am away from my computer, hence I am trying to streamline the data that is used in the visualisation to make it more efficient.
Any help suggestions will be welcomed.
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:
2 Replies
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.
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: