I am trying to do rule-based styling for active drilling rigs in the United States.
Basically, I want to have categorized styling (different colored dots) for all companies (field = "OpCompany") with greater than x active rigs.
For companies with less than x active rigs, I would like them all to be the same color dots.
It is important to note that the data set (picture attached) shows each rig individually, so I am trying to find a way to write an expression/ rule that counts the # of duplicate "Operator Company Name" values in the "Operator Company Name" field.
I have searched extensively online, however cannot find a solution to my problem. Any ideas here?