35 Replies Latest reply: Nov 7, 2017 7:06 PM by Cassandra Baqir RSS

    Rename Class and Specify Buckets

    Cassandra Baqir

      Right now I am using the following Dimension for my interval buckets:

       

      =replace(aggr(Class(count(GOV_DECISION_BODY_SUB),2), DEFECT_ID), '<= x <','-')

       

      What I am trying to accomplish is 3 things:

       

       

      1. Hardcode the PROCESS_STEP selections so the user does not need to select them from the list box. I will have several versions of this graph with different selections to be used in an Nprinting export.
      2. I would think 0-1, 2-3, 4-5, 6 or more or whatever a frequency distribution suggests. Or, maybe 0, and 1 should be broken out separately. . . . and then the other categories.
      3. If possible, rename the 0-1 bucket to Low Complexity, rename 2-3 to Medium etc

      11-1-2017 9-59-04 AM.jpg

       

      Any suggestions?

       

      Thanks in advance!

       

      stalwar1