NReco.PivotData 1.2.6

PivotData: in-memory .NET OLAP cube (multidimensional array) for analytical queries and pivot tables calculation.

There is a newer version of this package available.
See the version list below for details.
Install-Package NReco.PivotData -Version 1.2.6
dotnet add package NReco.PivotData --version 1.2.6
<PackageReference Include="NReco.PivotData" Version="1.2.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.PivotData --version 1.2.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

v.1.2.6 Changes:
- introduced IPivotTable interface for alternative implementations/wrappers.
- added PivotTable.GetValue(ValueKey row, ValueKey col) method for key-based access to pivot table values; this signature can be used for getting sub-total values.
- added PivotTable.SortColumnKeysByRowKey and PivotTable.SortRowKeysByColumnKey methods for key-based sorting (useful for ordering by sub-total values).

v.1.2.5 Changes:
- Fixed PivotTable issue when the same dimension is used for both rows and columns (should be diagonal matrix result).
- New IAggregator.AsComposite() extension method avoids boilerplate code (cast to CompositeAggregator) for accessing PivotData or PivotTable with several measures.
- Added QueryCube example that illustrates how to use SliceQuery to filter/slice/dice, define derived (calculated) dimensions and measures.

v.1.2.4 Changes:
- added PivotTable.PreserveGroupOrder option: when enabled sort by value reorders rows/columns only inside groups.
- now PivotData works in lazy totals mode by default (this is backward-compatible change)
- added SortAsComparer for defining explicit order of pivot table rows or columns
- fixed NaturalSortKeyComparer for case when dimension has keys of different types: in this case it fallbacks to compare string equivalents of the keys
- added NaturalSortKeyComparer.ReverseInstance

v.1.2.3 Changes:
- moved SliceQuery from PivotData Toolkit to NReco.PivotData assembly. SliceQuery can be used for querying data cube in linq-style.
- PivotTable class: added PivotData property for accessing underlying data cube, added SortRowKeys/SortColumnKeys overloads for specifying measure index (for pivot tables with several measures)
- Overloaded ToString in IAggregatorFactory implementations (used for getting human-readable measure names)
- now NReco.PivotData.dll is a signed (strongly named) assembly


This package has no dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.3.7 7,560 7/18/2018
1.3.6 12,761 4/6/2018
1.3.5 1,193 2/26/2018
1.3.4 9,113 2/1/2017
1.3.3 6,942 10/18/2016
1.3.2 1,320 8/14/2016
1.3.1 674 7/5/2016
1.3.0 1,880 5/10/2016
1.2.6 1,375 2/4/2016
1.2.5 637 1/13/2016
1.2.4 651 12/11/2015
1.2.3 849 9/30/2015
Show less