This content has been marked as final. Show 3 replies
I have a scenario where I have 2 tables, one for device sent and one for device connected, the connected table has got 2 fields to determine when it was connected, a first connect time and a last connect time.
If I derive the date from the time and join this to 2 calendar tables (alias the calendar table one for last connect and other for last connect) I should be able to get the data for total sent and connected by selecting the appropriate calendar dimensions?
Is this the best way of design ?