Hi,
I'm trying to create dashboards with filters. I have done this in the past with our BQ tables but with views I've created it gives me an error. First I imported my views into metabase since it resides in a separate dataset id. I can map the field to the field filter. But I get this error when I run it.
select date,
sum(num_logins)
from li.artist_login_ts
where {{date_var}}
group by 1
order by 2 desc