How to get user access time?

Q&A
,
1

Hi There, I am new to Quick Sight. I have the below data set and I want to calculate the users spent time on system. how to do that?

image
image574×1132 15.3 KB

2

Hi @Abdul_Rizwan_Mohamme - Welcome to AWS Quick Sight and thanks for posting the question. What is your business logic to find the total time spent .. from data it is not very clear. Please provide the business logic then we can explore the solution in Quick Sight.

Regards - Sanjeeb

3

Hi Sanjeeb-Thanks for connecting. I would like to see the trend of how many users access the system daily or weekly or monthly.
Thanks

4

Hi @Abdul_Rizwan_Mohamme - Thanks, one more question, how to tag a user is accessing daily, weekly or monthly. Do you have a logic for the same? From the sample data, one user may login multiple times in a day and 2 times in a week or 7 times in a week. Please provide some info aroud it and then you can start exploring create a calculated field w.r.t access pattern.

Regards - Sanjeeb

5

Hello @Abdul_Rizwan_Mohamme !

Are you able to follow up with @Sanjeeb2022 's question above? It has been some time since we have heard from you, but still want to help you find a solution.

If we do not hear from you in the next 3 business days this topic will be archived.