11 Replies Latest reply: Jun 22, 2015 3:38 PM by Darrin Pilkington RSS

    Trying to find the lowest value per Dimension, possibly aggr()?

    Darrin Pilkington

      Hello,

      I have a chart and I need to identify the lower Incentive value for each %ADAcctKey.

       

      The Incentive value is a calculated value.  In the example below 445 would flag 10% and for 2544 the lowest flagged would be 0%.

          

      %ADAcctKeyMetricDescQAAdherenceRevenueSavesLevelTargetIncentive
      445QA87.50% Target80% >=10%
      445Adherence 88.04% Target88% >=10%
      2544Save Rate 26.09%Stretch22% >=20%
      2544QA81.68% Target80% >=15%
      2544Adherence 74.34% Below85% <0%
      2544Revenue $335.40 Below$750 <0%

       

       

      Thank you for you help.