How to use partition by clause in Domo SQL
I have following columns:
Each row can be repeated multiple times. I want to sum values on the kingdom level in another view/table:
My code is:
SUM (MAX ('Age')) OVER (PARTITION BY 'Animal') AS 'Age',
SUM(MAX ('Weight')) OVER (PARTITION BY 'Animal') AS 'Weight'
GROUP BY 'Kingdom'
The Domo transform does not work. Says "Whoops! Something went wrong"
Can someone help me as to how to make this work?