JS Pivot Grid

WebDataRocks JavaScript Pivot Table: easy and fast data analysis in your web application.

Embedding WebDataRocks Pivot Table into your applications provides a dynamic solution for your multi-dimensional data analysis. The component transforms complex datasets into clear and easy-to-read reports, all within your webpage.

Created using

.js
.html

var pivot1 = new WebDataRocks({
    container: "#wdr-component",
    width: "100%",
    height: 600,
    toolbar: true,
    report: {
        dataSource: {
            dataSourceType: "csv",
            filename: "https://cdn.webdatarocks.com/data/data.csv"
        },
        slice: {
            "rows": [{
                "uniqueName": "Country",
                "filter": {
                    "members": ["Country.United Kingdom", "Country.United States"],
                    "negation": true
                }
            }, {
                "uniqueName": "Measures"
            }],
            "columns": [{
                "uniqueName": "Category"
            }],
            measures: [{
                uniqueName: "Price",
                format: "currency"
            }, {
                uniqueName: "Discount",
                format: "currency"
            }],
        },
        formats: [{
            name: "currency",
            currencySymbol: "$",
            currencySymbolAlign: "left",
            thousandsSeparator: ",",
            decimalPlaces: 2
        }],
        "tableSizes": {
            "columns": [{
                "tuple": ["Category.Components"],
                "width": 105
            }, {
                "tuple": ["Category.(All Member)"],
                "width": 148
            }]
        },
        "conditions": [{
            "formula": "#value > 350000",
            "format": {
                "backgroundColor": "#0598df",
                "color": "#FFFFFF"
            }
        }, {
            "formula": "AND(#value > 1000, #value < 3000)",
            "format": {
                "backgroundColor": "#f45328",
                "color": "#FFFFFF"
            }
        }]
    }
});

<html>
<head></head>
<body>
<div id="wdr-component"></div>
<link href="https://cdn.webdatarocks.com/latest/webdatarocks.min.css" rel="stylesheet"/>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.toolbar.min.js"></script>
<script src="https://cdn.webdatarocks.com/latest/webdatarocks.js"></script>
</body>
</html>

Start with the guide

What is WebDataRocks Pivot Table?

WebDataRocks Pivot Table is an Excel-like JavaScript tool that aims to enhance the interactive analytical power of your web applications for reporting.

Why WebDataRocks?

Seamless Integration: WebDataRocks is a JavaScript component that was created with developers in mind to help them integrate the tool into any stack with ease. Comprehensive and detailed documentation guides you through all the steps of setting and customizing the pivot grid.
Intuitive Analysis: Using simple drag-and-drop, you can perform all major pivot table functions: grouping, filtering, sorting, drilling down, and configuring the report.
Excel-like Features: Familiar functionality and intuitive UI design make WebDataRocks a perfect environment for comfortable analysis. Create custom calculating fields, export data to various formats (PDF, JSON, Excel), change datasets and grid modes, and more.

How do I get started with WebDataRocks Pivot Grid?

We recommend using our comprehensive guide with step-by-step instructions on installation and usage.

FAQ

How can I customize WebDataRocks Pivot Table?

WebDataRocks Pivot Grid offers wide customization options. Our documentation provides detailed instructions on how to customize the appearance and functionality of the grid to match your specific requirements.

Can I use WebDataRocks Pivot Grid with other frameworks?

Yes! WebDataRocks is framework-friendly and integrates seamlessly with all popular frameworks like React, Angular, Vue.js, and more. Our documentation offers specific integration guides for each framework to help you get started quickly.

Is WebDataRocks Pivot Grid really free?

Yes, WebDataRocks is absolutely free to use. For more details on usage, please visit our license page.