18 Replies Latest reply: Jan 21, 2016 2:51 PM by Onno van Knotsenburg RSS

    HELP! Aggregate a Subset of a Deminsion

      Please help I have a simple list of Helpdesk Tickets where I am trying to determine % of Tickets Open 1 day or less, % of Tickets Open 2 - 5 days etc. I can not seem to get an expression to work where the Count of "Tickets Open" = 1 / Count of "Ticket # gives me a %. Syntax for this is very frustrating given I can handle simple math / algebra.

         

      Ticket #Days Open
      198211
      198221
      198241
      198251
      198261
      198273
      198284
      198294
      198314
      198325
      198335
      198345
      198376
      198386
      198418
      198429