Shopping at LEGO or Amazon?
Please use our links: LEGO.comAmazon
As an Amazon Associate we earn from qualifying purchases.

Total owned+wanted by everyone

OneIsLitOneIsLit CanadaMember Posts: 4
Hello,

In a custom query, I would like to add a computed column but I do not believe that is possible.

There already exists a "Total owned+wanted by everyone" column or order by.  However, I think it would be more interesting to see an exclusivity ratio.  Namely, the division of these two values.  E.g. I recently obtained a set with a low total owned value that is roughly 10% of the total wanted value. So a small "total owned / total wanted by everyone" value would be something of an indicator for exclusivity. Perhaps there is a more interesting "exclusivity" metric, that also would not suffer from divide by zero issues?

Thanks,
-petri

Comments

  • PhoenixioPhoenixio Canada/FranceMember Posts: 136
    Exclusivity is given by the total owned, that's it.  If only 1 person owns a set, it's really exclusive.  What people want doesn't factor in this at all.

    What I think what you're looking for is more akin to "resell ability", because you want to see few numbers of owners but also great desire for the set.  Which is something you'd only care about if you wanted to gauge prices for reselling, wouldn't it?
  • AstrobricksAstrobricks Minnesota, USMember Posts: 5,088
    Use the highest value of total wanted/total owned, but obviously, you don’t care about anything that no-one owns, so no divide by zero problem.
  • PDelahantyPDelahanty Petaluma, CaliforniaMember Posts: 198
    I proposed something like this over 3 years ago.  The idea wasn't well received.
    https://forum.brickset.com/discussion/29451/list-of-most-wanted-least-owned-or-least-wanted-most-owned-sets
Sign In or Register to comment.

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com Amazon

Recent discussions Categories Privacy Policy Brickset.com

Howdy, Stranger!

It looks like you're new here. Sign in or register to get started.

Brickset.com is a participant in the Amazon Services LLC Associates Program, the Amazon.com.ca, Inc. Associates Program and the Amazon EU Associates Programme, which are affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.

As an Amazon Associate we earn from qualifying purchases.