[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

How to group by the first 3 characters of a string

Hello-
I'm need to group by the first 3 characters of a string and am unsure of how to get this result. I figured that I should create a formula field for this and use this as the field to group by. What would the formula be? Or is there another way of getting this result?
0
brooksmato
Asked:
brooksmato
  • 3
  • 2
1 Solution
 
brooksmatoAuthor Commented:
I've found my answer searching this sight. This is it:
left({HPD:HelpDesk.Version Found In},3)

But, after applying this, my group names have changed to the first 3 characters of the string, but they still being grouped by the same full string. In other words, i'll have several groups with the first 3 characters listed. How would I get the groups to truly be grouped by the first 3 characters?
0
 
Kurt ReinhardtCommented:
It sounds like you created a formula and placed it in the Group Header, but didn't actually change the group.  Right click on the group label, just to the left of the actual group (it'll say something like 'Group Header', 'Group Header A', 'GH', etc..) and select 'Change Group'.  Drill down through the list of available fields and select your formula as field by which your data will be grouped.

~Kurt
0
 
brooksmatoAuthor Commented:
When I right click in the left column next to the group, and select 'Change Group', my formula is already being used as group. Any other ideas?
0
Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

 
mlmccCommented:
WHat are you seeing in the report for the group headers?

mlmcc
0
 
brooksmatoAuthor Commented:
mlmcc-
I checked the groups and had 2. When I removed the first one... Eureka! I got what I wanted. Looks good now.

Thank you!
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now