Interval Grouping

 
Order Date
Product Name Category Name Country Unit Price Quantity Total
Order Date: 2014 (Count: 405, Sum of Quantity: 9,581, Sum of Total: $226,132.00)
Queso CabralesDairy ProductsFrance$14.0012$168.00
Singaporean Hokkien Fried MeeGrains/CerealsFrance$10.0010$100.00
Mozzarella di GiovanniDairy ProductsFrance$35.005$175.00
TofuProduceGermany$19.009$171.00
Manjimup Dried ApplesProduceGermany$42.0040$1,680.00
Jack's New England Clam ChowderSeafoodBrazil$8.0010$80.00
Manjimup Dried ApplesProduceBrazil$42.0035$1,470.00
Louisiana Fiery Hot Pepper SauceCondimentsBrazil$17.0015$255.00
Gustaf's KnäckebrödGrains/CerealsFrance$17.006$102.00
Ravioli AngeloGrains/CerealsFrance$16.0015$240.00
Louisiana Fiery Hot Pepper SauceCondimentsFrance$17.0020$340.00
Sir Rodney's MarmaladeConfectionsBelgium$65.0040$2,600.00
GeitostDairy ProductsBelgium$2.0025$50.00
Camembert PierrotDairy ProductsBelgium$27.0040$1,080.00
Gorgonzola TelinoDairy ProductsBrazil$10.0020$200.00
Chartreuse verteBeveragesBrazil$14.0042$588.00
MaxilakuConfectionsBrazil$16.0040$640.00
Guaraná FantásticaBeveragesSwitzerland$4.0015$60.00
Pâté chinoisMeat/PoultrySwitzerland$19.0021$399.00
Data grid with 2158 rows and 6 columns
0 rows are selected

The DevExpress Blazor Grid supports interval grouping. Interval grouping allows you to group date-time values by year, month or date, or you can group text values by display text or against individual characters. Use the DxGridDataColumn.GroupInterval property to specify how data rows are grouped.

In this demo, the Order Date column uses interval grouping. Data is grouped by year. You also have options to select other group intervals including: Month or Date.