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.