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 of specific cases. I'd like to do this at the card level rather than ETL, but I would just have done a group by `from` statement in SQL to get the expected result.
Here's an image of my table to give you an idea:

Thanks!