3 Replies Latest reply on May 21, 2016 5:41 PM by Jonathan Walker

    Count of line item transactions - binning

    Nathan Masters

      Hi All

       

      I am new to the world of Tableau, so I am hoping that someone can assist a beginner.

       

      I am trying to derive count of 'Jrnal No' that fall in a bin of:

       

      <200 Lines

      201 - 400 Lines

      .....etc

      >1000 Lines

       

      Whilst I can easily derive the correct Jnl Line Count 'bin' at a record level level (see below screenshot for view), I am struggling to build a view with count of 'Jrnal No' that falls into those categories.

       

      As soon as I start to build a high level aggregated view, everything classifies as >1000 Lines.

       

      Row level calcs, LOD's etc I am obviously struggling to grasp.

       

      Thanks for your help. Any help would be greatly appreciated. I hope the above makes sense.

       

      Regards

       

      Nathan