2 Replies Latest reply on Sep 17, 2013 8:21 AM by Robert Sutter

    aagregate at a group level not displayed in the visualization

    Robert Sutter

      Hello all -


      I would like to know if there is a way to aggregate data at a grouping level not displayed in the vis.


      For example I have 3 groups A-C. Group A contains pre-aggregated totals at the group A level and I have another field that needs to be summed regardless of group.


      In the vis what I want to do in essence is sum the max or average of the pre-aggregate value always at group A regardless of the group I am displaying and also sum another field that has not been pre-aggregated.


      So if I'm displaying group B I want the calc to be sum(min(value1)[GroupA]).


      I know this may seem vague so let me know what other info I can provide.