Grouping by substring selected in a beastmode
Hello, I'm looking to group by the left two (or more, depending on where I'll end up going) characters of a column. I made a calculated field of left(`from`,2) that gives me the first 2 characters, but I can't group by this value. I have a LOT of possibilities in the from field, so I can't create the hundreds and hundreds…