1 Reply Latest reply: May 25, 2018 1:21 PM by Sunny Talwar RSS

    Aggregated Minimum Value for each month

    Patricia Thomas

      I am trying to show the Minimum value in a field if a criteria is met aggregated by each month. Right now the minimum across the data set is what is pulling in my bar graph for each month, but I need those to be aggregated to change based off of the minimum for that month only.

      I'm currently using the below to pull the minimum Layer number if the for all records that have "Manager" in as the criteria. This is currently showing me 4 for every month - however, May should have 5 since there is no one in that month that meets that criteria - but I'm still showing 4. Any help is greatly appreciated!

       

      =Min(if([Rolling12_HC.Manager? Y = 1]='Manager',[Rolling12_HC.Number of Layer]))+1