2 Replies Latest reply on Sep 12, 2018 8:18 AM by Laurence Turner

    MIN(Date) returns "All" when inserted into title/subtitle: How can I show the date range within title/subtitle?

    Laurence Turner

      Hello,

       

      I have two calculated fields "MIN DATE" and "MAX DATE" which return the YEAR of my date dimension "Dates":

      DATE(DATEPARSE ( "yyyy", STR(MIN(YEAR([Dates]))) ))

      and DATE(DATEPARSE ( "yyyy", STR(MAX(YEAR([Dates]))) ))

       

      When I add these to my chart - they show as expected (2005, and 2014), however when I insert them into my title/sub-title the min value is shown as All (see screenshot below). Does anyone have a fix for this, know of a better way to show the range of dates in a title/sub title?

       

      Thank you for any help in advance

       

      Best,
      Laurence