Re: [DATABASE] Dreamcast Now Data Analysis
Posted: Tue Jan 23, 2024 7:34 am
Is all the raw data within the DATABASE sheet? if so, how do you calculate the minutes played from that?
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?
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.
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?
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.
and you are the number 1 in days online