HeatmapPivotTable Class

NReco.PivotData Class Library Documentation

Pivot table wrapper that highlights max values.

Inheritance Hierarchy

SystemObject
NReco.PivotDataHeatmapPivotTable

Namespace: NReco.PivotData
Assembly: NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.6.1

Syntax

C++

Copy

public class HeatmapPivotTable : IPivotTable

Public Class HeatmapPivotTable
	Implements IPivotTable

public ref class HeatmapPivotTable : IPivotTable

type HeatmapPivotTable =  
    class
        interface IPivotTable
    end

The HeatmapPivotTable type exposes the following members.

Constructors

	Name	Description
	HeatmapPivotTable(IPivotTable, HeatmapPivotTableHeatmapMode)	Initializes a new instance of HeatmapPivotTable instance by specified IPivotTable and heatmap mode.
	HeatmapPivotTable(IPivotTable, HeatmapPivotTableHeatmapMode, Int32)	Initializes a new instance of HeatmapPivotTable instance by specified IPivotTable, heatmap mode and measure index.

Top

Properties

	Name	Description
	BaseColor	Base color used to highlight max or min values.
	ColumnKeys
	Columns
	Mode	Heatmap max value calculation mode.
	PivotData
	RowKeys
	Rows

Top

Methods

	Name	Description
	Compare	Compares 2 pivot table values to determine max and min.
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	GetValue
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Remarks

Use this class to heat map for a pivot table that is rendered with PivotTableHtmlWriter or PivotTableExcelWriter. It is possible to specify which measure should be highlighted if pivot table has several measures.

Examples

Copy

PivotTable originalPvtTbl;
var heatmapPvtTbl = new HeatmapPivotTable(originalPvtTbl, HeatmapPivotTable.HeatmapMode.Table);
var heatmapPvtTbl.BaseColor = 0xFF0000; // red is used by default

Reference

NReco.PivotData Namespace