5 Replies Latest reply on Aug 30, 2016 11:07 AM by Andrew Watson

    Find greatest date in data set (Independent of Viz filters)

    Daniel Frost

      I am trying to find the largest date in a data set to ascertain the current Quarter and Year (and subsequently do comparisons against current quarter).  I tried creating an LOD calculation

      {fixed: MAX([Date])}

      But this is still subject to the filters of the Viz.  So, if there is no data (in the filtered Viz) for the current quarter then the calculation returns the previous quarter.

      Is there a way to extract the greatest date from the data set independent of the scope of the Viz?

      Thanks for your help.