The statistic works but I would like to color code the Player Types in some categories.
The first 3 blue...the next 3 red and the last 3 green
I tried color conditions expressions, but couldn't figure it out.
For example, I tried "If (Player Type = "SUPERNIT" or PLAYER TYPE = "NIT" or PLAYER TYPE = "TAGFISH")....but that didn't work. "Color Condition Expression is NOT Valid"
How would I do that? Here is the code:
- Code: Select all
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 9, format('SUPERNIT'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 8 and (cnt_vpip / (cnt_hands - cnt_walks)) * 100 < 13, format('NIT'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 12 and ((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 18 and
((cnt_f_bet + cnt_f_raise + cnt_t_bet + cnt_t_raise + cnt_r_bet + cnt_r_raise) / (cnt_f_call + cnt_t_call + cnt_r_call)) < 3 and
((cnt_p_3bet / cnt_p_3bet_opp) * 100) < 4,
format('TAGFISH'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 12 and ((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 18 and
((cnt_f_bet + cnt_f_raise + cnt_t_bet + cnt_t_raise + cnt_r_bet + cnt_r_raise) / (cnt_f_call + cnt_t_call + cnt_r_call)) > 2 and
((cnt_p_3bet / cnt_p_3bet_opp) * 100) > 3,
format('TAG'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 17 and ((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 21,
format('SLAG'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 20 and ((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 30 and
((cnt_pfr / cnt_pfr_opp) * 100) > 9,
format('LAG'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 22 and ((cnt_vpip / (cnt_hands - cnt_walks)) * 100) < 30 and
((cnt_pfr / cnt_pfr_opp) * 100) < 10,
format('SLP'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 30 and ((cnt_pfr / cnt_pfr_opp) * 100) < 10,
format('FISH'),
if (((cnt_vpip / (cnt_hands - cnt_walks)) * 100) > 30 and ((cnt_pfr / cnt_pfr_opp) * 100) > 9,
format('MANIAC'),,format('-'))))))))))
