2 Replies Latest reply: Jun 14, 2013 7:42 AM by Elke Corstjens RSS

    [Set Analysis] Last Month fot which value is not null

    nicolas aimain

      Hi all,


      I have several indicator for which I need to calculate through an expression the value for last month for which value is not null


      Monthsite ASite B


      in the below example,I need to obtain in my graph:


      Site A --> 21

      Site B --> 155


      I manage to get the last month (12)

      But I get Site --> null

      Site B --> 155


      I suppose i could combinate something like max(month where len(my_value)>0) but I don't know how to do that


      Does anybody has an idea ?

      Thanks in advance