New Library Insights charts

Library Insights now has charts for By Country, By State / Region, By Appellation / AVA, Bottle Age, Consumption Over Time, What You Actually Drink, and Removal Reasons — alongside the existing varietal, vintage, and drinking-window views. Each chart drills down into a filtered cellar list. Available to Collector tier and above.

Library Insights launched with a small set of charts focused on what’s in your cellar. We knew almost immediately that there was a whole other set of questions worth answering: what do I actually drink, versus what I just collect? — am I building a regional cellar without realizing it? — which bottles am I letting age too long?. Those questions need a richer set of aggregations.

Seven new charts answer them. Geography breaks down into a donut of countries, then bar charts by state/region and by appellation. Bottle Age plots a histogram across age buckets (0-2y, 3-5y, 6-10y, 11-20y, 21+y, plus NV) so you can spot a cellar that’s gone heavy on one end. Consumption Over Time is a 24-month line of how many bottles you actually drank each month. What You Actually Drink filters your removals to drinking-only and shows the varietal mix — often very different from what you own. Removal Reasons splits drinking / gifted / returned / other so you can see what’s leaving your cellar and why.

Each chart drills into a filtered cellar list — tap a slice and you see the bottles behind that number.

“What You Actually Drink” is the chart that surprises most people. The varietal mix of what you remove for drinking often diverges sharply from what you store. Cellars biased toward big reds, but actual consumption that skews lighter and more varied — that kind of pattern. You don’t see it until you put both views next to each other.

We also fixed a silent truncation bug along the way. Drill-downs from these charts run through a paginated cellar query, and a multi-appellation listing was causing the underlying join to multiply rows — we were inadvertently capping a 73-row result at 20 entries. Fixed, and we added a regression test that catches it in the future.