-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Description
Change one of the samples to use from in lower case:
-- Nested percentages (% of year, and that year's % of total)
SEMANTIC SELECT
year,
region,
AGGREGATE(revenue) AS revenue,
100.0 * AGGREGATE(revenue) / AGGREGATE(revenue) AT (ALL region) AS pct_of_year,
100.0 * AGGREGATE(revenue) AT (ALL region) / AGGREGATE(revenue) AT (ALL) AS year_pct_of_total
from sales_v;
returns
Invalid Input Error:
Query error: Binder Error: Referenced table "_outer" not found!
nsx-maximverbruggen
Metadata
Metadata
Assignees
Labels
No labels