Hi, does anyone know how to remove the currency in the result? I need to have the decimal numbers as the average weight without the currency.
I tried using ‘CAST’ but ShopifyQL does not recognize it. I also tried ‘strip_currency’ but I’m getting the ‘must be a column name’ error.
Here’s the query I’m using where I was able to get the average weight result but the problem is the currency symbol:
FROM sales
SHOW net_items_sold, (gross_sales / product_variant_price) AS average_weight, gross_sales, discounts, returns, net_sales, taxes, total_sales, gross_profit, gross_margin
WHERE is_pos_sale = true AND product_title_at_time_of_sale = ‘Liquid Laundry Detergent - In Store REFILL - Linden Flower’
GROUP BY product_title_at_time_of_sale, pos_location_name, product_vendor_at_time_of_sale, product_type_at_time_of_sale, product_variant_price
WITH TOTALS
SINCE startOfDay(-30d)
UNTIL today
ORDER BY total_sales DESC
LIMIT 1000
VISUALIZE average_weight TYPE horizontal_bar
