[DATABASE] Dreamcast Now Data Analysis
Moderator: pcwzrd13
- fraggle200
- Graffiti Grind
- Posts: 319
Re: [DATABASE] Dreamcast Now Data Analysis
Is all the raw data within the DATABASE sheet? if so, how do you calculate the minutes played from that?
- Scrivani
- Vagabond
- Posts: 734
- Dreamcast Games you play Online: Almost all
Re: [DATABASE] Dreamcast Now Data Analysis
Yes.fraggle200 wrote:Is all the raw data within the DATABASE sheet?
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.fraggle200 wrote:if so, how do you calculate the minutes played from that?
Happy if may help:
- BBA Mode for DreamPi: https://bit.ly/3JEIuhs
- VPN Port Fowarding: https://bit.ly/3Bgw4bu
- DC Now Data Analysis: https://bit.ly/42coxXw
- DC KARA NOT DEAD AT ALL- VCD Method: https://bit.ly/3P6VePw
- Know part of BR Community: https://bit.ly/3iLXS12
- BBA Mode for DreamPi: https://bit.ly/3JEIuhs
- VPN Port Fowarding: https://bit.ly/3Bgw4bu
- DC Now Data Analysis: https://bit.ly/42coxXw
- DC KARA NOT DEAD AT ALL- VCD Method: https://bit.ly/3P6VePw
- Know part of BR Community: https://bit.ly/3iLXS12
- Scrivani
- Vagabond
- Posts: 734
- Dreamcast Games you play Online: Almost all
Re: [DATABASE] Dreamcast Now Data Analysis
Hi Holsten, I understand. Do you want me to remove you from all data?Holsten wrote:I don't really feel comfortable knowing that how much and what i play is public to everyone.
Since Now's information is public anyway, it's just a different way of representing and accumulating it.
Happy if may help:
- BBA Mode for DreamPi: https://bit.ly/3JEIuhs
- VPN Port Fowarding: https://bit.ly/3Bgw4bu
- DC Now Data Analysis: https://bit.ly/42coxXw
- DC KARA NOT DEAD AT ALL- VCD Method: https://bit.ly/3P6VePw
- Know part of BR Community: https://bit.ly/3iLXS12
- BBA Mode for DreamPi: https://bit.ly/3JEIuhs
- VPN Port Fowarding: https://bit.ly/3Bgw4bu
- DC Now Data Analysis: https://bit.ly/42coxXw
- DC KARA NOT DEAD AT ALL- VCD Method: https://bit.ly/3P6VePw
- Know part of BR Community: https://bit.ly/3iLXS12
- fraggle200
- Graffiti Grind
- Posts: 319
Re: [DATABASE] Dreamcast Now Data Analysis
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.Scrivani wrote: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.fraggle200 wrote:if so, how do you calculate the minutes played from that?
- Holsten
- killer
- Posts: 277
Re: [DATABASE] Dreamcast Now Data Analysis
I would like to be removed, even if it's not doing much.Scrivani wrote:Hi Holsten, I understand. Do you want me to remove you from all data?Holsten wrote:I don't really feel comfortable knowing that how much and what i play is public to everyone.
Since Now's information is public anyway, it's just a different way of representing and accumulating it.
Holsten knallt am dollsten.