Grouping & Ranges
By Day, Week or Month. Or Bands, in Order.Group data by week or month, or into bands, and the chart reads in the right order.
See results by day, week, fortnight, month, quarter or year, or split numbers into bands such as small, medium and enterprise. Bands read in order on the chart, so 10,000+ never turns up before 200 on a board the floor is watching, and an empty band shows as zero instead of vanishing.
- Six time units
- Up to 50 bands
- Sorted by value, not label
How it works
- A date or a numberGrouped by time unit or by band
- Records fall into bandsOut-of-range values get their own band
- Sorted by valueNot alphabetically by label
- The chart reads rightEmpty bands drawn at zero
Charts That Read in the Right Order.
Each band sorts by its value, not its label, so 10,000+ comes after 200 on a chart axis.
A band with no records still draws at zero, so a hole in the range reads as a hole.
Breakpoints make uneven bands, such as small, medium and enterprise.
With no grouping set, dates group themselves to suit the length of the window, from hours up to years.
By Time, by Equal Bands, or by Breakpoints.
Day, week, fortnight, month, quarter or year. A fortnight is labeled with both of its weeks.
Numbers cut into same-width bands from a starting point, like a histogram.
Uneven bands, such as small, medium and enterprise, from the breakpoints you list.
How to Group Data by Week or Month, or into Bands.
To group data by week or month is to turn a long list of dated records into one bar per week or per month, so a trend reads at a glance. Grouping numbers into bands does the same for amounts: one bar per range instead of one per value.
Adoptiv groups dates by day, week, fortnight, month, quarter or year, which gives you a weekly sales report, a biweekly view, a monthly report and a quarterly report from the same records. Numbers can be cut into equal-width bands from a start you name, or split at breakpoints you list, for uneven deal size bands such as small, medium and enterprise. One grouping holds up to 50 bands.
On a chart, each band carries a sort key beside its label, so bands read in their real order rather than alphabetically. Values under the first breakpoint or past the last get their own labeled bands, and a band with no records still draws at zero, so a gap looks like a gap. Labels shorten to thousands and millions, with the currency symbol on money.
Pivot tables use the same groupings on both edges, though numeric bands sort as text there. Groupings work with comparison periods too. If a grouping doesn’t suit a field, such as a time unit on a number, the chart falls back to plain grouping instead of breaking.
Every Way to Group a Date or a Number.
Group any date by week, or by day, fortnight, month, quarter or year.
Equal-width bands from a chosen start, up to 50 in one grouping.
Uneven tiers from the breakpoints you list.
Bands sort by value on a chart axis, never alphabetically.
Holes in a range stay visible.
Short labels in thousands or millions, with the currency sign added.
For Anyone Who Reads Results by the Week.
Grouping & Ranges Questions, Answered.
How do I group data by week or month?
A date can be grouped by day, week, fortnight, month, quarter or year. With no unit set, a default for that field applies, or the date groups itself to suit the window you’re looking at.
Can a report use custom ranges?
Yes. Numbers can be cut into equal-width bands from a starting point, or split at listed breakpoints for uneven bands. One grouping holds up to 50 bands.
What happens to values outside the bands?
Anything under the first breakpoint, or at or above the last, gets its own labeled band. Empty values go in a band called none.
Can text fields be grouped into bands?
No. Text fields group by their exact value. Bands are for dates and numbers.
What is a fortnight grouping?
Two weeks together, for a biweekly view. Each fortnight is labeled with both of its weeks.
Why does my chart show bands at zero?
A band with no records still draws, at zero, so a gap in the middle of a range reads as a gap instead of closing up.
How many bands can one grouping have?
Up to 50 bands or breakpoints.
What if a grouping doesn’t fit the field?
The chart falls back to plain grouping and still draws, rather than breaking, until the grouping is fixed.
Still have a question? A real person replies in under 60 seconds in US business hours. Talk to our team →
14-day free trial
See Your Numbers by Week, Month or Band.
Try it on your own records in the free trial. Free for 14 days, no credit card.
14-day trial · no card · migration included