Page 3 of 3

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue Jan 23, 2024 7:34 am
by fraggle200
Is all the raw data within the DATABASE sheet? if so, how do you calculate the minutes played from that?

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue Jan 23, 2024 10:36 am
by Scrivani
fraggle200 wrote:Is all the raw data within the DATABASE sheet?
Yes.
fraggle200 wrote:if so, how do you calculate the minutes played from that?
my automation performs the extraction every 5 minutes, so each time the user appears in an extraction represents 5 minutes online. If someone spends 30 minutes online, they will appear 6 times in that period and this is how the calculation is made.

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue Jan 23, 2024 10:38 am
by Scrivani
Holsten wrote:I don't really feel comfortable knowing that how much and what i play is public to everyone.
Hi Holsten, I understand. Do you want me to remove you from all data?

Since Now's information is public anyway, it's just a different way of representing and accumulating it.

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue Jan 23, 2024 2:51 pm
by fraggle200
Scrivani wrote:
fraggle200 wrote:if so, how do you calculate the minutes played from that?
my automation performs the extraction every 5 minutes, so each time the user appears in an extraction represents 5 minutes online. If someone spends 30 minutes online, they will appear 6 times in that period and this is how the calculation is made.
I thought that was the case but just wanted to check. If you don't mind, I was going to put this into Power BI and build a dashboard that's a bit more interactive. then just have it published and it'll tick over in the background updating every day or so.

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Wed Jan 24, 2024 3:33 am
by Holsten
Scrivani wrote:
Holsten wrote:I don't really feel comfortable knowing that how much and what i play is public to everyone.
Hi Holsten, I understand. Do you want me to remove you from all data?

Since Now's information is public anyway, it's just a different way of representing and accumulating it.
I would like to be removed, even if it's not doing much.

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue May 28, 2024 1:51 pm
by Scrivani
Captura de tela 2024-05-28 145037.png
Captura de tela 2024-05-28 145843.png

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue Feb 25, 2025 4:17 pm
by Scrivani
Captura de tela 2025-02-25 181630.png
Captura de tela 2025-02-25 182109.png

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Tue Feb 25, 2025 4:56 pm
by Sonic1994DC
Number 10

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Wed Feb 26, 2025 11:57 am
by Scrivani
Sonic1994DC wrote: Tue Feb 25, 2025 4:56 pmNumber 10
and you are the number 1 in days online ;)
- 333 days

since jun/2023

Re: [DATABASE] Dreamcast Now Data Analysis

Posted: Wed Feb 26, 2025 1:30 pm
by Sonic1994DC
Scrivani wrote: Wed Feb 26, 2025 11:57 am
Sonic1994DC wrote: Tue Feb 25, 2025 4:56 pmNumber 10
and you are the number 1 in days online ;)
- 333 days

since jun/2023
Wow! I didn't realize I played Dreamcast that much :o