So we have research data going back a few years. I need to develop a weekly/Monthly report where we display data for the current fiscal year with 2 previous years in a year to date format.
I am able to get the totals but i have 2 issues here.
1. the user has to go select the Week of Year from the filters and on publishing this to the Dashboard its gets reset, the users has to go through the whole list of filters.
2. the other problem is our fiscal year starts in July, so the user has to filter week of year starting from 'Week 27' its difficult to explain this to the users.
I will greatly appreciate some ideas on how I can handle this better.
Thank you
D.
Hi - your timing is interesting I will be recording this months Data Doctor at VizConnect on the topic next week
in the mean time please see https://jimdehner2.blogspot.com/search/label/YoY for 3 ways to do YoY and YTD calculations
Jim