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:
- 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
Sorry for the delay in reply.
We’ve tried to recreate your simplified scenario to see if what you are after can be done simply by MAQL.
But I am afraid that complicated calculation like this will have to be done on database level, i.e. by creating a new fact that would tell you number of active users every minute.
Boris from GoodData Support