2 Replies Latest reply: Jul 10, 2014 9:38 AM by Nilo Barreto Pontes RSS

    Highlight moving date range


      I have a chart which shows recovery rates for the prior 15 months based on a current date selected. Looking to create an expression that will highlight the last three data points in the range, meaning months 13-15 as the current selection changes.

       

      Any suggestions would help

      .

      Thanks

        • Re: Highlight moving date range
          Friedrich Hofmann

          Hi,

           

          try with the "background colour" (appears when you click on the cross next to your expression in the dialog). There you should be able to enter a formula calculating from the current user_selection (with GETFIELDSELECTION()) or just with max(month) (and max(month, 2) and max(month, 3)) - since, once the user has made a selection, only the available months are considered, so you want the latest three.

          HTH

           

          Best regards,

           

          DataNibbler

          • Re: Highlight moving date range
            Nilo Barreto Pontes

            Hi Josh,

             

            Add an expression in the 'background color':

             

            Something like: if(Month(Date)>=Month($(vCurrentDate)-3),'color to highlight' RGB(),'other color' RGB())

             

            Best Regards,

             

            Nilo