4 Replies Latest reply on Sep 24, 2014 8:42 AM by bruce lomasky

    how to get count of distinct trip #s, based on count of another column

    bruce lomasky

      My table has 2 columns, tripNumber and routeNumber, the primary key is the 2 columns, so each tripNumber has 1 to 8 rows, so it looks like this

      1   10

      1   12

      1   14

      1   16

      2   10

      3   12

      3   16

       

      Simple, right?  Here is what the customer is asking for:

       

      1) show (graph) the # of trips with 1 route, with 2 routes, with 3 routes, etc.

      2) for every route (there are about 12 routes) if there is a trip with multiple routes, show the other route and the # of times it is on the same route, so with this data, Route 12 would display alt route 10 with a count of 1 and 16 with a count of 2

       

      thanks in advance, since my tired brain is not sure how do do this in Tableau

       

      Bruce