Search found 11406 matches

Return to advanced search

Re: Number

I don't know why that is since I am not familiar with the COUNT function in PostgreSQL but if I find out anything about that I'll let you know.
by Flag_Hippo
Sun Nov 28, 2021 5:51 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Number
Replies: 10
Views: 257

Re: Windows 11 issue

If zip/compress the PokerTracker4.log file that will make it small enough to attach to your ticket.
by Flag_Hippo
Sun Nov 28, 2021 5:51 am
 
Forum: PokerTracker 4
Topic: Windows 11 issue
Replies: 19
Views: 945

Re: Number

Do this then:

Code: Select all
sum(if[tourney_hand_player_statistics.id_hand = 5440, 1, 0])
by Flag_Hippo
Sat Nov 27, 2021 2:04 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Number
Replies: 10
Views: 257

Re: Number

Apologies for the misunderstanding and you are right with regards to that however id_hand is a grouping statistic so it is not going to work in the HUD (see the eighth exception listed here ) and unfortunately I don't have any SQL for what you are trying to do here but if a PostgreSQL expert sees th...
by Flag_Hippo
Sat Nov 27, 2021 1:30 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Number
Replies: 10
Views: 257

Re: unable to create postgreSQL

If you don't remember the password you used when you reinstalled PostgreSQL then please refer to this guide.
by Flag_Hippo
Sat Nov 27, 2021 12:18 pm
 
Forum: PokerTracker 4
Topic: unable to create postgreSQL
Replies: 1
Views: 71

Re: Aliases Not Combining

That's a known issue that has now been reported to the development team. If you would like to be automatically notified if this is resolved in a future update you can open a Support Ticket and quote reference #7030.
by Flag_Hippo
Sat Nov 27, 2021 12:14 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Aliases Not Combining
Replies: 2
Views: 67

Re: Number

If a player has an id_hand of 5440 then that would mean they have played 5440 hands or more so you want the HUD to display '1' when that is the case? To do that duplicate the existing 'Hands' statistic, change the 'Format Type:' to 'Expression' and use this:

Code: Select all
if(this >= 5440, format('1'), '-' )
by Flag_Hippo
Sat Nov 27, 2021 12:13 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Number
Replies: 10
Views: 257

Re: specify 2bet size

There can be an issue when using 'AND' (uppercase) within an expression filter on a hand report. Things will work if you either change the hand dropdown to 'All Hands' or if you edit the expression to use only lowercase 'and'.
by Flag_Hippo
Sat Nov 27, 2021 12:11 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: specify 2bet size
Replies: 7
Views: 294

Re: statistical indicator that counts the number

Unfortunately I don't know of a method to achieve that.
by Flag_Hippo
Sat Nov 27, 2021 12:10 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: statistical indicator that counts the number
Replies: 1
Views: 77

Re: not indicated in the hud

A custom column using a subquery cannot be stored in the database cache so its performance may be poor- see here.
by Flag_Hippo
Fri Nov 26, 2021 1:34 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: not indicated in the hud
Replies: 1
Views: 72
PreviousNext

Return to advanced search

cron
highfalutin