Linked Questions

Popular Questions

I need a weekly (period_ending_date) count of items by category.

The tables/views I need to use for this query are vw_pog_delhaize_historical and dim_item.

The “category” grouping is the field dim_item.mdlz_biz which is in dim_item.

I only want results starting from 1/1/2018 forward.

vw_pog_delhaize_historical has 3 columns:-


vw_pog_delhaize_historical and dim_item can be joined by itemid column.

Related Questions