Page 1 of 2

session start time customized (2 hours earlier) .WHERE SAVE?

PostPosted: Sun Oct 07, 2012 7:27 am
by marvin
1) i wish create 1 stat that define start time of session 2 hours before than appear on history hands. how can i do? where i can customize it for found it when i want configure the report STATISTIC CASH-SUMMARY-GROUPED BY SESSION?

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Sun Oct 07, 2012 8:52 am
by kraada
Can you explain a bit about what you are trying to accomplish by doing this? If you are having problems with sessions running over midnight and getting split over two different days you can change your "My Day Starts At" value in the Configure -> Reporting Options area and that will solve your problem without custom stats.

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Sun Oct 07, 2012 9:06 am
by marvin
my problem is that i dont know why, but PT4 shows "04:00 pm" if the session starts on 02:00 pm (may be why poker room is on another time zone?) so i wish correct it with another stat that use that variable - 2 hours. how is the syntax for doing that? i wish correct also the format, using 24 hr (i wish have 16:00 instead 4:00 pm)

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Sun Oct 07, 2012 10:22 am
by kraada
We do not have localization setups to show 24 hour clocks. What site are you playing at?

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Tue Oct 09, 2012 2:50 am
by marvin
i think is a PT4 bug.
the site is Netbet.it (Ipoker network for italian players). now (at 8:38 am) i have tried to play 5-6 hands. italian hour is 8:38 am, and the HH loaded on my hard disk shows correctly 8:38:

M2FC3300656450CL</tablename> <tablecurrency>EUR</tablecurrency> <duration>00:04</duration> <gamecount>12</gamecount> <startdate>09/10/2012 08:38</startdate>
PT4 hand history viewer shows 8:38, BUT REPORT (cash, Play Poker, View Today Hands, My Hands, Time) SHOW start time = 10:38!!

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Tue Oct 09, 2012 3:53 am
by WhiteRider
The problem is that iPoker do not specify the time zone in their hand histories, so PT4 does not know how to adjust it. We plan to add an option to configure time adjustments on a per-site basis – if you want to get a notification when this functionality is added please open a Support Ticket.

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Thu Oct 11, 2012 6:18 pm
by marvin
cant i create a customized stat? if i can how would be it? (start session customized = start-120 min)

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Fri Oct 12, 2012 3:45 am
by WhiteRider
You could create a custom stat, but you'd need a few for different report types, and it wouldn't affect things like filters and day groupings, so I'm not sure how practical it would be.

If you want to try this, duplicate the stat you're interested in, and the column it uses, and add something like this to the time expression in the column:

- interval '2 hours'

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Sat Oct 13, 2012 3:40 pm
by marvin
i have created new stat, "session start - 2", duplicating "session start" and its column (session_date_start).
i have generated session_date_start_minus2 (a new column, with this expression:
datefix_fromutc_noadjust[ cash_table_session_summary.date_start - interval '2 hours']

Then, my new stat is: "session start - 2" with this expression: "session_date_start_minus2"
in the report it shows "Invalid Date: 15" (instead session start shows "20/10/09 1:02 am")

Re: session start time customized (2 hours earlier) .WHERE S

PostPosted: Sat Oct 13, 2012 4:25 pm
by kraada
Try it like this instead:

datefix_fromutc_noadjust[ cash_table_session_summary.date_start ] - interval '2 hours'

highfalutin