stats

[PetarM]

Hello,

i can not integrate the "Round" line, the following works:

sum(if[tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 20 and tourney_blinds.amt_bb = 50, 1, 0])

but this doesn't:
tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and tourney_hand_histories.history LIKE '%Match Round I,%'

I am having a message saying that "the statement is not valid SQL"
in the same time i am using the statement in reports and it works

Please assist
thanks

[Flag_Hippo]

For use in a statistic like that you will have to rewrite it as a subquery but unfortunately I don't know how feasible that is or have any specific example for you. For more information on how SELECT works see here.

[PetarM]

I am not able to do this by myself as I am not familiar with programming.
Could you see if anyone from the moderators could help please
thanks

[Flag_Hippo]

Unfortunately I don't know of anyone with that SQL knowledge although there are some members of this forum who might see this and be able to offer some guidance.

[PetarM]

thank you
I will make a dedicated post

[PetarM]

Hello
This line seems to not work properly, at least it doesn't do what I need:

AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 20

What i need is all the hands with starting stack between 10 and 20... this line gives me another starting stack sizes as well

thank you

[PetarM]

should i use this one instead:
(tourney_hand_player_statistics.amt_before / tourney_blinds.amt_bb) BETWEEN 10 AND 20

[Flag_Hippo]

amt_before is the players actual stack at the beginning of a hand whereas the effective_stack is the most they could potentially lose in a hand as of their first action in a hand.