Multiple Leage tables sorting orders

  • Resolved acparacingteam

    (@acparacingteam)


    4 years ago

    Hi there!

    I really enjoy Sportpress plugin and it saved my life!
    Hovewer, I have this problem:

    I have a racing motorsport websites with multiple leagues. Each league standing is determined by the number of points accumulated by the players during each event. The table is therefore sorted by the column “points”. It may happen that different leagues assign events points in different ways. For example:

    League 1 has:
    1 -> 17 points
    2 -> 14 points
    3 -> 11 points
    etc..

    League 2 has:
    1 -> 25 points
    2 -> 20 points
    3 -> 17 points
    etc..

    I added two “Points” column entries in Sportpress->configure->column table in the following way:

    Points = 1×17 + 2×14 + 3x 11 + …
    Points (esteso) = 1×25 + 2×20 + 3×17 + …

    The problem is that I can only order all the league tables according to either Points or Points (esteso).

    Is there a way to order League 1 by Points and League 2 by Points (esteso)?

    Many thanks

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Roch

    (@rochesterj)

    Hi there!

    Thanks for reaching out.

    Unfortunately no, that isn’t possible. The easiest way around this would be creating multiple positions to reflect the points you add.

    So instead of 1st, 2nd, 3rd… You’ll have 1st-25, 1st-17, 2nd-20, 2nd-14 and so on.

    You don’t need to name them like that, but you do need the separate positions even if they are for the same place.

    Thanks!

    Thread Starter acparacingteam

    (@acparacingteam)

    Oh no!

    And then I would have a single Points column like this I guess:

    Points = 1st-25 x 25 + 1st-17 x 17 + 2nd-20 x 20 + 2nd-14 x 14 + …

    Is that correct?

    Roch

    (@rochesterj)

    Hi there!

    Yes, that’s correct.

    There is another way to do this with one set of event outcomes, but it is very complex. To be honest, if you can add it using different outcomes it’s better. But if you think that this will be too hard to maintain, we can use this alternate method (but it requires A LOT of work in the setup).

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Multiple Leage tables sorting orders’ is closed to new replies.