Filtering "two level" calculated questions

Feedback and Requests
1

Hi,

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,

image
image966×501 19.1 KB

standard filters aren't available.

image
image887×319 6.79 KB

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?

2

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