[DATABASE] Dreamcast Now Data Analysis

[fraggle200]

Is all the raw data within the DATABASE sheet? if so, how do you calculate the minutes played from that?

[Scrivani]

Is all the raw data within the DATABASE sheet?

Yes.

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.

[Scrivani]

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.

[fraggle200]

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.

[Holsten]

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.