Rakeback line in graph

[bruceadms]

hello
Would you like to know how to put the rakeback line on the graph?
Is it possible to configure the same line adding different rakebacks from different sites?
for example: 50% pokerstars and 30% ggpoker
the line already calculates these values

[Flag_Hippo]

For rakeback you will need to add a custom statistic and these are available for download in our Custom Stat Warehouse. To import statistics into PokerTracker 4 either use 'File -> Import Statistic' or go to 'Configure -> Statistics' and click the 'Options' button. To add rakeback to your graphs see this tutorial video. There are also site specific rakeback statistics in the warehouse that can be edited for use on other sites - see this guide for the basics on custom statistics creation. The relevant site ID for PokerStars is 100 and for GGPoker it is 3200.

[bruceadms]

I couldn't do it
I already managed to put the rakeback line on the graph
but I can't configure it to create this condition
50% rakeback on pokerstars, 20% on bodog/ignition and 20% on gg poker

Would I have to create stats in columns?
what is the expression?
How to associate the column to stats?
you could help me?

[WhiteRider]

As Flag_Hippo suggested previously, to make a stat specific to a site you will need to include a test for the site ID in the column expression.

For example PokerStars is site ID 100, so you need to include "cash_hand_summary.id_site = 100" as part of the condition.

At the most basic level that looks like:

amt_rakeback_ps =
sum( if[cash_hand_summary.id_site = 100, cash_hand_summary.amt_rake * 0.5, 0])

Your rakeback expression is likely to be more complex than that, but that is just to show you how to do the site test.

Ignition site ID is 2700, and GGPoker is 3200.

[bruceadms]

amt_rakeback_ps =
sum( if[cash_hand_summary.id_site = 100, cash_hand_summary.amt_rake * 0.5 AND cash_hand_summary.id_site = 2700, cash_hand_summary.amt_rake * 0.24, 0])

"The statement is not valid SQL"

was very hard to do

and i tried a lot , but i cant

[WhiteRider]

All of the "condition" parts need to be together in the first part of the IF statement.

It would be simpler to make separate columns for each site, and then add them together in a stat, but if you want to do it all in one then you'll need to nest your IFs for each site, like this:

sum( if[cash_hand_summary.id_site = 100, cash_hand_summary.amt_rake * 0.5, if[cash_hand_summary.id_site = 2700, cash_hand_summary.amt_rake * 0.24, 0]])

[bruceadms]

Could you send a photo or print?
i have the same error
The statement is not valid SQL

[Flag_Hippo]

If you are referring to WhiteRiders reply then that is valid SQL: