NReco.PivotData 1.3.0

PivotData: in-memory .NET OLAP cube (multidimensional dataset) 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.3.0
dotnet add package NReco.PivotData --version 1.3.0
<PackageReference Include="NReco.PivotData" Version="1.3.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.PivotData --version 1.3.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

v.1.3.0 Changes:
- bugfix: incorrect last column/row sorting with PivotTable.PreserveGroupOrder option.
- added ListAggregatorFactory (ListAggregator) for accumulating all values from an input source (works like LINQ GroupBy).
- added VarianceAggregatorFactory (VarianceAggregator) for calculating variance, standard deviation (stdev), sample variance and sample stadard deviation.
- added ObjectMember that simplifies processing of custom data models (typed collections).
- added PivotDataHelper that provides utility methods for any IPivotData object: GetDimensionKeys and GetDimensionType.
- improved ConvertHelper.ConvertToDecimal method (now it supports all primitive number types) and added ConvertHelper.ConvertToDouble method.

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


This package has no dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.3.7 8,874 7/18/2018
1.3.6 13,690 4/6/2018
1.3.5 1,205 2/26/2018
1.3.4 9,304 2/1/2017
1.3.3 7,124 10/18/2016
1.3.2 1,335 8/14/2016
1.3.1 682 7/5/2016
1.3.0 1,890 5/10/2016
1.2.6 1,386 2/4/2016
1.2.5 645 1/13/2016
1.2.4 660 12/11/2015
1.2.3 858 9/30/2015
Show less