To GoodData homepage

Replies posted by Julia K

1 Reply

J
Julia KNew Participant
asked in Metrics and MAQL

Timestamps - I need to calculate how many users were active each minute, having single intervals of their activity

Thank you for your response! I’ll try to provide more details.Right now, calculation for that specific minute (20:45) seems to make sense – in the insight I can see the number, which is probably the right one. However, what I really need to do is to provide a metric that would check every minute during the day – from 00:00 to 23:59 (without need to set HOUR and MINUTE as variables like in the example I’ve given). Then, if I could assign such unique viewers numer to each minute a day I could visualize how users’ activity was changing over time during the day. And that’s the final output I’m hoping for.I’ve read some of your articles about dealing with timestamps and using epoch time, so I rearrange my LDM model a bit. Here’s the time-activity part:End/Start Time in Seconds has a range (0-86399) and analogously End/Start Time in Minutes a range (0-1439).Now the condition for particular minute is simpler and more redable, however I still didn’t find a way to calculate unique viewers at on

3
Boris
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings