0 Replies Latest reply: Jun 28, 2017 12:09 PM by Ben Raty RSS

    Counter Aggregation Syntax

    Ben Raty

      I'm trying to modify a script to return the ratio between a subset(2) of a subset(1) of a complete set, and subset(1). The original script takes this form:


      Sum({$<[Case Type]={'Technical'},[Product]={'Widget'},[Status]={'RMA'},[Record Type Group]={'Sales'}>}) / Count({$}[Case ID (Closed)])


      The value returned appears to be the ratio of subset(2) to the complete set rather than the ratio of subset(2) to subset(1).


      I'd like to know how to modify the script to produce my desired outcome, of course, but more importantly, I'd like to understand the syntax. The documentation I've found is quite dense and exposes my inexperience with BNF.