View top_brands in ecommerce.malloy results in "Error: Path to structure not found 'gross_margin'" #57
Description
What happens?
When trying to run the top_brands view defined in ecommerce.malloy, an error "Error: Path to structure not found 'gross_margin'" is thrown
This happens for any view in which aggregates built on top of the *_gross_margin fields are used
To Reproduce
Run this view in ecommerce.malloy
view: top_products is {
top: 5
group_by: inventory_items.product_name
aggregate: total_sales, percent_of_sales, total_gross_margin, order_item_count
}
OS:
macOS
Malloy Client:
local VSCode
Malloy Client Version:
v0.3.1711050948 (pre-release)
Database Connection:
DuckDB