Filtering "two level" calculated questions


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

for example,

  1. counting events per day, and
  2. 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?

you're seeing a derivative of Custom Column after aggregation causes dashboard filtering to be very limited · Issue #19744 · metabase/metabase · GitHub