12 Replies Latest reply on Mar 5, 2018 12:34 PM by Patrick Van Der Hyde

    how to get MTD/YTD/Current Week selections in dashboard

    Sashank Kammili

      Hi, I have one requirement. I need to show Current Week/MTD/YTD selections in my dashboard. Say if user selects current week, then it should display data for current week(mon to fri), say if they select MTD, then it should show Jan 2018 data when they select in Feb 2018(in mar 2018 it should show feb 2018 data), if they select YTD  in March 2018, then it should show data for Jan and Feb 2018. I have nearly 20 worksheets in the dashboard. I would like how apply this logic for all my 20 worksheets in the dashboard, currently there is no logic applied and it shows just MTD data. Please help me with this on how to accomplish it.