NReco.PivotData 1.4.2

Prefix Reserved
.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.5 This package targets .NET Framework 4.5. The package is compatible with this framework or higher. 
dotnet add package NReco.PivotData --version 1.4.2                

                    
                

            
NuGet\Install-Package NReco.PivotData -Version 1.4.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="NReco.PivotData" Version="1.4.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add NReco.PivotData --version 1.4.2                

                    
                

            
#r "nuget: NReco.PivotData, 1.4.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. 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.4.2

// Install NReco.PivotData as a Cake Tool
#tool nuget:?package=NReco.PivotData&version=1.4.2

PivotData OLAP library: in-memory multidimensional dataset for data aggregations (count, sum, avg, min, max, count unique, median, mode or custom function), OLAP queries (roll-ups, slice and dice, transformations), pivot table data model.

Source code and examples: https://github.com/nreco/pivotdata
Usage conditions, online demo: https://www.nrecosite.com/pivot_data_library_net.aspx
Get started: https://www.nrecosite.com/pivotdata/cube-basics.aspx

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net45 is compatible.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

  • .NETFramework 4.5

    • No dependencies.

  • .NETStandard 2.0

    • No dependencies.

  • .NETStandard 2.1

    • No dependencies.

NuGet packages (1)

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

Package Downloads
NReco.PivotData.Extensions

PivotData Toolkit components: render pivot tables to HTML, exports to JSON/CSV/Excel/PDF/DataTable, pivot table calculations (percentages, differences, running total, heatmap, top-N/pagination/groups expand-collapse), load data from SQL databases, infrastructure for interactive web-based reports builder. Note: without a valid license key, PivotData Toolkit components will work in TRIAL MODE (with some data limitations and trial notices). ASP.NET pivot table builder online demo: http://pivottable.nrecosite.com/ Examples download: https://www.nrecosite.com/pivot_data_library_net.aspx

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.4.2 37,291 2/2/2023
1.4.1 4,960 8/26/2022
1.4.0 2,297 7/13/2022
1.3.8 55,700 5/27/2020
1.3.7 309,768 7/18/2018
1.3.6 75,076 4/6/2018
1.3.5 2,489 2/26/2018
1.3.4 25,520 2/1/2017
1.3.3 36,596 10/18/2016
1.3.2 2,885 8/14/2016
1.3.1 2,864 7/5/2016
1.3.0 4,246 5/10/2016
1.2.6 3,189 2/4/2016
1.2.5 1,980 1/13/2016
1.2.4 1,984 12/11/2015
1.2.3 2,300 9/30/2015

v.1.4.2 changes:
- PivotTable now skips Key.Empty keys when calculates ColumnKeys/RowKeys (github issue #11)

v.1.4.1 changes:
- AverageAggregator (and SumAggregator) now returns null instead of zero if count=0 (like SQL AVG/SUM)

v.1.4.0 changes:
- added netstandard2.1 build
- added PivotData.ProcessDataAsync methods (available only in netstandard2.1 build)

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