Pie Charts with Truncated SIC Codes

[CHayes8]

I would like to create a pie chart by # of companies per the first 4 digits of the 8 digit SIC code.  Is it possible to truncate the SIC codes to 4 or 2 digits (so rest of digits are ignored)?

[danmoyle · Accepted solution]

@CHayes8 Is SIC code a custom property in your portal? I don't think that's a standard property, but I could be wrong. 

Either way, I don't know of a way in reports to only show a partial property. If it were me, and that was an important feature, I'd create a second property and try to build a workflow to possibly change the SIC code. But even as I suggest that, I'm not confident that there's a good way to do that. 

In short, I don't believe what you're asking is possible in HubSpot. I'll defer to anyone who may have a more creative answer, but that's my thought. 

[kvlschaefer]

Hi @CHayes8,

Thank you for reaching out to the Community!

I would like to add our subject matter experts to this conversation.

Hi @danmoyle, @franksteiner79, @ChrisoKlepke - Do you have any tips or workarounds for @CHayes8?

Thank you!

Best,

Kristen