2 Replies Latest reply on Nov 21, 2016 9:58 AM by Ramya Sadagopan

    Calculate weekdays within relative date range (on runtime)

    Ramya Sadagopan

      I would like to calculate the number of weekdays (Mon thru Fri)  based off of the relative Date selection.

       

      For example I have a relative Date range filter and today's date 1-Nov-2016 Tuesday

       

      if my Date range is current month THEN Number of Weekdays = 1

      if my Date range is Current week THEN Number of Weekdays = 2

      if my Date range is Previous week THEN Number of Weekdays = 5

       

      Any thoughts on how do i achieve this real time as I change this date range on dashboard?