4 Replies Latest reply: Dec 20, 2016 7:10 AM by Sunny Talwar RSS

    Interval on set analysis

    ben lim

      Hi guys,

       

      I have a set analysis with this expression

       

      sum({<Region = {'Asia'}>}Amount)

       

      I have an interval involved

       

      Interval(Date1-Date2,'mm') < 121

       

      Basically I need to calculate where the sum of amount for asia only where the difference between the two timestamp are < 121 mins

       

      I def. need to do it all in one expression. cant do it in dimension, is there any way that i can do it.

       

      Thanks