NReco.PivotData 1.3.8

PivotData OLAP library: in-memory multidimensional dataset for data aggregation, roll-up, slice and dice, pivot table data calculation.

Install-Package NReco.PivotData -Version 1.3.8
dotnet add package NReco.PivotData --version 1.3.8
<PackageReference Include="NReco.PivotData" Version="1.3.8" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add NReco.PivotData --version 1.3.8
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: NReco.PivotData, 1.3.8"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install NReco.PivotData as a Cake Addin
#addin nuget:?package=NReco.PivotData&version=1.3.8

// Install NReco.PivotData as a Cake Tool
#tool nuget:?package=NReco.PivotData&version=1.3.8
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

Online demo, usage examples:
Get started:

v.1.3.8 changes:
- removed builds for legacy targets (only netstandard20 and net45 are included)
- PivotTable class: fixed issue with sort-by-value for single-measure that is FormulaAggregator
- PivotTable class: fixed issue with sort-by-value when aggregator value is IList (ListAggregator, ListUniqueAggregator)
- PivotTable class: added ability to set custom IComparer for values (ValuesComparer property)
- PivotData class: fixed issue in ValueKey comparison for numeric dimension keys (cases like int vs long).

v.1.3.7 changes:
- fixed PivotDataState serialization issue with Key.Empty
- PivotData class: XOR-based hash function for keys replaced with sum-based to avoid collisions
- performance optimization: less array allocations in PivotData.ProcessData method and PivotTable class

v.1.3.6 changes:
- added ModeAggregator (calculates value that appears most often)
- fixed issue with slow sub-totals calculation in some cases
- always use InvariantCulture for numbers parsing

v.1.3.5 changes:
- added QuantileAggregator to calculate specified quantile (median)
- added PivotData.LazyAdd property (affects behaviour when non-existing key is accessed)
- added netstandard2.0 build
- efficient sub-totals calculation in PivotTable class (especially for large pivot tables)
- now PivotData class correctly loads PivotDataState which has duplicate key entries

  • .NETFramework 4.5

    • No dependencies.
  • .NETStandard 2.0

    • No dependencies.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on NReco.PivotData:

Package Downloads
PivotData Toolkit (extends NReco.PivotData OLAP library): advanced components for pivot table reports generation (HTML, JSON, CSV, Excel, PDF, DataTable), formatting wrappers (percentage, difference, running total, heatmap, topN/pagination), CSV/TSV/JSON/SQL data sources, extract-transform-load (ETL) handlers, keyword-based filter etc.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.3.8 6,565 5/27/2020
1.3.7 41,506 7/18/2018
1.3.6 24,125 4/6/2018
1.3.5 1,495 2/26/2018
1.3.4 11,773 2/1/2017
1.3.3 9,550 10/18/2016
1.3.2 1,646 8/14/2016
1.3.1 955 7/5/2016
1.3.0 2,501 5/10/2016
1.2.6 1,781 2/4/2016
1.2.5 887 1/13/2016
1.2.4 914 12/11/2015
1.2.3 1,119 9/30/2015