store_credit_summaries

Examples

• Description

  Split the `ending_store_credit_balance` your store owes over the last seven days by currency. This example uses [`WITH TOTALS`](/docs/api/shopifyql/latest/syntax/with#total-columns) to add a total beside the per-currency breakdown.

  ShopifyQL

  FROM store_credit_summaries
    SHOW ending_store_credit_balance
    GROUP BY store_credit_currency WITH TOTALS
    SINCE -7d UNTIL today
    ORDER BY ending_store_credit_balance DESC
  VISUALIZE ending_store_credit_balance TYPE donut

• Description

  Compare monthly `store_credit_balance_net_change` for the year to date against the same months last year. This example uses [`WITH TOTALS`](/docs/api/shopifyql/latest/syntax/with#total-columns) to add the year-to-date total net change beside the monthly bars.

  ShopifyQL

  FROM store_credit_summaries
    SHOW store_credit_balance_net_change
    TIMESERIES month WITH TOTALS
    DURING this_year
    COMPARE TO previous_year
    ORDER BY month ASC
  VISUALIZE store_credit_balance_net_change TYPE bar

• Description

  Track monthly `starting_store_credit_balance` this year as a running total. This example uses [`CUMULATIVE_VALUES`](/docs/api/shopifyql/latest/syntax/with#cumulative-values) to carry each month's balance forward into a year-to-date running total.

  ShopifyQL

  FROM store_credit_summaries
    SHOW starting_store_credit_balance
    TIMESERIES month WITH CUMULATIVE_VALUES, TOTALS
    DURING this_year
    ORDER BY month ASC
  VISUALIZE starting_store_credit_balance TYPE line

• Description

  Rank the 10 `store_credit_currency` values with the highest `starting_store_credit_balance` last month. This example pairs [`ORDER BY`](/docs/api/shopifyql/latest/syntax/order-by) `starting_store_credit_balance DESC` with `LIMIT 10`, so the sort decides which 10 currencies survive the cut.

  ShopifyQL

  FROM store_credit_summaries
    SHOW starting_store_credit_balance
    GROUP BY store_credit_currency WITH TOTALS
    DURING last_month
    ORDER BY starting_store_credit_balance DESC
    LIMIT 10
  VISUALIZE starting_store_credit_balance TYPE horizontal_bar