1 Reply Latest reply on Nov 19, 2013 1:45 PM by R W

    Grouping Count of ID's into ranges

    R W

      Hi

       

      I am new to Tableau - finding it awesome but pretty steep learning curve.

       

      I have 2 (SQL Server) tables Contacts and Activities.

       

      I want to extract and graph the number of activities (eg pageviews) into bands eg 1 Page view; 2-5 Page views; 6-10 Page views; 10+ Page views

       

      So the data from the inner join in SQL Server would look thus:

       

      ContactIDActivityType
      1PageView
      1PageView
      1PageView
      2PageView
      2PageView
      2PageView
      3PageView
      2PageView


      This would be relatively trivial in SQL Server but I have tried lots of approaches in Tableau (groups, sets, bins, Calculated Fields etc) and cannot work it out.


      Can someone help?


      Thanks


      Richard