Extended Beer Stats: Your Ratings by Style, State, and Country

Discussion in 'BeerAdvocate Talk' started by Todd, Aug 27, 2018.

  1. Todd

    Todd Founder (5,608) Aug 23, 1996 California
    Staff

    Today I woke up and tackled one of the top requested features from (at least) the past decade: the ability to view all of the beers that you've rated, broken down by beer style, US state, and country.

    Premium members now have access to this new perk which is currently in beta testing. It's very straight forward, but does the trick.
    • Head to your your Beers list.
    • You'll now see some new sub-nav a stats icon and links to Styles, US States, and Countries.
    • Click to view the breakdowns including the number of beers rated per item and its percentage against the data set.
    Like I said, it's very straight forward, however, from there you can click an item which will pass it to your Beers list and apply it as a filter. For example, you can now view every:
    • American IPA that you've rated
    • beer from California that you've rated
    • beer from Germany that you've rated
    ...but without all of the clutter. You can still sort the columns, and clicking the "x" next to the applied filter will reset the list, and you can seamlessly jump between your list, stats, etc.

    Notes:
    • List are not viewable by the public. Only logged in Premium users can view their own stats.
    • Stats are updated daily based on the last time the system recorded your activity.
    • Countries: only the ones you've rated beers from are listed to reduce the list size.
    • Applying multiple filters isn't supported.
    • This is just the beginning of offering more in-depth personal user stats.
    • I plan on applying this to Places (post-beta), too.
    And, in case you missed it, last week I also added the BA Score to your Beers list and tweaking the columns names a bit.

    Questions? Suggestions? Feedback? I'm all ears.

    In the meantime, I hope all of you Premium members enjoy this long-overdue feature.

    Not a Premium member? Now's a good time to become one:

    https://www.beeradvocate.com/premium/

    Thanks for your support.
     
  2. superspak

    superspak Poo-Bah (23,752) May 5, 2010 Michigan
    Premium Trader

    Awesome looking clean layout and design. Great work Todd. Much appreciated.
     
  3. alexsergio

    alexsergio Meyvn (1,079) Mar 7, 2011 New York
    Premium Trader

    This is awesome. Thank you.
     
    dcotom and Todd like this.
  4. tone77

    tone77 Poo-Bah (5,430) May 20, 2009 Pennsylvania
    Premium

    I absolutely love it. Great work.
     
    dcotom likes this.
  5. dcotom

    dcotom Poo-Bah (2,000) Aug 4, 2014 Iowa
    Premium Trader

    I'll check this out in detail, but my first impression is that it's very well thought out and very well executed. Thank you!
     
    tone77 and Todd like this.
  6. bbtkd

    bbtkd Poo-Bah (2,103) Sep 20, 2015 South Dakota
    Premium Trader

    Love it! Very handy!
     
    Todd likes this.
  7. singletary

    singletary Zealot (548) Nov 8, 2015 Mississippi
    Premium

    Great job, this is something I have hoped to see one day. Thank you very much.
     
    Todd likes this.
  8. jkblr

    jkblr Meyvn (1,345) Nov 22, 2014 Indiana
    Premium Trader

    Awesome
    I was literally doing this the long way today to see what percentage of my beers fell into the popular styles. Thanks!
     
    Todd likes this.
  9. FBarber

    FBarber Poo-Bah (2,449) Mar 5, 2016 Illinois
    Premium Trader

    Oh my goodness @Todd this is fantastic!!! Thank you so much!

    *double checks to make sure that my premium membership is up to date*
     
    Todd likes this.
  10. Tucquan

    Tucquan Poo-Bah (2,778) Oct 11, 2007 Pennsylvania
    Premium Trader

    Excellent. Yay! Thanks.
     
    Todd likes this.
  11. superspak

    superspak Poo-Bah (23,752) May 5, 2010 Michigan
    Premium Trader

    I've been messing around with it a bit now. Sorting by states/countries/styles by any column works perfectly; but only on the first page. Bug #1: If you click to next 50 it will blow out all filters, but still keep the column you sorted.
     
    Sabtos, FBarber and Todd like this.
  12. Todd

    Todd Founder (5,608) Aug 23, 1996 California
    Staff

    Thanks for the catch. I reordered some code blocks earlier and it broke pagination. It's been fixed.
     
    Vidblain, sulldaddy, beergoot and 5 others like this.
  13. LiquidAmber

    LiquidAmber Poo-Bah (6,105) Feb 20, 2009 Washington
    Premium

    Wow! This has been my number one wish since starting here, since I joined BA to keep track of my beer reviews. The layout is great and interaction with the database gives me the information I want to see. Well done.
    I also have kept track of my reviews in an Access database and expected to solve one of the greatest mysteries I've had for 4 years: why do I have one more state in my database than in the total here? Oddly, they both agree now, so either the calculation has changed or I serendipitously drank just the right beer in the last few months. They don't match exactly, mostly because I kept the old breakdown of Great Britain by region, which I kind of like for my tracking (but this is easy to match up with the BA stats).
    The only suggestion I'd make is some kind of explanation of the numbers (I think it's actual number of reviews, not breweries) and the percentages, which don't don't add up to 100%.
    Still a very welcome and excellent Beta.
    Thanks!
     
  14. Todd

    Todd Founder (5,608) Aug 23, 1996 California
    Staff

    Correct. It's the percentage of ratings per style, US state, or country.
     
    FBarber likes this.
  15. AllHopsMatter

    AllHopsMatter Defender (622) Jul 16, 2016 California
    Premium Trader

    This is awesome, thanks!
     
    Todd likes this.
  16. donspublic

    donspublic Poo-Bah (1,599) Aug 4, 2014 Texas
    Premium Trader

    Gobsmacked, simply gobsmacked. Thanks for the effort.
     
    Amendm, FBarber and Todd like this.
  17. jakecattleco

    jakecattleco Poo-Bah (1,855) Sep 3, 2008 California
    Premium Trader

    Many thanks, the scientist and data fiend in me loves this perk!
     
    meefmoff, dcotom and Todd like this.
  18. TheGent

    TheGent Meyvn (1,394) Jun 29, 2010 New Jersey
    Premium Trader

    Sweet!
     
    Todd likes this.
  19. Tripel_Threat

    Tripel_Threat Poo-Bah (2,163) Jun 29, 2014 Michigan
    Premium Trader

    Yes!!!
     
    Todd likes this.
  20. SLeffler27

    SLeffler27 Poo-Bah (1,924) Feb 24, 2008 New York
    Premium Trader

    After a quick survey, this is going to be one of my favorite features. Thanks for tackling it. I especially like the graphic bar chart. As other have said, I will noodle around and send feedback.

    And I just might have to repost on my “Drink Local” percentage.
     
    FBarber, dcotom and Todd like this.
  21. Harrison8

    Harrison8 Poo-Bah (2,883) Dec 6, 2015 Missouri
    Premium Trader

    Great work! Love the break down with number of beers and also a percent of total consumption.
     
    Amendm and Todd like this.
  22. cryptichead

    cryptichead Savant (945) Jul 3, 2014 Illinois
    Trader

    Will this eventually be rolled out to non-premium members or will this remain an exclusive premium membership perks? Thanks!
     
  23. Todd

    Todd Founder (5,608) Aug 23, 1996 California
    Staff

    It's going to be exclusive to Premium for the foreseeable future.
     
  24. Mikexw

    Mikexw Savant (939) Mar 3, 2014 New York
    Premium Trader

    Thank you so much, and so glad I'm premium -- this is a cleaner and easier way of looking at stuff that I've been doing on my own for a few years. Nice job!
     
    Todd likes this.
  25. Dragginballs76

    Dragginballs76 Poo-Bah (2,124) Nov 13, 2015 South Carolina
    Premium Trader

    Wow this is amazing!!! Thanks.
     
    Todd likes this.
  26. LeRose

    LeRose Meyvn (1,333) Nov 24, 2011 Massachusetts
    Premium

    This is fantastic - easy to follow, easy to use. I had done something similar with my Excel spreadsheet and it was a PITA to get it to work - now I don't have to fuss with it anymore!

    Great job and thanks!
     
    Amendm, Harrison8, Mikexw and 2 others like this.
  27. Squire

    Squire Poo-Bah (2,030) Jul 16, 2015 Mississippi
    Premium Trader

    Excellent addition, thanks.
     
    Tripel_Threat, Amendm and Todd like this.
  28. Buck89

    Buck89 Poo-Bah (2,326) Feb 7, 2015 Tennessee
    Premium Trader

    This is outstanding!
     
    Todd likes this.
  29. cbcrunch

    cbcrunch Poo-Bah (1,551) Jan 21, 2012 Wyoming
    Premium

    This is great!
    Thanks
     
    Todd likes this.
  30. TrojanRB

    TrojanRB Meyvn (1,200) Jul 27, 2013 California
    Premium Trader

    This is fantastic!
     
  31. Beginner2

    Beginner2 Poo-Bah (2,320) Feb 14, 2016 Illinois
    Premium

    Mega-cool.
    I knew all that !!
    (Actually not, some interesting surprises lurking in the stats.)
     
    Amendm and Todd like this.
  32. EMH73

    EMH73 Poo-Bah (1,529) Sep 16, 2015 New York
    Premium Trader

    Awesome feature, thanks.
     
    Amendm and Todd like this.
  33. MonDak_Joe1953

    MonDak_Joe1953 Poo-Bah (1,501) Aug 4, 2017 Minnesota
    Premium Trader

    Excellent addition and well done. Actually more than what I expected to be rolled out for such additional search features. All of this really helps a lot. Thanks much.
     
    Mikexw, Amendm and Todd like this.
  34. JamFuel

    JamFuel Poo-Bah (2,854) Mar 26, 2009 Sweden
    Premium

    Great stuff, been hoping for this to become a feature!
     
    Amendm and Todd like this.
  35. vabeerguy

    vabeerguy Poo-Bah (1,831) Sep 21, 2015 Virginia
    Premium

    Nice feature! Thanks
     
    Todd likes this.
  36. Amendm

    Amendm Disciple (346) Jun 7, 2018 Rhode Island
    Premium

    Thanks, this is a big help. I just realized I have yet to review a beer from Connecticut-a neighboring state.
     
    Todd likes this.
  37. Tripel_Threat

    Tripel_Threat Poo-Bah (2,163) Jun 29, 2014 Michigan
    Premium Trader

    After playing around with the new features I have to say - and keeping with the no memes policy - [insert Christopher Eccleston "fantastic" gif]
     
    Todd and Amendm like this.
  38. cryptichead

    cryptichead Savant (945) Jul 3, 2014 Illinois
    Trader

    I pulled the trigger on the Premium membership. Love the stats!

    Quick question: my state count has been bothering me for ages (i.e., that my count is greater than the BA count). BA is showing me at 40 states. When I look at the BA list, it is actually showing 42. Is there a way to know which 2 are not being counted? (i.e., probably master state listings?). Thanks!
     
    Todd likes this.
  39. TheIPAHunter

    TheIPAHunter Poo-Bah (1,601) Aug 12, 2007 Pennsylvania
    Premium Trader

    You knew it was coming, but here it is, regardless. Todd, this is LARRRGE!
     
    Shanex and Todd like this.
  40. Todd

    Todd Founder (5,608) Aug 23, 1996 California
    Staff

    Thanks for the catch. I forgot to exclude old master listings from the results. Results on the beer stats page should be synced with your user stats now.