A client wants a specific report which gives the average visitors per hour per day.
To be able to archief this, i first create a SQL query in Metabase.
This gives me the location, day, hour, total visitors.
Then i can create a second question in Metabase based on the previous created question where I then can summarize based on the average of count.
This is all working without a problem.
The issue is that the client wants to be able to filter that report on values which are not in the SELECT part of the query. And Metabase only gives you the option to filter on columns that are in the SELECT part.
I tried to work with variables like this:
where 1 = 1
but when i then convert it into a modal, it says it's not allowed and that I have to remove it first.
Does anyone have an idea how to acomplish what I want? Is it even possible to do it with Metabase?
If would be nice that i could use this:
Use the filters that i've created with the variables, and then explore the results with metabase. But if I click now "explore results" then i does not take the filters in to account.