ShopifyQL Question: How to fix "Must be a column name" error in ShopifyQL?

I’m playing around with the analytics report we created but I’m stuck with the error: “Must be a column name”. Would anyone happen to know where can I find/refer to the column name? I tried to check available resources in Shopify Support and use the name on the table below the code (Gross_Sale) but it still did not work.

I’m having the same problem., so bumping for visibility… it doesn’t seem to like functions?

I’m having the same “Must be a column name” blocking error when adding a calculated field based on a metric in the dataset as well.

Hi folks,

This does look to be an issue with validation on our side - our team are aware and are investigating a fix for this.

2 Likes