2 Replies Latest reply: Oct 10, 2014 5:18 AM by Ron Dreijer RSS

    Exclude high value

      Hi,

      I calculate the Sum of AantalEenhedenBinnen per Time frame and show this in a line graph.

      Since there is one day within a certain time frame the Sum of  AantalEenhedenBinnen is that high, I want to exclude this particular Date,Timeframe in my graph.

       

      Because this particular time frame doesn’t represent normal business.

       

      With =MaxString({$}(Aggr(Sum(AantalEenhedenBinnen),Date,Timeframe)))  i can figure out what is the value I want to exclude.

       

      But what I actually need to know is which Date,Time frame generated this high value in order to exclude the results of this Date,Timeframe in my graph.


      Regards

      Ron