Obsidian

[Wookie7969]

Jun 6, 2023 15:06:23 GMT -5 throwingtoasters said:

Here's my code:

```dataview
LIST
FROM "Wrestlers"
where Type = "wrestler"
where Feds[number(CurrentFed)] = "PNW"
SORT name ASC
```

That worked, thank you so much man, and thanks again for the obsidian videos and template in the first place. It's been an absolute gift for managing my various feds

[Wookie7969]

How do I make a ranking system for all time Wins and loses. So similar to the PWI ranking but rather than just showing current fed it would show a wrestlers all time Wins and Losses

[throwingtoasters]

Jul 13, 2023 13:40:47 GMT -5 Wookie7969 said:

How do I make a ranking system for all time Wins and loses. So similar to the PWI ranking but rather than just showing current fed it would show a wrestlers all time Wins and Losses

Use the same code but take out the line about where Feds[number(CurrentFed)] = "PNW" or whatever your fed is.

[Wookie7969]

Jul 13, 2023 15:32:21 GMT -5 throwingtoasters said:

Jul 13, 2023 13:40:47 GMT -5 Wookie7969 said:

How do I make a ranking system for all time Wins and loses. So similar to the PWI ranking but rather than just showing current fed it would show a wrestlers all time Wins and Losses

Use the same code but take out the line about where Feds[number(CurrentFed)] = "PNW" or whatever your fed is.

Do I need to add anything. It's still displaying individual Wins and loses for the wrestlers who have multiple feds rather than an overall total.

Essentially I'm trying to do the PWI rankings but for an "all time" ranking rather than just whatever fed a wrestler is currently active in being counted but for the life of me I cannot figure out the code

[throwingtoasters]

Jul 14, 2023 20:15:09 GMT -5 Wookie7969 said:

Jul 13, 2023 15:32:21 GMT -5 throwingtoasters said:

Use the same code but take out the line about where Feds[number(CurrentFed)] = "PNW" or whatever your fed is.

Do I need to add anything. It's still displaying individual Wins and loses for the wrestlers who have multiple feds rather than an overall total.

Essentially I'm trying to do the PWI rankings but for an "all time" ranking rather than just whatever fed a wrestler is currently active in being counted but for the life of me I cannot figure out the code

This is how mine looks. Depending on how you named/label things it’ll probably need tweaks. But this works for me:

```dataview
TABLE WITHOUT ID link(file.name) as "Wrestler",choice(!Feds[number(CurrentFed)], "--",Feds[number(CurrentFed)]) as "Promotion",choice(!Wins[number(CurrentFed)], sum(Wins), Wins[number(CurrentFed)]) as "W",choice(!Losses[number(CurrentFed)], sum(Losses), Losses[number(CurrentFed)]) as "L",choice(!Draws[number(CurrentFed)], sum(Draws), Draws[number(CurrentFed)]) as "D", link(championship) as "Title" FROM "Wrestlers" where Type = "wrestler"
sort (sum(Wins) * 2) - sum(Losses) + sum(titleweight) desc
```

[Wookie7969]

Jul 15, 2023 11:43:09 GMT -5 throwingtoasters said:

Jul 14, 2023 20:15:09 GMT -5 Wookie7969 said:

Do I need to add anything. It's still displaying individual Wins and loses for the wrestlers who have multiple feds rather than an overall total.

Essentially I'm trying to do the PWI rankings but for an "all time" ranking rather than just whatever fed a wrestler is currently active in being counted but for the life of me I cannot figure out the code

This is how mine looks. Depending on how you named/label things it’ll probably need tweaks. But this works for me:

```dataview
TABLE WITHOUT ID link(file.name) as "Wrestler",choice(!Feds[number(CurrentFed)], "--",Feds[number(CurrentFed)]) as "Promotion",choice(!Wins[number(CurrentFed)], sum(Wins), Wins[number(CurrentFed)]) as "W",choice(!Losses[number(CurrentFed)], sum(Losses), Losses[number(CurrentFed)]) as "L",choice(!Draws[number(CurrentFed)], sum(Draws), Draws[number(CurrentFed)]) as "D", link(championship) as "Title" FROM "Wrestlers" where Type = "wrestler"
sort (sum(Wins) * 2) - sum(Losses) + sum(titleweight) desc
```

Thanks for this. I tweaked it slightly and got it working.

```dataview
TABLE WITHOUT ID link(file.name) as "Wrestler",choice(!Feds[number(CurrentFed)], "--",Feds[number(CurrentFed)]) as "Promotion", sum(Wins) as "W", sum(Losses) as "L", sum(Draws) as "D", link(championship) as "Title" FROM "Wrestlers" where Type = "wrestler"
sort (sum(Wins) * 2) - sum(Losses) desc
LIMIT 25
```

Also added a limit to help with the loading

[Rex Havoc]

Has anyone run into trouble with the new update not allowing you to add to the win, lose or draw columns as it says its a broken link? My obsidian updated yesterday and now it has the win loss and draws in orange and not allowing me to change it up at all. I have done the right click on it and went to property and selected number but it didn't fix it. Was wondering if anyone else has run into this yet?

[throwingtoasters]

Mine seem to be working well since the update. Have you updated all your plugins as well? I think the Core plug ins update automatically, but you have to check for updates from the community plugins.

[pikemojo]

I'm having the same problem. I tried checking for community plugin updates but it says they are up to date. Maybe the community plugins take a little time to get fixed since they rely on the community rather than the company behind Obsidian?

[throwingtoasters]

Found a fix. Settings → Editor → Properties in document - Set to source. That should fix it.