8 Replies Latest reply on Sep 10, 2018 3:13 PM by Gerardo Varela

    Calculate Time Difference between each hr

    manoj kumar

      Hi Everyone,

       

      My name is Manoj and i'm new to Tableau. I have a data set which has Date&time, client name and tickets purchased by them for each hour.

       

      I have attached the sample data set below. My requirement is to list down top N clients based on each hour time stamp. Say if the present time is 11 AM.

       

      In my dashboard, i wanted to display the Top N clients in the below-mentioned format (separate worksheets). Could you please suggest how to do the calculation.

       

      11:00 AM

       

      9AM-10AM

       

      7AM-8AM

      Top N Client

      Ticket Count

      Top N Client

      Ticket Count

      Top N Client

      Ticket Count

      Client B

       

      Client A

       

      Client C

       

      Client A

       

      Client B

       

      Client A

       

      Client C

       

      Client C

       

      Client B

       

       

      Thank you in advance,

       

      Cheers Manoj

       

       

      Date & Time

      Clients

      TotalTicketes

      9/9/2018 12:59:59 AM

      Client-1

      100

      9/9/2018 1:59:59 AM

      Client-1

      121

      9/9/2018 2:59:59 AM

      Client-1

      110

      9/9/2018 3:59:59 AM

      Client-1

      32

      9/9/2018 4:59:59 AM

      Client-1

      234

      9/9/2018 5:59:59 AM

      Client-1

      234

      9/9/2018 6:59:59 AM

      Client-1

      543

      9/9/2018 12:59:59 AM

      Client-2

      200

      9/9/2018 1:59:59 AM

      Client-2

      300

      9/9/2018 2:59:59 AM

      Client-2

      10

      9/9/2018 3:59:59 AM

      Client-2

      32

      9/9/2018 4:59:59 AM

      Client-2

      234

      9/9/2018 5:59:59 AM

      Client-2

      390

      9/9/2018 6:59:59 AM

      Client-2

      123

      9/9/2018 12:59:59 AM

      Client-3

      3000

      9/9/2018 1:59:59 AM

      Client-3

      1200

      9/9/2018 2:59:59 AM

      Client-3

      10

      9/9/2018 3:59:59 AM

      Client-3

      11

      9/9/2018 4:59:59 AM

      Client-3

      543

      9/9/2018 5:59:59 AM

      Client-3

      32

      9/9/2018 6:59:59 AM

      Client-3

      21