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

    Connecting visitors to date & hour

      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 =)