Page 1 of 2
Report help
Posted:
Mon Mar 23, 2009 12:13 pm
by erosbandi
I would like to modify custom report of "Hit flop with pairs" in a way that i would like to see that how many times I saw flop with each pairs. I wanted to put it in a new cloumn after times coloumn.
I tried with the following expression "id_holecard in (1, 26, 49, 70, 89, 106, 121, 134, 145, 154, 161, 166, 169) AND (flg_f_saw is true)" but I got an SQL error. How shloud I write this expression?
And my other problem would be that if I create a Filter with the Simple Filters option and I click OK the newly created filter wont appear in the Edit Report Filter window. Please give me a step-by-step instruction about its usage, since it looks like very useful, but based on the Custom Report Guide I was unable to use it...
Thanks in advanced,
Andras
Re: Report help
Posted:
Mon Mar 23, 2009 1:04 pm
by WhiteRider
That id_holecard expression is actually used in the report filters, not in the columns - is that what you want to do?
If so, you can just add another filter for "flg_f_saw".
flg_f_saw is a boolean (true/false) value so you don't need "is true". (For reference, you would have to put "=true", although you don't need to do this for boolean values).
Simple filters don't appear in the edit report filters list - they are just in the simple filters window - you should see them listed above the report too, though.
Re: Report help
Posted:
Tue Mar 24, 2009 10:26 am
by erosbandi
It seems that I had not managed to express my problem well...so I would like to extend this report with a new coloumn where I can see how many times I saw flop with differnt PP's. Just like in SetOMeter, where in the rows PP's were listed and in the following coloumns were listed aswell:
- dealt
- SawFlop -------- i would like to have this information
- Flop a set
- win/loss
Where should I write this flg_f_saw filter? When I added this to the existing HitFlopWithPair report I got an SQL error, unfortunately I can not copy here...
Re: Report help
Posted:
Tue Mar 24, 2009 10:58 am
by WhiteRider
The 'hit flop with pair' report has been updated in the Repository and now (I understand, although I haven't had chance to try it myself yet) now has the information you want.
To add the new column yourself you will need to make a new statistic along the same lines as the ones already being shown in that report.
Have a look at the
Custom Statistics and Reports FAQ and how the existing stats are built and you should be able to work it out. (or download the new report and have a look how it is done)
Re: Report help
Posted:
Tue Mar 24, 2009 1:21 pm
by erosbandi
I have downloaded the new report, but I can not import it into PT3 because I got an exception and PT3 crashes. I am using PT3 beta 25.
Re: Report help
Posted:
Tue Mar 24, 2009 1:24 pm
by WhiteRider
Ah, yes, sorry - I forgot about that. That has been fixed for Beta 26, which is due for release within the next few days.
Re: Report help
Posted:
Tue Mar 24, 2009 2:16 pm
by erosbandi
Ok, thx. I will try it with the new release
Re: Report help
Posted:
Wed Mar 25, 2009 1:28 pm
by erosbandi
Unfortunately the same result with the new (26) beta....
Re: Report help
Posted:
Wed Mar 25, 2009 4:24 pm
by WhiteRider
Yes, I get an exception with that report too. I'll see if I can get the author to re-export it in Beta 26 and see if that helps.
Re: Report help
Posted:
Thu Mar 26, 2009 10:53 am
by WhiteRider
Thanks to the author (alonalbert) for re-exporting his reports and sending them to me - I can now import these reports and they are attached here.
I will try to get them updated in the Repository too.
- Hit Flop.zip
- You will need to extract the files from the zip before importing them into PT3.
- (2.94 KiB) Downloaded 132 times