Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Summary Report Grouping Options
Jim Harrison
07-29-2019 20:33
Would like to Group a Summary Report on Contains or some other filter. Anyone have any solutions to make ...
QuickBaseCoach Dev./Training
07-29-2019 20:34
yes, make a field to group on ....
Jim Harrison
07-29-2019 20:48
The field I want to group on is grouping by exact values and I need to group on values that start with ...
Alex Certification!
07-29-2019 21:12
My Excel brain says "use a helper field". Would that work for you here?
Jim Harrison
07-29-2019 21:15
I created a new formula field and used left() to group, it works.
Alex Certification!
07-29-2019 21:19
Yep, there you go. Perhaps worth noting that some report types do natively include 'first word' grouping ...
1.
Summary Report Grouping Options
1
Like
Jim Harrison
Posted 07-29-2019 20:33
Reply
Reply Privately
Options Dropdown
Would like to Group a Summary Report on Contains or some other filter. Anyone have any solutions to make this happen?
I'm thinking about creating a formula field and trimming and then grouping on that.
Thoughts?
Jim
2.
RE: Summary Report Grouping Options
0
Like
QuickBaseCoach Dev./Training
Posted 07-29-2019 20:34
Reply
Reply Privately
Options Dropdown
yes, make a field to group on ....
3.
RE: Summary Report Grouping Options
0
Like
Jim Harrison
Posted 07-29-2019 20:48
Reply
Reply Privately
Options Dropdown
The field I want to group on is grouping by exact values and I need to group on values that start with or contain, which is not an option.
4.
RE: Summary Report Grouping Options
0
Like
Alex Certification!
Posted 07-29-2019 21:12
Reply
Reply Privately
Options Dropdown
My Excel brain says "use a helper field". Would that work for you here?
5.
RE: Summary Report Grouping Options
0
Like
Jim Harrison
Posted 07-29-2019 21:15
Reply
Reply Privately
Options Dropdown
I created a new formula field and used left() to group, it works.
6.
RE: Summary Report Grouping Options
0
Like
Alex Certification!
Posted 07-29-2019 21:19
Reply
Reply Privately
Options Dropdown
Yep, there you go.
Perhaps worth noting that some report types do natively include 'first word' grouping as an option (I know bar charts, which have their own weaknesses, do have this choice).
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic