I have a similar problem but unfortunately the nested query is not working for me.
SELECT average(percent) FROM (SELECT percentage(uniqueCount(uuid), WHERE category = 'Crash') as 'Average User Crash Rate' FROM MobileSession, MobileCrash WHERE appName = 'Sample Android app') SINCE '2022-04-01 00:00:00 PDT' UNTIL '2022-05-01 00:00:00 PDT'
I’m interested to see what is the average daily percentage over the course of the month and so I added the suggested “select average (percent)” to the front of my query but it returned “no value”.
If it helps, here’s some context:
When a user has a crash, it counts against our user crash rate percentage for that user until that crash instance is outside of our query time window. So if 100 users has a crash on day 1 and we push out a hot fix on day 3 (to the same user base, which you can for Android staged rollouts), then even though those 100 users are now crash free, the crash rate percentage will not show immediate improvement if we did a 1 week look back. Thus we have set our query and SLO for a 1 day view. No problem there.
The problem is that we have the NR widget for that “1 day view” query on a dashboard where you can specify any time period (like a month in the query above) and because of my explanation above, the user crash rates will be higher, the longer the time window you set.
So it would be great if there is a way to evaluate the “average daily user crash rate” against any longer time period. Other suggestions welcome.