Use stats from different tables in a costum report

[DeepMig]

Hello,

When i create a custom report i have to choose the section and i believe each section corresponds to a different table in the database.
I would like to know if i can use stats from different tables in the same report.
For example, i want to include a stat from table 'holdem_hand_summary' in a report with stats from section 'holdem cash hand'.

Thanks.

[WhiteRider]

The sections do not refer to individual database tables, just the type of information. Please see the "Sections" part of the Tutorial: Custom Reports and Statistics for more information.
If you have built (or want to build) a stat to display information from the holdem_cash_hand field in a report in Holdem Cash Hands then that should work fine as it's all information about individual hands.

[DeepMig]

Ok, so lets say i want to make a report with 3 columns:
column 1 is the hand#
column 2 shows 1 if there was a showdown in the hand and 0 if there was no showdown
column 3 shows the winning hand at showdown

How can i make such a report?
I noticed the winning hand is stored in 'holdem_hand_summary' table, but it's not available for reports in section 'holdem cash hand'.
As for the existence of a showdown, is this information stored in the database? I found column flg_showdown, but this is for individual players, what i would like to know is if a showdown happened in the hand or not.

Thanks.

[kraada]

id_win_hand is only populated when a winning hand is known - if you filter for times that value is positive you'll only see hands that reached showdown.