1 Reply Latest reply: Apr 11, 2014 5:02 AM by Manish Kachhia RSS

    Two calendars required or not?

      hi community,


      i'm having a bit of trouble getting my head round how to structure some data.


      Currently I have a very simple data structure with 3 tables


      UserSessionDetails - this table records a user's session when they log into our software

      UserSignatures - this table hold details on those users, such as when the login was created.


      simple table.bmp


      This enables me to produce a simple chart showing the number of unique users loggin in each week.


      However, the problem arises when I need to show the % of total users logging in over time. To do this I need to use the CreatedDate field in the UserSignature table, because i need to know how many users existed at a certain point in time.


      What is the best way to do this? Do I need separate calendars? One for UserSignature.CreatedDate and another one for SessionStartedDate?