3 Replies Latest reply on Sep 13, 2019 12:16 PM by Doreen Prasad

    Year to Date Calculations

    Doreen Prasad

      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