Hi !
I would like to make some reports using expression filters, but I don't see how it works, and I don't see any tutorial.
Could you tell me how it works ?
For example, I would like to begin with a report to see the strength of bet / bet / bet.
In SQL, it would be something like that :
SELECT
lookup_hand_groups.group_name,
count(*) * 100.00 /
(
select count(*) FROM
lookup_hand_groups,
lookup_hand_ranks,
tourney_hand_player_statistics
WHERE
id_action_f = 4 AND
id_action_T = 4 AND
id_action_r IN (4, 11, 14, 19, 36, 37, 49) AND
lookup_hand_groups.id_group = lookup_hand_ranks.id_group AND
tourney_hand_player_statistics.id_final_hand = lookup_hand_ranks.id_hand_rank
) as pct
FROM
lookup_hand_groups,
lookup_hand_ranks,
tourney_hand_player_statistics
WHERE
id_action_f = 4 AND
id_action_T = 4 AND
id_action_r IN (4, 11, 14, 19, 36, 37, 49) AND
lookup_hand_groups.id_group = lookup_hand_ranks.id_group AND
tourney_hand_player_statistics.id_final_hand = lookup_hand_ranks.id_hand_rank
GROUP BY
lookup_hand_groups.id_group
ORDER BY
lookup_hand_groups.id_group
;
I could do it in pgAdmin, but how can i do it in the report section of PT4 ?
Thanks.