I prefer to steer clear of SQL queries since we don't permit users to utilize them, and filtering with SQL can be more laborious. However, when I'm creating a question that involves two levels of calculation
- counting events per day, and
- calculating the average count per day,
standard filters aren't available.
I only have variable "TORN" available
As a result, you have to convert the question to an SQL query in order to apply them. Is there any workaround for this issue? Perhaps it's something that could be improved?