2 Replies Latest reply on Jul 8, 2013 6:49 AM by John Sobczak

    How to Capture Last or Latest Date in Dashboard for Label

    John Sobczak

      I am trying to functionally capture the last date in my dashboard through a calculated field or otherwise to put in a label by using index, last, max or otherwise on the date field and am having no luck.   I'm sure it's possible but I just can't get it.  I currently have the date manually updated in the reference line label.  Keep in mind Now() will not work since the dashboard may not be updated to the current date.  Attached is the workbook (top chart).