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.

1 Like

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

Having same issue, simple arithmetic operation and GROUP BY giving error.

@Liam-Shopify - will you post here again when this issue has been resolved please, so we can re-attempt these calculations? Thank you!

Hi Sue,

I’ll post here where the bug has been fixed - no ETA to share right now but I’m tracking the issue.

1 Like

Would love an update on this please, simple fix please