Hello!
The problem I’m struggling is how to create an AMR (Average Minute Rating) using MAQL. For simplicity I started with one day period when I want to observe how users activity changes over time (for example minute by minute). So I have data of a form:
- userID
- start time - atribute refering to Start time table having M, H, S values as a facts, start time label as a key HH:MM:SS and an atribute start time [min] HH:MM
- start day - date
- end time - atribute refering to table with a structure like Start time table already described
- end day - date
- activity details
I was able to build a very inelegant vay to find out how many unique users were active during particular hour (e.g 20:45 HOUR = 20, MINUTE = 45), but with one major drowback which is that I need hour and minute as a variable to do those calculations. Here’s the MAQL form:
I need solution that could be visualised - for every minute, automatically. Hoping for your help! I would appreciate any hints :)
Best answer by Boris
View original