Search results

Thanks a million @MajP, you are right I'll have deal with the outliers for the ML side of the analysis (more fun :) ), also going to run it through a DLN. I appreciate the time and the patience, and the great explanations. I am transfering most of the query analysis results to an excel sheet at...

Hi @MajP, I am sorry to bother you again, I been busy analysising away, thanks to all your help. I have even managed to adjust the avg elapsed by adjusting the queries slightly, which I would not have been able to do without your guidance, Thanks. I have checked the access functions and can...

Thanks will take a look. Thanks again. S

This is factor is brilliant! As you say I can do alot more than with :-), I just could not figure out out to do it so when for the more simple version. It sure does and I really appreciate the time, the patience :-) and the ability to break it into understandable chucks for me. Virtual pints...

Thanks again, I would be pulling my hair out with your help. So i think you may given me an additional factor (Elapesed Time per KP), which is super cool, but just to double check my logic of what you have done for me: "Elapsed Time" is the time eslased between each keypress for USER 1050 for...

Thanks again. I am looking for Each user for each section. Their average time on each section. As I am trying to see if time is a factor, and will help improve accuracy on a machine learning alogorithm. I think this is the only way I can use or analysis time, within the database.

Thanks again @MajP for all the help. I might have messed up the time a little creating the sample data set. The log is from a few years back and from several organisations but Time is represented in using UNIX Timestamp. I have attached a single instance ie USER 1050 for Question 1 for all...

I am sorry ...... I am sure you thought you got rid of me :) , can I use your expertise again please. As I now have everying in one query 🥳 thanks to you guys. Could I ask you to show me, if its possible. To create the "Average Time Between Negitive press", for each section and user. I can...

Big thank you to everyone for all the help, time and willings to share your expertise to a mere mortal. Greatly appreciated. Virtual Beer all round 🍻. Thanks again. S

You did it!! Thank you so much for the help. It works great! Thank you. Unfortunetly, I can only repay with virtual beer 🍻.

Wow! Thanks for taking the time to help me, I really appreciate it. Ooohhhh! This might be it!! 🎯 Thanks so much. I'll give it a go on the real data set in the morning but I think you have nailed it for me and saved me days of work. Thank you !!!

Thanks for getting back me, yes that's it sort of. It seems to be a alternative way of doing it, than I have at the moment, which is cool. With the help from earlier posts, I managed to get the data by. Using multiple IIF() in a report based on query criteria of USER and SECTION number. The...

Wow! Pat thank you so much, I really do appreciate the help, the advice and the time. You are brilliant to offer. I have created a sample data set Criteria for each user for each section (1, 2, or 3): Total AA ... for Section 1, 2, 3 Total AB ... for each section Total KP ... for each...

Thanks a million for the reply. Unfortunately, I tried to do the IIf() calc in an aggregate query provided by Pat but I could not figure out the SQL side to get it to work, can it be done within the Query Design. As you say the eventdetail field data is so varied, it may not be able to...

I am sorry about this but could I ask someone to help with parsing the Eventdetails field please. I am going to try put it into first normal form as Pat recommends ... however, I have no SQL or VBA experience I can use the query design however :) so you have to keep it simple please. There...

Thank you Pat. I appreciate the advice and for taking the time for the comprehensive reply, which is extremely helpful. It is a one-time effort :) as I'll keep my mouth closed next time this come up :). However, your right I am only on user25, (:-) only 675 to go) and the boredom is killing...

Yes you and Pat is bang on ... the data is badly structured as the 10 (possibley more) queries, are creating new information (for a Machine learning algorithm) just from the event field. I have not looked at the time field yet. You have already saved me hours if not days as the DB(logs) has 650...

The forum has saved me hours if not days :) Thank you so much. Can I ask 1 further question please (being a bit lazy .. or hopefully on a roll). As I have a report showing the 10 summations ie total amount of AA ## and AB ## etc ..... which is brill. Can the report reduce the iterations...

Love it :) David thanks ... showing my age ... I have an issue 1 + 1500 other issues ;-) up in the attic

Thanks Pat for the detailed reply, I am afraid that would be beyond me at the mo :-) both in terms of knowledge and time. Analysis of the DB(Logs) is a vital but smaller part of the overall project that I got asked to do. I knew I could do it one way or the other using Access as I am not a...