bombpot stats

[rhalala]

hi, anyway to create customs stats for the hud for bombpot ? (ACR)

i tried adding this to the columns... but no success, thank you!

You can do that using a filter expression in a custom report:

Code: Select all

cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_histories.history like '%BombPot%'

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.

[Flag_Hippo]

I am not sure what your exact issue is so can you please provide more specific details. If for example a column expression isn't validating then post the full expression that you are using.

[rhalala]

sure , for example :

(cnt_f_saw_won_bp56 / cnt_f_saw_bp56) * 100

cnt_f_saw_won_bp56 = sum(if[cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_f_saw AND cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_histories.history like '%BombPot%' and cash_hand_player_statistics.cnt_players between 5 and 6, 1, 0])


cnt_f_saw_bp56 = sum(if[cash_hand_player_statistics.flg_f_saw AND cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand and cash_hand_histories.history like '%BombPot%' and cash_hand_player_statistics.cnt_players between 5 and 6, 1, 0])


the expression syntax are correct but when using it in reports/hud it takes forever to load, and it show nonsense data, huge numbers...

thank you!

[Flag_Hippo]

That's fine but I would add also a site check for WPN specifically:

cnt_f_saw_won_bp56

Code: Select all

sum(if[cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_f_saw AND cash_hand_summary.id_site = 2400 AND cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand AND cash_hand_histories.history like '%BombPot%' and cash_hand_player_statistics.cnt_players between 5 and 6, 1, 0])

cnt_f_saw_bp56

Code: Select all

sum(if[cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_f_saw AND cash_hand_summary.id_site = 2400 AND cash_hand_histories.id_hand = cash_hand_player_statistics.id_hand AND cash_hand_histories.history like '%BombPot%' and cash_hand_player_statistics.cnt_players between 5 and 6, 1, 0])

Your new custom columns will also require a custom cache rebuild via 'Database > Database Management > Rebuild Cache > Custom Cache Rebuild' to populate correctly however please note columns that reference cash_hand_histories.history dramatically slow down cache rebuilds and the larger your database is the longer that will take. For example on a small database this can increase the cache rebuild from seconds to several minutes so the larger the database the bigger the impact.