Filters

? Offline

Hi - is there a specific thread for questions on the filters on the stats software?
I'm trying to figure out if the "Overall" on the "Show me matches where" shows stats based on the home teams last x amount of home games and the away teams last x amount of away games. The below is just an example but I'm trying to filter records for home teams previous 5 or ten home games and similarly for away team, not the last 5 games altogether (home and away).
EG, I'm trying to find matches where at least 4 out of the last 5 home teams home games have had o 1.5 goals and at least 4 out of the last 5 away teams away games have had o 1.5 goals.
The vids I've seen so far haven't made it that clear.
Thanks

? Offline

Yeah I saw the video on that, but didn't realise you could do it for the stat subject (home away), just thought it was for the stat type (o 2.5 goals etc). Thanks again.

Andrew

Yes mate, you can have both on the same query. You can have multiple criteria on any of your filters/queries. I think I've read somewhere the limit is about 20.

? Offline

That's really useful. Thank you. Is it possible to run the home and away on the same query then? Home teams where they have scored o 1.5 in 80% or more in their last 5 home games and away teams that have scored o 1.5 in 80% or more in their last 5 away games? Or are you saying it needs to be two separate queries and I'll have to cross reference the games to find matches that have both the home and away stats I want?

Andrew

the last 5 games the home team has played at home

A

? Offline

Thank you. That makes sense. To clarify something, when you choose home team stats for the last 5 matches, does it just looks back at the home teams last 5 home matches or the last 5 matches that the home team has played home and away?

Andrew

Hi steven

I believe that using overall still applies to home playing at home and away playing away (and the number you get is the average of the two).

For the example you've given you may be better using 2 criteria on the filter filter, one for home, one for away eg.

Home - % - FTO1.5 - greater than/equal to 80
Away - % - FTO1.5 - greater than/equal to 80

You could use

Overall - % - FTO1.5 - greater than/equal to 80

but you would need to bear in mind that one team may be 100% FTO1.5 and one only 60% FTO1.5 which while it would give a figure of 80% wouldn't fit your criteria

Hope that helps
Andrew