Click here to Skip to main content
15,868,164 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: How can a method return a validation result Pin
Mycroft Holmes13-Mar-21 11:13
professionalMycroft Holmes13-Mar-21 11:13 
AnswerRe: How can a method return a validation result Pin
Eddy Vluggen13-Mar-21 12:11
professionalEddy Vluggen13-Mar-21 12:11 
AnswerRe: How can a method return a validation result Pin
codecs113-Mar-21 19:02
codecs113-Mar-21 19:02 
AnswerRe: How can a method return a validation result Pin
Richard Deeming14-Mar-21 22:21
mveRichard Deeming14-Mar-21 22:21 
GeneralRe: How can a method return a validation result Pin
codecs116-Mar-21 0:15
codecs116-Mar-21 0:15 
Questionwhat is types of Architecturel rendering ? Pin
Member 1506545021-Feb-21 23:46
Member 1506545021-Feb-21 23:46 
AnswerRe: what is types of Architecturel rendering ? Pin
Victor Nijegorodov22-Feb-21 1:19
Victor Nijegorodov22-Feb-21 1:19 
QuestionHow to store data to be able to report on it. Pin
20212a11-Feb-21 7:05
20212a11-Feb-21 7:05 
I'll try to keep the example simple. I am wondering if we should store data differently so that reporting might be easier. For example, let's say we log when a user logs in and out. A normal sql table might look something like this:


user_idactionlog_date
1Login2021-01-01 8:00 AM
1Logout2021-01-01 5:00 PM
1Login2021-01-02 8:00 AM
1Logout2021-01-02 10:00 AM
1Login2021-01-02 12:00 PM
1Logout2021-01-01 5:00 PM


So on and so forth.

Let's say the business needs a report of how long each user is logged in each day. I'm pretty sure I could figure out some sql that uses row_number and partitioning and subtract previous value to end up with the difference between each login and logout event and sum for each day. (Ignore night shifts that might start in the evening and run over to the next day.)

However, we don't want to be writing reports but using an ad-hoc report engine, such as PowerBi.

1) Can a reporting engine take the table of data and allow the user to run a report that shows how long each user is logged in each day?
2) As developers, should we store the data differently to make those types of reports easier? Maybe have a separate summary table?

I know PowerBi pretty well but I don't know how to do a report of how long each user is logged in based on just this table of data.

Should we as developers store the data differently, or is it up to the report (BI) side to manipulate the raw data? Thoughts and opinions?
AnswerRe: How to store data to be able to report on it. Pin
Gerry Schmitz11-Feb-21 7:15
mveGerry Schmitz11-Feb-21 7:15 
GeneralRe: How to store data to be able to report on it. Pin
20212a11-Feb-21 7:33
20212a11-Feb-21 7:33 
GeneralRe: How to store data to be able to report on it. Pin
Gerry Schmitz11-Feb-21 7:45
mveGerry Schmitz11-Feb-21 7:45 
GeneralRe: How to store data to be able to report on it. Pin
Mycroft Holmes11-Feb-21 10:07
professionalMycroft Holmes11-Feb-21 10:07 
QuestionWhat are some intuitive ways to visually show communication packets between several devices, as well as general debug information? Pin
arnold_w1-Feb-21 7:47
arnold_w1-Feb-21 7:47 
AnswerRe: What are some intuitive ways to visually show communication packets between several devices, as well as general debug information? Pin
Greg Utas1-Feb-21 8:05
professionalGreg Utas1-Feb-21 8:05 
GeneralRe: What are some intuitive ways to visually show communication packets between several devices, as well as general debug information? Pin
arnold_w1-Feb-21 8:30
arnold_w1-Feb-21 8:30 
QuestionSystem Monitoring Pin
aslamkazi24-Jan-21 20:53
aslamkazi24-Jan-21 20:53 
AnswerRe: System Monitoring Pin
Richard MacCutchan24-Jan-21 22:06
mveRichard MacCutchan24-Jan-21 22:06 
QuestionShould this be its own class? Pin
RobertSF18-Jan-21 7:23
professionalRobertSF18-Jan-21 7:23 
AnswerRe: Should this be its own class? Pin
Matthew Dennis18-Jan-21 7:40
sysadminMatthew Dennis18-Jan-21 7:40 
AnswerRe: Should this be its own class? Pin
Richard MacCutchan18-Jan-21 22:18
mveRichard MacCutchan18-Jan-21 22:18 
AnswerRe: Should this be its own class? Pin
Gerry Schmitz19-Jan-21 4:46
mveGerry Schmitz19-Jan-21 4:46 
Questionhtlm Pin
MBC Earth7-Jan-21 1:03
MBC Earth7-Jan-21 1:03 
AnswerRe: htlm Pin
Richard Deeming7-Jan-21 1:14
mveRichard Deeming7-Jan-21 1:14 
GeneralRe: htlm Pin
Pete O'Hanlon7-Jan-21 2:41
subeditorPete O'Hanlon7-Jan-21 2:41 
GeneralRe: htlm Pin
cmarble8-Feb-21 11:58
cmarble8-Feb-21 11:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.