malloy icon indicating copy to clipboard operation
malloy copied to clipboard

Ungrouped calculations in nests with filters don't respect the nested filter.

Open lloydtabb opened this issue 1 year ago • 0 comments

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
  }
}

lloydtabb avatar Jul 02 '23 15:07 lloydtabb