how to change the colour in report for a specific position ?

[Gustavix320]

In this Example i want 3bet Overall (not all position) be red if its smaller than 10.
So i use the normal formula and add < 10 marking colour red on the tracker ((cnt_p_3bet / cnt_p_3bet_opp) * 100) < 10

But the stats were like this

3bet PF1.png (10.22 KiB) Viewed 775 times

1 - How can i make to work only on the last one ? which is the average of all
2 - And for a specific position ? like, if i want 3bet be red on position CO if this is < 8

[Flag_Hippo]

1. You can do that with a custom statistic and this as the summary expression:

Code: Select all

if( this < 10, rgb(255,0,0), '') + format_number(this, 2, false, false )

2. That's not possible as far as I know.

[Gustavix320]

so how would my example look?
instead of "this" I replace for the definition of 3bet stat ? ? "(cnt_p_3bet / cnt_p_3bet_opp) * 100)"

[Gustavix320]

Because i copy that expression and put in there but is not valid. Say "color condition expression is not valid"

[Gustavix320]

ok forget the last posts, i got it here now, It works.
Thanks man.

So u think its not possible create for specify positions ? like, i wanted create conditions colour for raise first in EP < 15 and > 19, MP < 20 and > 25, CO < 30 and > 35, BTN < 47 > 55

And a last one: Using that example expression 3bet colour "if( this < 10..." if i want add numbers between, how would i do it ?
example: i want < 10 and > 12, can i use "AND" on the expression ? it will work ?

To finish, where can i find codes of rgb ?

[Flag_Hippo]

So u think its not possible create for specify positions ? like, i wanted create conditions colour for raise first in EP < 15 and > 19, MP < 20 and > 25, CO < 30 and > 35, BTN < 47 > 55

Not in a single statistic. You can set multiple color conditions but only the first condition that matches (highest in the color condition list) will display.

And a last one: Using that example expression 3bet colour "if( this < 10..." if i want add numbers between, how would i do it ?
example: i want < 10 and > 12, can i use "AND" on the expression ? it will work ?

If you want between 10 and 12 for the summary line then use:

Code: Select all

if(this > 10 and this < 12, rgb(255,0,0), '') + format_number(this, 2, false, false )

To finish, where can i find codes of rgb ?

https://www.rapidtables.com/web/color/RGB_Color.html

[Gustavix320]

Nice, Thanks again man.

Not in a single statistic. You can set multiple color conditions but only the first condition that matches (highest in the color condition list) will display.

does this apply so if i want to create one more color condition line?
Like, I want it to be red if it is out of ideal, and green if it is ok.

Then I thought about using it like this:

Code: Select all

if(this * 100 < 9 and this * 100 > 12, rgb(255,0,0), '') + format_number((cnt_p_3bet / cnt_p_3bet_opp) * 100, 2, false, false )
if(this * 100 >= 9 and this * 100 <= 12, rgb(0,204,0), '') + format_number((cnt_p_3bet / cnt_p_3bet_opp) * 100, 2, false, false )

Would it work ?

[Flag_Hippo]

You can replace the ELSE with a second color condition.

Then I thought about using it like this:

Code: Select all

if(this * 100 < 9 and this * 100 > 12,

Also a single value cannot be both less than 9 and greater than 12 so you will need to format like this:

Code: Select all

if(this >= 9 and this <= 12, rgb(0,204,0), rgb(255,0,0)) + format_number(this, 2, false, false)