Price Volatility

Identifies items with the most volatile prices based on frequency of changes and price range

Custom SQL query returning 20 rows (hide)

WITH price_stats AS (SELECT item_id, store_id, COUNT(*) AS price_change_count, MAX(base_price) - MIN(base_price) AS price_range FROM item_prices GROUP BY item_id, store_id) SELECT m.name, s.store_name, ps.price_change_count, ps.price_range, (ps.price_range * ps.price_change_count) AS volatility_score FROM price_stats ps JOIN menu_items m ON ps.item_id = m.id JOIN stores s ON ps.store_id = s.id ORDER BY volatility_score DESC LIMIT 20

Edit SQL

This data as json, CSV

name	store_name	price_change_count	price_range	volatility_score
Coffee Traveller	ION Orchard	3	240	720
Coffee Traveller	Pacific Plaza	2	240	480
Coffee Traveller	Liat Towers	2	240	480
Coffee Traveller	Raffles City (Level 2)	2	240	480
Coffee Traveller	Marina Bay Sands	2	160	320
Coffee Traveller	Gardens by the Bay	2	160	320
Coffee Traveller	Bird Paradise	2	160	320
Coffee Traveller	Active Garden	2	160	320
Coffee Traveller	Starbucks Sentosa Sensoryscape	2	160	320
Coffee Traveller	Universal Studios Singapore	2	160	320
Coffee Traveller	Resorts World Sentosa	2	160	320
Coffee Traveller	River Wonders	2	160	320
Coffee Traveller	One Fullerton	2	160	320
Cookie Crumble Cheesecake	Pacific Plaza	3	40	120
Good Ol' NY Cheesecake	Pacific Plaza	3	40	120
Signature Chocolate Cake	Pacific Plaza	3	40	120
Strawberry Shortcake	Pacific Plaza	3	40	120
Hojicha Tea Cream Frappuccino®	Pacific Plaza	2	60	120
Iced Oatmilk Signature Chocolate	Marina Bay Sands	2	60	120
Oatmilk Signature Hot Chocolate	Marina Bay Sands	2	60	120