4 Replies Latest reply on Mar 4, 2018 7:04 PM by Zhouyi Zhang

    Cannot Categorize and Count Specific Dimension Values

    Mike Bushey



      So I have a data set that is broken down into a main shipping number and then a number of boxes for that shipment. I am trying to break the shipping numbers into two categories: Ones with premium paper and ones without premium paper. I then want to count these two categories.


      Where I am running into issues is the fact that each shipping number has different boxes.


      My data looks like this:


      Screen Shot 2018-03-02 at 9.15.50 PM.png

      This is what I have got it to so far:


      Screen Shot 2018-03-02 at 9.17.44 PM.png


      What I want to get to is this:


      Screen Shot 2018-03-02 at 9.17.44 PM.png

      Screen Shot 2018-03-02 at 10.02.34 PM.png


      Essentially I only want one line per shipping number and I want it to say whether that shipment has premium paper or no premium paper.


      I have tried various different formulas and options and for the life of me cannot get this. Any help would be greatly appreciated. Once I have the two categories I plan to show the trends of the two by date on a line chart.