3 Replies Latest reply: Jan 12, 2016 1:36 PM by Sangram Reddy RSS

    Connecting visitors to date & hour

    Betty Habtemariam

      Hi guys,

       

      I wanted to try something new, but don't really know where to start and how to do things. I have many files that look like this.

       

       

      Connecting visitors to hour and time.PNG

      What I want to do is to somehow connect visitors to date and hour. I have a customers table with customer orderID as the key.

       

      1. It is reasonable to make a left join to that table, isn't it?

      2. How do I handle that fact that there are many tables like this (1 for each month)? How can I load them into the script without     there being 50 tables?

      3. How would I visualize this in the best way later on?

       

      I'm aware that there are a great deal of questions, but I'm hoping that someone can share their knowledge =)