Formula When Teams have equal Points

  • Resolved c05338

    (@c05338)


    3 years, 11 months ago

    I’m trying to create a formula for Column for teams that have equal points.

    So let’s say if we have 3 teams with 20Pts. Usually after points it compares goalsfor and goalsagainst and goals difference like below

    # Team P W D L F A GD PTS
    1 WordPress 8 6 0 2 22 5 17 18
    2 SportsPress 8 5 3 0 16 4 12 18
    3 bbPress 8 5 3 0 7 1 6 18

    However our formula is different. If we have 3 teams with equal points the column should first search if those teams have played against each other and the winner will be on top of the other for example:

    SportsPress x WordPress = SportsPress
    Wordpress x bbPress = bbPress
    bbPress x SportPress = SportPress

    The Column should be as below:
    # Team P W D L F A GD PTS
    1 SportsPress 8 5 3 0 16 4 12 18
    2 bbPress 8 5 3 0 7 1 6 18
    3 WordPress 8 6 0 2 22 5 17 18

    I tried multiple formulas in configuration section but none has worked. Kindly suggest a solution, thank you!

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hi there!

    Thanks for reaching out.

    Actually, you can use the H2H tiebreaker for this.

    SportsPress > Settings > Teams > League Tables > TieBreaker > Head to Head:
    https://prntscr.com/w7f86q

    With it, when there’s a tie SportsPress is going to re-apply the ordering rules considering only events between the teams that are tied.

    Thanks!

    Thread Starter c05338

    (@c05338)

    Hi,

    Thank you for your reply.

    It’s already set however it’s not giving the right standing.

    When there’s a tie and tied teams played against each other the winner is on top of the loser regardless of his goals for or goals against or any other reference. The first rule to consider is the winner between tied times if they played against each other.

    Also I have another problem, only 1 league table isn’t auto updating the standings I have to update it manually every time.

    Hi there!

    Thanks for your reply.

    Please kindly open a new topic for the new issue, so it won’t get too confusing.

    Regarding your first issue, I’m not sure if I get it. Isn’t that what you wanted? First order teams by point, then order by head to head tiebreaking (which just applies points considering only the match between these 2 teams).

    Thanks!

    Thread Starter c05338

    (@c05338)

    Hi,

    I’ll open a new topic for the other issue.

    For the main issue. I’m not sure if I explained correct and I was able to deliver the message

    I have now 3 teams have tie points I’ll share the table for them below.

    # Team P W D L F A GD PTS
    1 TeamA 9 7 0 2 23 5 18 21
    2 TeamB 9 6 3 0 19 5 14 21
    3 TeamC 9 6 3 0 8 1 7 21

    As you can see in the table I have 3 teams with equal points total of 21. The above ranking is probably based on F and GD parameters.

    However it should be ranked as below
    # Team P W D L F A GD PTS
    1 TeamB 9 6 3 0 19 5 14 21
    2 TeamC 9 6 3 0 8 1 7 21
    3 TeamA 9 7 0 2 23 5 18 21

    Because TeamA played against TeamB and TeamB has won so TeamB before TeamA
    Than TeamA played against TeamC and TeamC has won so TeamC before TeamA
    Than TeamB played against TeamB and TeamB has won so TeamB before TeamC

    Ending up the above ranking table based on each strike.

    head-to-head didn’t do the trick. I hope I was able to clarify what I’m asking for

    Hi there!

    Thanks for your reply.

    The H2H criteria should work, as long as the only ordering criteria you have under SportsPress > Configure > Table columns is the points (make sure points is the only column with “order” attribute).

    If that doesn’t work, it could be an issue with your specific setup. Maybe the 3-way tie is breaking how that logic works.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Formula When Teams have equal Points’ is closed to new replies.