4 Replies Latest reply on Nov 7, 2016 8:48 AM by Ramya Sadagopan

    Calculate number of weekdays within the date filter on runtime

    Ramya Sadagopan

      I have a Relative Date filter on my Dashboard and I would like to calculate the number of weekdays based on the date range selected in my filter.

       

      For example, Today's Date: Nov 1st 2016 Tuesday

       

      If my Date filter is Today THEN number of weekdays = 1

      If my Date filter is This Week THEN number of weekdays = 2

      If my Date filter is This Month THEN number of weekdays = 1

      If my Date filter is Previous Week THEN number of weekdays = 5

       

      etc

       

      Any thoughts on how to achieve this in real time as I change the date filter?

       

      Thanks

      Ramya