5 Replies Latest reply on Jul 29, 2016 12:16 PM by Jeff James

    Tableau Filtering

    Cuong Tran

      Hello  everyone,

      I am new to Tableau and I have a question about creating a graph

      I have the following data

      computer

      computer
      CPU usage (%)date and time
      computer 15001-01-2016 12:01:00 AM
      computer 110001-01-2016 12:02:00 AM
      computer 16001-01-2016 12:03:00 AM
      computer 1100 01-01-2016 12:04:00 AM
      computer 15001-01-2016 12:05:00 AM
      computer 110001-01-2016 12:06:00 AM
      computer 13001-01-2016 12:07:00 AM
      computer 19501-01-2016 12:08:00 AM
      computer 24001-02-2016 12:00:00 AM
      computer 2 4001-02-2016 12:01:00 AM
      computer 2 96

      01-02-2016 12:02:00 AM

      computer 210001-02-2016 12:03:00 AM
      computer 240

      01-02-2016 12:04:00 AM

      computer 25001-02-2016 12:05:00 AM
      computer 210001-02-2016 12:06:00 AM
      computer 26001-02-2016 12:07:00 AM
      computer 28001-02-2016 12:07:00 AM
      computer 310001-04-2016 12:00:00 AM

      computer 3

      50

      01-04-2016 12:01:00 AM

      computer 310001-04-2016 12:02:00 AM
      computer 310001-04-2016 12:03:00 AM
      computer 35001-04-2016 12:04:00 AM
      computer 310001-04-2016 12:05:00 AM
      computer 35001-04-2016 12:06:00 AM
      computer 3 6001-04-2016 12:07:00 AM
      computer 39801-04-2016 12:08:00 AM

          

      suppose I have the table above, and  I would like to know what is the top 2 computers that has the highest occasions of CPU>90% in last 7 days assuming today is 01-05-2016

      I believe the result should be

      computer 3, has 5 times

      computer 1 has 4 times

       

       

      Any help would be appreciated

      thanks