3 Replies Latest reply: Jun 25, 2017 6:52 PM by Paulo Costa RSS

    Aggr applied to all data

    Paulo Costa

      I have a set of monthy agregated data like lines below:

       

      Monthname    count(TransID)

      jan/17         1000

      feb/17           500

      mar/17          700

      apr/17          1500

      may/17           350

      jun/17           2000

       

      The function below returns the "best" Monthname value:

      max(aggr(count({<[trans_type]-={'OXY'}>}[TransID]),[Monthname]))   = 2000

       

      If we filter jan/17 - mar/17, the function will return 1000. I would like to have a similar function, in order to get the best Monthname value from all data. In this way, if we filter jan/17 - mar/17, the function will return 2000.