malloy
malloy copied to clipboard
Ungrouped calculations in nests with filters don't respect the nested filter.
This query doesn't produce correct results. percent_of_queries doesn't include the nested where filter.
# dashboard
run: jobs -> {
where: is_query
group_by: user_email
aggregate:
query_count
nest: dataset_queries is {
where: referenced_tables.dataset_id != null
group_by: referenced_tables.dataset_id
aggregate:
query_count
percent_of_queries
}
}