Generated by Rank Math SEO, this is an llms.txt file designed to help LLMs better understand and index this website.

# WebDataRocks: Free Web Reporting Tool

## Sitemaps
[XML Sitemap](https://www.webdatarocks.com/sitemap_index.xml): Includes all crawlable and indexable pages.

## Posts
- [Simple Way to Analyze Complex Data Online](https://www.webdatarocks.com/blog/simple-way-to-analyze-complex-data-online/): Quickly transform complex data into meaningful insights with its drag-and-drop interface and advanced features. Learn about solution that is ideal for both developers and business users.
- [5 Tips on How to Visualize Data for Insightful Solutions](https://www.webdatarocks.com/blog/5-tips-on-how-to-visualize-data-for-insightful-solutions/): The article discusses how visual data representation can improve problem-solving by making complex information easier to understand. It offers practical tips on using tools like charts and infographics to simplify data and enhance decision-making.
- [Charts for Comparison Over Time](https://www.webdatarocks.com/blog/dataviz-project-part-3-charts-for-comparisons-over-time/): It’s time to discover charts for one of the most common types of data analysis – a comparison over time.
- [Heat Map with Pivot Grid](https://www.webdatarocks.com/demos/heat-map-with-pivot-grid/): With WebDataRocks pivot table, you can transform raw data into an interactive heat map that instantly highlights areas of high and low activity. Instead of manually searching for patterns, users can identify them at a glance through color intensity.
- [Updating Your Tech Stack: Migrating from PivotTable.js to alternatives](https://www.webdatarocks.com/blog/updating-your-tech-stack-migrating-from-pivottable-js-to-alternatives/): We compare PivotTable.js and WebDataRocks, highlighting their key differences to help you choose the right JavaScript pivot table solution.
- [Showcase: How to Turn Medical Surveys into Clear Insights with WebDataRocks](https://www.webdatarocks.com/blog/showcase-how-to-turn-medical-surveys-into-clear-insights-with-webdatarocks/): We’ll show you how to create a Patient Experience Report, covering everything from structuring the data to enhancing it with visuals and clean medical design.
- [How to Choose Charts to Show Data Composition](https://www.webdatarocks.com/blog/how-to-choose-charts-to-show-data-composition/): From stacked charts that show changes over time to pie charts that highlight proportions, we'll guide you through the best options. Discover how to use visuals to tell your data's story effectively.
- [Best Charts for Data Distribution](https://www.webdatarocks.com/blog/best-charts-for-data-distribution/): Let's dive into the world of data visualization! Today, we're unraveling the secrets of histograms and box plots – two powerful tools for understanding data distributions.
- [List of best JavaScript components for report application](https://www.webdatarocks.com/blog/list-of-best-javascript-components-for-report-applications/): Explore the best JavaScript components for building robust report applications. This article covers top libraries like Chart.js, amCharts, Apache ECharts, D3.js, and more, comparing their features, pros, and cons to help you find the right data visualization and reporting tools for your business needs.
- [Exploring HR Analytics with WebDataRocks and Highcharts](https://www.webdatarocks.com/demos/exploring-hr-analytics-with-webdatarocks-and-highcharts/): HR analytics is always on the hunt for clean, simple visualizations. You’re dealing with complex, fragmented data from multiple systems that needs to be two things at once: a high-level summary for leadership and a granular, actionable view for managers. That’s why WebDataRocks pivot table with Highcharts integration is such a perfect match. It bridges the gap between complex data structures and clean, intuitive visuals, letting you pivot from the big picture to deep-dive details in a few clicks.
- [Best Charts to Show Discrete Data](https://www.webdatarocks.com/blog/best-charts-discrete-data/): We explore the world of discrete data and show how to bring it to life through captivating visuals. You'll discover a range of chart types, including bar charts, stacked bars, column charts, and more.
- [How WebDataRocks Can Help Santa Keep Track of Christmas Presents](https://www.webdatarocks.com/blog/how-webdatarocks-can-help-santa-keep-track-of-christmas-presents/): We’ll show you how to build a Santa’s Letter Management System step by step, from displaying each letter in a pivot table to styling a festive dashboard and creating interactive pop-ups for long texts.
- [From Stranger Things to Christmas Gifts: WebDataRocks Best Demos](https://www.webdatarocks.com/blog/from-stranger-things-to-christmas-gifts-webdatarocks-best-demos/): We collected our best demos and explored all of them to showcase the diversity of using WebDataRocks in your own projects.
- [Turn Your Data Into a Halloween Treat with WebDataRocks](https://www.webdatarocks.com/blog/turn-your-data-into-a-halloween-treat-with-webdatarocks/): We celebrate Halloween with WebDataRocks and explore how you can make your reports more fun and personalized. And yes, all examples are about candies, horror movies, and, of course, pumpkins!
- [Top data visualization blogs to follow in 2025](https://www.webdatarocks.com/blog/top-data-visualization-blogs-to-follow/): Learn how to turn data into captivating stories with these top-rated data visualization blogs. This article offers a variety of resources to improve your data visualization skills in 2023.
- [Trick or Pivot! Interactive Demos on this Halloween](https://www.webdatarocks.com/blog/top-interactive-halloween-demos/): Get into the spooky spirit with WebDataRocks and explore the world of data through Halloween-themed examples. From analyzing pumpkin prices to ranking your favorite candies, discover the power of pivot tables and data visualization.
- [Transform McDonald’s Dataset into Interactive Web Report. Inspired by #CodepenChallenge](https://www.webdatarocks.com/blog/transform-mcdonalds-dataset-into-interactive-web-report/): Learn how to filter a large amount of data before loading, switch between layouts, and apply custom design using JavaScript and CSS. And all of that on a tasty, real-world example everyone knows: the McDonald’s menu.
- [Creating multilevel hierarchies in CSV](https://www.webdatarocks.com/doc/vue/creating-multilevel-hierarchies-in-csv/)
- [Creating multilevel hierarchies in CSV](https://www.webdatarocks.com/doc/angular/creating-multilevel-hierarchies-in-csv/)
- [Creating multilevel hierarchies in CSV](https://www.webdatarocks.com/doc/react/creating-multilevel-hierarchies-in-csv/)
- [Creating multilevel hierarchies in CSV](https://www.webdatarocks.com/doc/js/creating-multilevel-hierarchies-in-csv/)
- [Setting data types (Vue)](https://www.webdatarocks.com/doc/vue/setting-data-types/)
- [Setting data types (Angular)](https://www.webdatarocks.com/doc/angular/setting-data-types/)
- [Setting data types (React)](https://www.webdatarocks.com/doc/react/setting-data-types/)
- [Setting data types](https://www.webdatarocks.com/doc/js/setting-data-types/)
- [9 Tips to Ensure a Successful Data Warehouse](https://www.webdatarocks.com/blog/9-tips-to-ensure-a-successful-data-warehouse/): A data warehouse serves as a centralized repository for an organization’s data, facilitating effective analysis and informed decision-making. We’ll delve into the essential steps for constructing a successful data warehouse.
- [Table Sizes Object](https://www.webdatarocks.com/api/table-sizes-object/): A tableSizes object stores size settings for columns and rows.
- [Manage spreadsheet headers](https://www.webdatarocks.com/doc/angular/manage-spreadsheet-headers/)
- [Manage spreadsheet headers](https://www.webdatarocks.com/doc/vue/manage-spreadsheet-headers/)
- [Manage spreadsheet headers](https://www.webdatarocks.com/doc/react/manage-spreadsheet-headers/)
- [Manage spreadsheet headers](https://www.webdatarocks.com/doc/js/manage-spreadsheet-headers/)
- [Complete Guide to Mobile App Development: Process, Trends, Costs](https://www.webdatarocks.com/blog/complete-guide-to-mobile-app-development/): We'll explore the world of mobile app development, from concept to launch. Learn about the process, market trends, costs, and popular app categories. Find out how to choose the right development partner and monetize your app for success.
- [Interactive Insights: How Data Visualization Software Turns Static Data into Dynamic Experiences](https://www.webdatarocks.com/blog/interactive-insights-how-data-visualization-software-turns-static-data-into-dynamic-experiences/): Explore how businesses are moving beyond static spreadsheets to transform data into interactive insights. Learn about the advantages of dynamic data visualization, the evolution from static to dynamic data, and how innovative tools like AI and analytics optimize customer experiences through engaging, visually compelling formats.
- [What Is the Best Tech Stack for Your Mobile App in 2025?](https://www.webdatarocks.com/blog/what-is-the-best-tech-stack-for-your-mobile-app-in-2024/): Selecting the right tech stack is crucial. Learn how factors like budget, app type, and desired features influence your choices. From back-end to front-end, discover essential components and explore real-world examples.
- [Do You See What We See? A Festive Data Visualization with Vue 3 and WebDataRocks](https://www.webdatarocks.com/blog/festive-data-visualization-with-vue-3-and-webdatarocks/): With the holidays fast approaching, our team has been brainstorming ideas for meaningful gifts for our colleagues. This year, our workplace is hosting a "Secret Santa" gift exchange, and finding the perfect presents has proven to be quite the challenge. While exploring Kaggle, we came across an intriguing dataset called Customer Shopping (Latest Trends) and thought—what if the data could help?
- [Integration with any charting library (Vue)](https://www.webdatarocks.com/doc/vue/integration-with-any-charting-library/): This tutorial explains how to connect WebDataRocks to any third-party charting library (for example, Chart.js, ApexCharts, ECharts, or D3.js).
- [Integration with any charting library (Angular)](https://www.webdatarocks.com/doc/angular/integration-with-any-charting-library/): This tutorial explains how to connect WebDataRocks to any third-party charting library (for example, Chart.js, ApexCharts, ECharts, or D3.js).
- [Integration with any charting library (React)](https://www.webdatarocks.com/doc/react/integration-with-any-charting-library/): This tutorial explains how to connect WebDataRocks to any third-party charting library (for example, Chart.js, ApexCharts, ECharts, or D3.js).
- [Integration with any charting library](https://www.webdatarocks.com/doc/js/integration-with-any-charting-library/): This tutorial explains how to connect WebDataRocks to any third-party charting library (for example, Chart.js, ApexCharts, ECharts, or D3.js).
- [React Native 0.76: What’s New? ](https://www.webdatarocks.com/blog/react-native-076-whats-new/): This article explores the significant updates in React Native 0.76, such as New Architecture by default, performance enhancements, improved DevTools, new styling features, and their impact on app development.
- [amCharts](https://www.webdatarocks.com/docs-folder/amcharts/)
- [Top pivot table components for web reporting: guide for developers](https://www.webdatarocks.com/blog/top-pivot-table-components-for-web-reporting-guide-for-developers/): We'll review top pivot table components based on key criteria like documentation, performance, scalability, and customization. This guide will help you find the best fit for your project, whether you prioritize functionality, integration, or cost.
- [Guide on Choosing the Right Technology Stack for eCommerce App Development](https://www.webdatarocks.com/blog/how-to-choose-technology-stack-for-ecommerce-app-development/): Building a successful eCommerce app requires a well-thought-out technology stack. In this article, we address common challenges faced by businesses when selecting technologies.
- [Integration with amCharts](https://www.webdatarocks.com/doc/angular/integration-with-amcharts/): This step-by-step tutorial will help you integrate WebDataRocks with amCharts. Our tutorial is based on the V4 of amCharts.
- [Integration with amCharts](https://www.webdatarocks.com/doc/vue/integration-with-amcharts/): This step-by-step tutorial will help you integrate WebDataRocks with amCharts. Our tutorial is based on the V4 of amCharts.
- [Integration with amCharts](https://www.webdatarocks.com/doc/react/integration-with-amcharts/): This step-by-step tutorial will help you integrate WebDataRocks with amCharts. Our tutorial is based on the V4 of amCharts.
- [Loading the report](https://www.webdatarocks.com/doc/vue/loading-report/)
- [Loading the report](https://www.webdatarocks.com/doc/angular/loading-report/)
- [Customizing the Toolbar](https://www.webdatarocks.com/doc/vue/customizing-toolbar/)
- [Customizing the Toolbar](https://www.webdatarocks.com/doc/angular/customizing-toolbar/)
- [Customizing the Toolbar](https://www.webdatarocks.com/doc/react/customizing-toolbar/)
- [WebDataRocks dependencies](https://www.webdatarocks.com/doc/vue/webdatarocks-dependencies/)
- [WebDataRocks dependencies](https://www.webdatarocks.com/doc/angular/webdatarocks-dependencies/)
- [WebDataRocks dependencies](https://www.webdatarocks.com/doc/react/webdatarocks-dependencies/)
- [Technical specifications](https://www.webdatarocks.com/doc/vue/technical-specifications/)
- [Technical specifications](https://www.webdatarocks.com/doc/angular/technical-specifications/)
- [Technical specifications](https://www.webdatarocks.com/doc/react/technical-specifications/)
- [Browser compatibility](https://www.webdatarocks.com/doc/vue/browser-compatibility/)
- [Browser compatibility](https://www.webdatarocks.com/doc/angular/browser-compatibility/)
- [Browser compatibility](https://www.webdatarocks.com/doc/react/browser-compatibility/)
- [Available tutorials on charts](https://www.webdatarocks.com/doc/vue/available-tutorials-charts/)
- [Available tutorials on charts](https://www.webdatarocks.com/doc/angular/available-tutorials-charts/)
- [Available tutorials on charts](https://www.webdatarocks.com/doc/react/available-tutorials-charts/)
- [Custom component themes](https://www.webdatarocks.com/doc/vue/custom-report-themes/)
- [Custom component themes](https://www.webdatarocks.com/doc/angular/custom-report-themes/)
- [Custom component themes](https://www.webdatarocks.com/doc/react/custom-report-themes/)
- [The Toolbar](https://www.webdatarocks.com/doc/vue/using-toolbar/)
- [The Toolbar](https://www.webdatarocks.com/doc/angular/using-toolbar/)
- [The Toolbar](https://www.webdatarocks.com/doc/react/using-toolbar/)
- [Number formatting](https://www.webdatarocks.com/doc/vue/number-formatting/)
- [Number formatting](https://www.webdatarocks.com/doc/angular/number-formatting/)
- [Number formatting](https://www.webdatarocks.com/doc/react/number-formatting/)
- [Drill through](https://www.webdatarocks.com/doc/vue/pivot-table-drill-through/)
- [Drill through](https://www.webdatarocks.com/doc/angular/pivot-table-drill-through/)
- [Drill through](https://www.webdatarocks.com/doc/react/pivot-table-drill-through/)
- [Aggregation functions](https://www.webdatarocks.com/doc/vue/aggregation/)
- [Aggregation functions](https://www.webdatarocks.com/doc/angular/aggregation/)
- [Aggregation functions](https://www.webdatarocks.com/doc/react/aggregation/)
- [Sorting](https://www.webdatarocks.com/doc/vue/sorting/)
- [Sorting](https://www.webdatarocks.com/doc/angular/sorting/)
- [Sorting](https://www.webdatarocks.com/doc/react/sorting/)
- [Filtering](https://www.webdatarocks.com/doc/vue/fields-filtering/)
- [Filtering](https://www.webdatarocks.com/doc/angular/fields-filtering/)
- [Filtering](https://www.webdatarocks.com/doc/react/fields-filtering/)
- [Changing component themes](https://www.webdatarocks.com/doc/vue/changing-report-themes/)
- [Changing component themes](https://www.webdatarocks.com/doc/angular/changing-report-themes/)
- [Changing component themes](https://www.webdatarocks.com/doc/react/changing-report-themes/)
- [Exporting and printing](https://www.webdatarocks.com/doc/vue/exporting/)
- [Exporting and printing](https://www.webdatarocks.com/doc/angular/exporting/)
- [Exporting and printing](https://www.webdatarocks.com/doc/react/exporting/)
- [Column and row resizing](https://www.webdatarocks.com/doc/vue/column-and-row-resizing/)
- [Column and row resizing](https://www.webdatarocks.com/doc/angular/column-and-row-resizing/)
- [Column and row resizing](https://www.webdatarocks.com/doc/react/column-and-row-resizing/)
- [Conditional formatting](https://www.webdatarocks.com/doc/vue/conditional-formatting/)
- [Conditional formatting](https://www.webdatarocks.com/doc/angular/conditional-formatting/)
- [Conditional formatting](https://www.webdatarocks.com/doc/react/conditional-formatting/)
- [Language localization](https://www.webdatarocks.com/doc/vue/language-localization/)
- [Language localization](https://www.webdatarocks.com/doc/angular/language-localization/)
- [Language localization](https://www.webdatarocks.com/doc/react/language-localization/)
- [Grand totals and subtotals](https://www.webdatarocks.com/doc/vue/grand-totals-and-subtotals/)

## Pages
- [WebDataRocks vs. 10 Alternatives: Choosing a JavaScript Pivot Table Component in 2026](https://www.webdatarocks.com/webdatarocks-vs-10-alternatives-choosing-a-javascript-pivot-table-component/): The short answer: WebDataRocks is the fastest way to add a free, Excel-like JavaScript pivot table to a web app, and it handles small-to-medium datasets (up to 1 MB of CSV or JSON) well. If your data outgrows that, Flexmonster (built by same team) scales to millions of rows, OLAP cubes, and SQL/NoSQL sources. DevExtreme, Syncfusion, Kendo, and Wijmo bundle capable pivots into their UI suites; AG Grid Enterprise fits when pivoting is one feature of a larger grid; PivotTable.js remains the open-source standby; TinyPivot is the lightweight newcomer for Vue 3 and React. This guide compares all eleven honestly, including where our own tool is not the right choice.
- [Privacy Policy](https://www.webdatarocks.com/privacy-policy-20260422/): Effective: April 22, 2026To see a previous version, click here.
- [Privacy Policy](https://www.webdatarocks.com/privacy-policy-20260319/): Effective: March 19, 2026To see a previous version, click here.
- [Privacy Policy](https://www.webdatarocks.com/privacy-policy-20251014/): Effective: October 14, 2025To see a previous version, click here.
- [Privacy Policy](https://www.webdatarocks.com/privacy-policy-20240524/): Effective Date: May 24, 2024To see a previous version, click here.
- [About us](https://www.webdatarocks.com/about-us/)
- [Privacy Policy](https://www.webdatarocks.com/privacy-policy/): Last updated: June 30, 2026To see a previous version, click here.
- [Write for us!](https://www.webdatarocks.com/write-for-us/): We’d be happy to have you among our guest writers!
- [Download ZIP](https://www.webdatarocks.com/download-zip/)
- [What is your data source size?](https://www.webdatarocks.com/ds-poll/)
- [Thank You!](https://www.webdatarocks.com/get-webdatarocks-thank-you/): What's next?
- [Documentation](https://www.webdatarocks.com/doc/)
- [Sign Up](https://www.webdatarocks.com/signup/)
- [Reset Password](https://www.webdatarocks.com/reset-password/)
- [Log Out](https://www.webdatarocks.com/logout/)
- [Log In](https://www.webdatarocks.com/login/)
- [Ask Question](https://www.webdatarocks.com/forum-ask/)
- [Forum](https://www.webdatarocks.com/forum/)
- [Blog](https://www.webdatarocks.com/blog/)
- [Home](https://www.webdatarocks.com/)

## Question
- [How to put pivottable in bootstrap grid?](https://www.webdatarocks.com/question/how-to-put-pivottable-in-bootstrap-grid/): I want to put 2 tables side by side, for example:
- [How to get the average excluding zeros](https://www.webdatarocks.com/question/how-to-get-the-average-excluding-zeros/): Hi,   I want to exclude the zeros for the grade point average, I tried with this formula "if( ('Exam') > 0, sum('Exam')/count('Exam'), )"  but it is not working. Thank you very much for your help in advance.  
- [Unable to hide unused grid](https://www.webdatarocks.com/question/unable-to-hide-unused-grid/): This is related to this questionI tried the example in the answer & it worked. But if I put it inside a function it will throw TypeError.Here are my codes, the only different from the example is that it calls setupTable() function: <meta charset="ISO-8859-1"><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></head><body><div id="wrap"><div id="output"></div><script type="text/javascript">setupTable();function setupTable() {var pivot = new WebDataRocks({container: "#output",width: "100%",height: "100%",report: {dataSource: {filename: "https://cdn.webdatarocks.com/data/data.csv"},slice: {rows: ,columns: ,measures: },options: {grid: {showTotals: "off"}}}}); webdatarocks.on("reportchange", 'redraw');webdatarocks.on("reportcomplete", 'redraw'); function redraw() {let col = 0, row = 0;webdatarocks.customizeCell(function(cellStyle, cellData) {if (cellData.columnIndex > col) col = cellData.columnIndex;if (cellData.rowIndex > row) row = cellData.rowIndex;});webdatarocks.on("aftergriddraw", function() {webdatarocks.off("aftergriddraw");document.querySelector("#wrap").style.width = 100 * (col + 2) + 'px';document.querySelector("#wrap").style.height = 30 * ++row + 27 + 'px';});}}</script></body></html> The details of the error is:webdatarocks.js:11 Uncaught TypeError: Cannot read property 'call' of undefinedat b.e.dispatch (webdatarocks.js:11)at webdatarocks.js:1849 How to resolve this issue?
- [How does the error 'Maximum call stack size exceeded' happend when change language?](https://www.webdatarocks.com/question/how-does-the-error-maximum-call-stack-size-exceeded-happend-when-change-language/): Hi ,I met this question when I translate my pivot table into another language ,my project was based on vue and webpack . I'm sure the way to change language was totally followed the demo in documentation ,and it did work, but when my friend use the same code I sended to him ,the error  'Maximum call stack size exceeded' happend ,the different between us is that our npm packages is different, we have no idea about any possible reason.
- [Format cells not applied in Highcharts  if data by url](https://www.webdatarocks.com/question/format-cells-not-applied-in-highcharts-if-data-by-url/): Hi If data loaded by csv or json url then format cells not applied in Highcharts (any chart type). To reproduce this issue just save report from demo https://www.webdatarocks.com/doc/new-demos/ Then open page where report with chart https://codepen.io/webdatarocks/pen/qMaxoE and open saved report.  Or just connect to remote CSV and change format and you can see it's not applied in chart. Can this issue be fixed? Thanks.
- [First Column locked on mobile](https://www.webdatarocks.com/question/first-column-locked-on-mobile/): Hi all,Just wondering if anyone knows how to either unlock the first column when using a mobile device so that you can scroll through the whole table. The issue is that due to the first column being locked in position and the main body of the table being scrollable, when on a mobile device the main body is barely in view and so cannot be used. 
- [How Do I Save The Present state to a Server](https://www.webdatarocks.com/question/how-do-i-save-the-present-state-to-a-server/): Hi,   I am using Vue, and after selecting what columns to show up I will like to save the present state of the report to the server so when I revisit I see that state. Any pseudo code or examples
- [How can I add data to columns in the table?](https://www.webdatarocks.com/question/how-can-i-add-data-to-columns-in-the-table/): How can I editable to colums?? Like this: thishttp://jsfiddle.net/j7nuuyw4/2/
- [How can I do Editing table input?](https://www.webdatarocks.com/question/how-can-i-do-editing-table-input/): Do I have any way to edit the cell the same like this. I mean when user click on a summary cell, I can get new value and all the details which are used to calculate the value for this field and then update all of these. 
- [How to add pagination in pivot table.?](https://www.webdatarocks.com/question/how-to-add-pagination-in-pivot-table/)
- [Strange display: two toolbars](https://www.webdatarocks.com/question/strange-display-two-toolbars/): Hi, I have met the problem that there are two toolbars even I just called the webdatarocks once. All the others work fine. I used vue integration. Could someone help look into this? Thank you!
- [Brazilian Portuguese localization published in cdn is outdated](https://www.webdatarocks.com/question/brazilian-portuguese-localization-published-in-cdn-is-outdated/): The localization file stored in https://cdn.webdatarocks.com/loc/pr.json is not up to date with https://github.com/WebDataRocks/pivot-localizations/blob/master/pr.json
- [Swap default position of Values field](https://www.webdatarocks.com/question/swap-default-position-of-values-field/): Hi there, I'm trying to swap the position of the values field so that it shows as rows instead of the current default, columns. 
- [Toolbar Drop Down Menu Icons](https://www.webdatarocks.com/question/toolbar-drop-down-menu-icons/): This occurs on every drop down menu from the toolbar.  The icons are underneath the text for the menu item.  For example To Local CSV the icon is underneath/ontop of the text.
- [Custom aggregation functions](https://www.webdatarocks.com/question/custom-aggregation-functions/): I need a group of unsupported aggregation functions such as bitwise aggregations (logical OR, AND, XOR...). Can I easily create new aggregation functions? Does any API for that exist? P.S. In our reports such data as "Error Codes" from measuring devices are used. Most of them are bit mask-like numbers. So in reports we need aggregate all of the error codes. Thank You.
- [How to achieve Percentile or custom aggregation.](https://www.webdatarocks.com/question/how-to-achieve-percentile-or-custom-aggregation/): Want to find maximum in whole column and based on that need to calculate percentile. Note: I can find the maximum value from API and pass it to Pivot table, but it won't work when I filter/aggregate data.  Please find attached to check percentile.    
- [Is it possible to show sub-totals to the right of the data, rather than the left?](https://www.webdatarocks.com/question/is-it-possible-to-show-sub-totals-to-the-right-of-the-data-rather-than-the-left/): Is it possible to show sub-totals to the right of the data, rather than the left?  In the attached screenshot, you can see that the subscribers total is on the left, then it is broken down into Monthly & Annual.   I would prefer it to show Monthly, Annual and then the subscriber total.   Thanks
- [Conditional Formatting for a row & export](https://www.webdatarocks.com/question/conditional-formatting-for-a-row-export/): Hi, I am loving your work. I am trying to display an evolution between 2 data sets. I was able to do it but using CSS as follow : https://codepen.io/webdatarocks/pen/MxEdZx   Unfortunately at export the coloring disappeared. I there a way to keep the coloring as shown for conditional formatting? Another idea I had, I could add a column with a number: 1 if no change and 2 if changes. Can the full row be colorized based on one cell (and using conditional formatting)? It would not be as good since it not cell based but would at least be something.   Thanks in advance to anyone that could help. Max
- [Download report in PDF format without displaying data on grid](https://www.webdatarocks.com/question/download-report-in-pdf-format-without-displaying-data-on-grid/): Hi Team, We have license for webdatarocks. We have requirment for Angular8. I have to generate PDF report without showing data on UI. Is should simply download pdf for given json datasource
- [How to only show used cells and hide empty cells?](https://www.webdatarocks.com/question/how-to-only-show-used-cells-and-hide-empty-cells/): Hi there, I'm wondering id there is any way to only show the used cells of a table?
- [How to convert row and column data in grid into Chinese?](https://www.webdatarocks.com/question/how-to-convert-row-and-column-data-in-grid-into-chinese/): Look at the attachment I uploaded. I want to display the red line in Chinese, but I don't see similar operation in the document. What can I do to convert it? As for data, I want to directly assign a value after finding it from the database. The column and column names shown in the list should correspond to the data column names in the database
- [While export to excel, how to convert seconds to hh:mm:ss](https://www.webdatarocks.com/question/while-export-to-excel-how-to-convert-seconds-to-hhmmss/): I am using datatype as "time" for showing in hh:mm:ss format, but while exporting to excel, this feature is not working and it shows timing in seconds only. Any solution for this, thanks.  
- [Filter out a specific value](https://www.webdatarocks.com/question/filter-out-a-specific-value/): I have defined a specific slice with some filter definition. The filter definition works fine as long as there is some Data after applying filter, but if it happens that there would be no data left after applying the filter, the filter stops working. Is there any way to handle that?      
- [How to display a (static) measure once](https://www.webdatarocks.com/question/how-to-display-a-static-measure-once/): How can I display "Budget" column, which is static and will be the same, only once; whilst "Amount" is categorized by "Month"?
- [What requires to change Webdatarocks Grid to Flexmonster grid.](https://www.webdatarocks.com/question/what-requires-to-change-webdatarocks-grid-to-flexmonster-grid/): Please let me know following:
- [How to do conditional formatting dynamically?](https://www.webdatarocks.com/question/how-to-do-conditional-formatting-dynamically/): I have a requirement where user enters thresholds, currently I am able to  achieve using below : 
- [Multi level drill.](https://www.webdatarocks.com/question/multi-level-drill/): Able to achieve two level drill down Please refer this http://jsfiddle.net/6LXVQ/2/ Any way to achieve triple level drill down with help of pivot table.
- [Center the header](https://www.webdatarocks.com/question/center-the-header/): Hi team,   Wondering how to center the header row (not the row with 1, 2, 3 etc.) ? Currently it default to align left.   thanks,
- [Arabic issue in pdf export](https://www.webdatarocks.com/question/arabic-issue-in-pdf-export/): Need to export pdf file in arabic font and couldn't find any way to do that
- [drill down high charts](https://www.webdatarocks.com/question/drill-down-high-charts/): i try to use high charts and it works well but when i try to use drill down it is not working correctly . it shows me chart but drill down is not working. and for this i try this below link but in my code it is not working https://codepen.io/webdatarocks/pen/PLOJBj
- [Fixed Columns](https://www.webdatarocks.com/question/fixed-columns/): Hi team, I am wondering if there is a way to fixed the first n columns (in my case the first two) when scroll to the left? By default only the first column is fixed. Thanks,
- [Angular8](https://www.webdatarocks.com/question/angular8/): I have problems to integrate dataweb rock angular 8 works with that version ?.
- [How to sort rows for total sum?](https://www.webdatarocks.com/question/how-to-sort-rows-for-total-sum/): Hi, How to sort rows for total sum? Please check the case of my attached picture. thanks.
- [duplicate chart data](https://www.webdatarocks.com/question/duplicate-chart-data/): Hello, I'm trying to implement a pie chart but the data is displayed twice. Here is the code used :
- [How can I export charts as well as table ?](https://www.webdatarocks.com/question/how-can-i-export-charts-as-well-as-table/): How can I export charts as well as table ? I can export only table.  But I want to export chart as a PDF File. Help, Please!
- [Grouping In WebDataRocks](https://www.webdatarocks.com/question/grouping-in-webdatarocks/): How I can make Grouping webDataRocks reports
- [Convert measurable field (like Seconds) to hh:mm:ss](https://www.webdatarocks.com/question/convert-measurable-field-like-seconds-to-hhmmss/): I checked few previous answer but their requirement was related to Date. In my case, we get time in form of Seconds(duration) from the API. Now we want to convert the numeric seconds to hh:mm:ss.i.e. instead of showing 3890 we need to show 01:05:50Note : Please note that "Duration" is measure field and therefore SUM is used in its formula. Example : {Id: "I894",Duration : "3890",Long:"SM",Range:"LH"}  
- [How to perform exapand & collapse feature by one click on multiple fields? Don't want to hard code.](https://www.webdatarocks.com/question/how-to-perform-exapand-collapse-feature-by-one-click-on-multiple-fields-dont-want-to-hard-code/): If I have four fields in my pivot table, I don't want to click on the first field to go to the second field & then on the second field to go the third field & so on. I want to click on the first field & then it should expand all the fields & same for collapsing as well.
- [problem when i m using sorting in column](https://www.webdatarocks.com/question/problem-when-i-m-using-sorting-in-column/): (property) type: string
- [How to change formats in HH:MM:SS?](https://www.webdatarocks.com/question/how-to-change-formats-in-hhmmss/): I am getting the parameter in seconds, but I need to show in HH:MM: SS format. Currently, I am showing by using (parameter(e.g 5668)/3600), which shows 1.57, I don't want this & I don't want to hard code. Please help.
- [How to tuple all components](https://www.webdatarocks.com/question/how-to-tuple-all-components/): Can you please let me know is there any way to Tuple all components. I don't want to Hardcode tuples names.  
- [How to respond with a valid json ?](https://www.webdatarocks.com/question/how-to-respond-with-a-valid-json/): Hi,nice work with webdatarocks, thanks... but I have a question.How can I send to the client a json result with the data types included ? How is it possible if the json object demonstrated here Data Types is not a a valid json object ? The first object is not valid because it uses curly brackets instead of a string or a number right after of the first field's name.All the examples that I saw uses a static json with all fields configured and all values setted, but how can I put this to work in the real world if my server just can't respond with an invalid json (with the invalid first configuration object) ? Thanks in advance !Regards,Rafael
- [how to hide the empty cells/columns for multi level columns](https://www.webdatarocks.com/question/how-to-hide-the-empty-cells-columns-for-multi-level-columns/): Hi,  I have  4 levels columns as, Year of Date, Month from the Year, Quarters of year, and then Week.  and having 3 field values as the sum of Quantity, Sum of the Purchase price, and Sum of the Sales price. when expands the year, I can see the empty columns under that year. Same for the next levels...Please check the attached image for reference.   So how to remove those empty columns ...
- [How do we hardcoded Pivot structure from the first loading?](https://www.webdatarocks.com/question/how-do-we-hardcoded-pivot-structure-from-the-first-loading/): Hi, I am new here, but is there a way to hardcoded pivot structure so the user did not need to rearrange pivot structure? i want to use it as an monitoring system , so no touch on the structure  
- [TOP 10 Records filter modal does not refresh until top/bottom is clicked](https://www.webdatarocks.com/question/top-10-records-filter-modal-does-not-refresh-until-top-bottom-is-clicked/): I am facing Issue I goto column filter and select Top 10 option, but Top 10 option is not selected until I erase and type from keyboard the number of records or I click Bottom/Top button. By default Top button is highlighted but it doesnt work It even doe not work if I change TOp 10 records to 11 or 9 through Updown button that comes natively with Number control HTML.  
- [FieldList active all the time ?](https://www.webdatarocks.com/question/fieldlist-active-all-the-time/): Hi,   Great product! I had a question, is it possible to keep the FieldList Box active side by side with the gird? Rather than closing it and we would like to keep it active and when we hit apply, it should update the changes but the FieldList modal should not close. Any feedback would be appreciated.   Thanks!
- [Can I move the grand total column at top for columns and at start for rows?](https://www.webdatarocks.com/question/can-i-move-the-grand-total-column-at-top-for-columns-and-at-start-for-rows/): I want the grand total columns to be visible in the first go. So, can I move the total columns at start instead of the right most for rows. And also, Can i move the total column for bottom to top for columns. Can someone please help me with this. Thanks
- [Webdatarocks Highcharts – Save chart json from one page and display chart in another page](https://www.webdatarocks.com/question/webdatarocks-highcharts-save-chart-json-from-one-page-and-display-chart-in-another-page/): I am using webdatarocks highchart, I am required to save the highcharts complete json in a var and localstorage and then display that chart in another html page using javascript mainly. I am pretty new to this, any help would be highly appreciated. This is my script through which i am generating highcharts now i need to add the json of the chart that is generated and save that json in some variable and then use local storage to display that same chart in anoher html page
- [Error in CSV local path](https://www.webdatarocks.com/question/error-in-csv-local-path/): Unable to open file D:WDR\Test\ReportData.csv?442867340. It seems that this file doesn't exist or 'Access-Control-Allow-Origin' header is absent in the resource requested.Above error comes when i pass local path for CSV file.   <script type="text/javascript" charset="utf-8">var pivot = new WebDataRocks({container: "#wdr-component",toolbar: true,report: {dataSource: {filename: "D:\WDR\\Test\\ReportData.csv"}}});</script> 
- [Consistent error in webdatarocks](https://www.webdatarocks.com/question/issue-while-changing-pivot-table-type-in-webdatarocks-alogn-with-highcharts/): Hi Team,We are using webdatarocks and have integrated it with highcharts. We are consitently getting an error  'Cannot read property 'members' of undefined at o.composeData'. This error seems to be not breaking our code but is getting logs consistently in our logs. Can you please help us with details and also how can we fix this.Thanks,Arpit
- [Is there a way to auto email the report.](https://www.webdatarocks.com/question/is-there-a-way-to-auto-email-the-report/): Is there any way to get HTML content of the report so it can emailed. Please let me know, if same is available in Flexmonster. Thanks,    
- [Default Sorting of measure not working for Angular.](https://www.webdatarocks.com/question/default-sorting-of-measure-not-working-for-angular/): I am using Angular 9, please let me know how to do sorting of measures field. I tried sorting using type, tuple and measure. Please have attached screen shot for reference.       
- [how to use difference in calculated value](https://www.webdatarocks.com/question/how-to-use-difference-in-calculated-value/): HI,  difference is not working using calculated values also. I have 1 measure Quantity and i want to display the difference of that quantity in another column using calculated value. but it seems for both only default sum aggregation is used. can you help. Best Regards
- [When working on python data visualization, how to take care of security ?](https://www.webdatarocks.com/question/when-working-on-python-data-visualization-how-to-take-care-of-security/): We have all been working on python for data analytics and data visualization, but with the new age how to work with secure data visualization.
- [Date showing incorrect](https://www.webdatarocks.com/question/good-day-to-you-date-showing-incorrect/): Good day to you, Date showing incorrect, i am sending this format date '2020-06-19T00:00:00.000Z'  and i am getting 'jun 18 2020' You can refer to the screen shot  
- [How to do conditional formatting on cell.](https://www.webdatarocks.com/question/how-to-do-conditional-formatting-on-cell/): Thank you whole team for creating wonderful PIVOT table. while taking average I want to skip zero, so where I should place condition. I am using below :  {                 uniqueName: "Standard changeover",                 formula:"if( ('Standard changeover') > 0, sum('Standard changeover')/count('Standard changeover'),0)",                 aggregation: "average",                 format: "decimal2",                 caption: "Total Standard changeover",       }   But it is not working. please assist. Attached image for refernce.
- [Data limitation](https://www.webdatarocks.com/question/data-limitation/): Hi,   It is mentioned that the data size should not exceed 1 MB. Is there a way i can filter data that is greater than 1 MB?   Thanks Anupama
- [How to implement pivot table with chart in vue js](https://www.webdatarocks.com/question/how-to-implement-pivot-table-with-chart-in-vue-js/): How to implement pivot table with chart in vue js
- [When I called webdatarocks.getReport function Cannot read property 'toObject' of undefined](https://www.webdatarocks.com/question/when-i-called-webdatarocks-getreport-function-cannot-read-property-toobject-of-undefined/): Hi, When I called getReport function throw "Cannot read property 'toObject' of undefined". How can i fix bug?
- [How can i change the row hierarchy symbols with downward to plus symbol](https://www.webdatarocks.com/question/how-can-i-change-the-row-hierarchy-symbols-with-downward-to-plus-symbol/): How can i change the row hierarchy symbols with downward to plus symbol
- [How can i show the data bar in table and also tool tip on the cell](https://www.webdatarocks.com/question/how-can-i-show-the-data-bar-in-table-and-also-tool-tip-on-the-cell/): How can i show the conditional data bar in table and also tool tip on the cell
- [How to use webdarocks.fusioncharts.getData() with react](https://www.webdatarocks.com/question/how-to-use-webdarocks-fusioncharts-getdata-with-react/):  
- [Is there a way to especify a character string delimiter?](https://www.webdatarocks.com/question/is-there-a-way-to-especify-an-string-column-delimiter/): I have a csv with carriage return into strings, so webdatarokcs guess it's a new line but it's not so I would like to set the character string delimiter by something as  "" example data =; // a single data rowstringdelimiter = '"'; 
- [VUE Application with another pivot table extension, how to make JSON Format to export](https://www.webdatarocks.com/question/vue-application-with-another-pivot-table-extension-how-to-make-json-format-to-export/): Hello i have a VUE Application and i have got a request to make a export do PDF feature on my pivot table. I'm currently using vue-pivottable extension to generate my pivot table. So i was searching on the internet and found the WebDataRocks it looks like that i can export my pivot table using JSON to a PDF. I will attach the style of my pivot table on a image. So my question is how can i make a JSON from what i have on my pivot table to have a PDF generated using WebDataRocks. Thanks a lot!  
- [Merge column](https://www.webdatarocks.com/question/merge-column/): Can we merge the two column into one? Find the attachment
- [Data base connection](https://www.webdatarocks.com/question/data-base-connection/): Is there a way of connecting this tool to Oracle data base so that data can be loaded on real time basis?
- [Drill Up is not working](https://www.webdatarocks.com/question/drill-up-is-not-working/): When an hierarchy applied Drill Down function works perfect but couldn't Drill Up due to; TypeError: L9Z.slice is not a function
- [PivotTable supporting for windows application(C#)](https://www.webdatarocks.com/question/pivottable-supporting-for-windows-applicationc/): How to use PivotTable in windows application(C#)     Thanks in advance
- [Remove cells dont used](https://www.webdatarocks.com/question/remove-cells-dont-used/): Dear Friends I would like to know how to remove cells or columns dont used. I want to adapt the report in width and height without empty cells
- [Date as string works in chrome and its grouping as expected but in Firefox and edge date is splitting to 3 (Month day andd year)](https://www.webdatarocks.com/question/date-as-string-works-in-chrome-and-its-grouping-as-expected-but-in-firefox-and-edge-date-is-splitting-to-3-month-day-andd-year/): Date as string works in chrome and its grouping as expected but in Firefox and edge date is splitting to 3 (Month day and year)
- [refreshing wbr-pivot in angularjs environment. Does not work](https://www.webdatarocks.com/question/refreshing-wbr-pivot-in-angularjs-environment-does-not-work/): Hi, My application is using angularjs with webDatarocks. I've followed your tutorial. My approach has been this way. <div > <div wbr-pivot wbr-toolbar="true" wbr-report="wbr_templateId" ></div></div> The wbr_templateId is a variable ($scope.wbr_templateId) that I update in my angular controler. My problem is that when I update $scope.wbr_templateId in my controler the wbr-report is not updated. I've tried to enforce a $scope.$apply() but angularjs complains telling that $apply is already running So I don't know how to force a refresh of wbr-report Thanks a lot for your help and support Regards
- [How to hide the subtotal column when columns of slice has multi](https://www.webdatarocks.com/question/how-to-hide-the-subtotal-column-when-columns-of-slice-has-multi/):  Hi team. Please help to hide the subtotal columns.  Thanks   <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>  <script>    var data =    var pivot = new WebDataRocks({  container: "#wdr-component",  toolbar: true,  report: {  dataSource: {  data: data  },  slice: {  rows: ,  columns: ,  measures:  },  options: {  grid: {  showTotals:"off",  showGrandTotals:"off"  }  }  }  });  </script>  </body>  </html>  
- [How to get toolbar](https://www.webdatarocks.com/question/how-to-get-toolbar/): Hello WDR team, I need get toolbar the purpose is i need show/hide toolbar wrapper how can i get toolbar ?
- [How to combine toolbar 2 section in one scetion](https://www.webdatarocks.com/question/how-to-combine-toolbar-2-section-in-one-scetion/): Hello WDR team, I have a problem with toolbar how to i combine toolbar 2 section as you seen this image in one and first pivot have 4 menus but there is enough space with more 3 menu but its cannot include last menu icon what should i do?  
- [Is it possible use more than one file .json?](https://www.webdatarocks.com/question/is-it-possible-use-more-than-one-file-json/): I'd like to know if is it possible in webDataRocks use more than one file (.json) ? I have 5 diferents reports. Is it possible use api without .json extension at the end?    
- [How can we update styles of webdatarocks backgroun and other icons.](https://www.webdatarocks.com/question/how-can-we-update-styles-of-webdatarocks-backgroun-and-other-icons/): Hi, I was going through ways to change theme but i wanted to know is there any way to directly change the css classes. Thanks, Arpit
- [Event Listener Button Apply, Angular 8](https://www.webdatarocks.com/question/event-listener-button-apply-angular-8/): Hello WebDataRocks Group, a question: How can I add a click eventListener to the Apply button that is in the fields part to execute a TypeScript function in Angular 8, and tried to add a listener to that button in specific, but it doesn't leaves, neither by Dom or JavaScript. What I must do is when I give the Apply button consult an Api http again the data, according to the fields you select
- [Can we do subreports using this tool?](https://www.webdatarocks.com/question/can-we-do-subreports-using-this-tool/)
- [Can we do subreports using this pivit table](https://www.webdatarocks.com/question/can-we-do-subreports-using-this-pivit-table/): 4/5/2020               ItemName Country Total Qty Price A TESt 10 20 B TEST1 20 30   Total 30 50         6/5/2020       A TESt 20 30 B TEST1 10 20 C TEST2 13 50   Total 43 100
- [Team, Pelase help with showing a details view as drill drown in the pivot grid](https://www.webdatarocks.com/question/team-pelase-help-with-showing-a-details-view-as-drill-drown-in-the-pivot-grid/): Details as below, I have a list of data in json with completeddate column I need to group the data using this completeddate and onlick of the completeddate I need to show the detailview with all the columns in the same page itself
- [Rows in column](https://www.webdatarocks.com/question/rows-in-column/): How to give two rows in one column in pivot table?
- [Date as a string](https://www.webdatarocks.com/question/date-as-a-string/): "DateFrom": "2019-02-28T22:00:00.000Z",
- [How to get the data type of specific cell using onCustomizeCell() event](https://www.webdatarocks.com/question/how-to-get-the-data-type-of-specific-cell-using-oncustomizecell-event/): I want to get the cell data type and if the data type is date then I want to format the date from UTC to current time zone.
- [2 Report in One screen](https://www.webdatarocks.com/question/2-report-in-one-screen/): Hi Team, I need to use 2 different pivot table in one screen. I can able to do it in front end by calling function one by one.   But my issues is when im trying to load both pivot 1 and pivot 2 in different container from sql server using loop function. It displays only last pivot (pivot 2) . Pivot 1 div container only contain below tag it does not contain any data <div class="wdr-ui-element wdr-ui wdr-ui-container" id="wdr-pivot-view" style="width: 100%; height: 100%;"></div> Kindly suggest me a solution to load more than one report on screen load  
- [Bring selected and unselected fields from modal](https://www.webdatarocks.com/question/bring-selected-and-unselected-fields-from-modal/): Is there a way to list the selected fields in the modal and the ones that are not? of course with the condition that the Apply button is clicked, because it does not allow me to add an event listener to that specific button to take the values of the fields
- [Credit reference to WebDataRocks](https://www.webdatarocks.com/question/credit-reference-to-webdatarocks/): Currently in my Angular 8 project, I have the WebDataRocks (Pivot) integrated, my question in this regard is if I can remove this reference to your page or would I be violating any license or copyright term?   In the screenshot, I share what I mean by WebDataRocks credits
- [JavaScript runtime error: ‘Promise’ is undefined in IE](https://www.webdatarocks.com/question/javascript-runtime-error-promise-is-undefined-in-ie/): While using IE11 it return JavaScript runtime error: 'Promise' is undefined in webdatarocks.js filePlease suggest resolve this issue. Thanks in advance
- [Hi Team, I’m trying to integrate webDataRocks in reactjs but i keep getting errors](https://www.webdatarocks.com/question/hi-team-im-trying-to-install-webdatarocks-in-reactjs-but-i-keep-getting-errors/): I have included https://github.com/WebDataRocks/pivot-react/blob/master/ES6/src/webdatarocks.react.js file. After adding it, i get this error.  'types' can only be used in a .ts file.So  i commented from line-no 10 : propTypes, to line-no 44 then i got this below error/src/webdatarocks.react.js: Unexpected reserved type string (12:40)Here is a online-complier link https://stackblitz.com/edit/react-jvqtvb?embed=1&file=webdatarocks.react.jscan you pls help, team 
- [Decimal points in excel export](https://www.webdatarocks.com/question/decimal-points-in-excel-export/): How to reduce decimal points into two in excel exported file?
- [How to save only the config without dataSource?](https://www.webdatarocks.com/question/how-to-save-only-the-config-without-datasource/): Hi, Is there some way to save just the configuration of fields/functions/formats without dataSource tag in JSON file, and use this config to apply for a new dataSource loaded in a future time?
- [FieldsList will close when call execute updateData](https://www.webdatarocks.com/question/fieldslist-will-close-when-call-execute-updatedata/): Thanks for providing such an amazing tool! My question is that my data will update per 5 second, if user opend FieldsList window, it will soon close, makes bad experienced Waiting for your advise, Thx
- [Export Excel](https://www.webdatarocks.com/question/export-excel/): Hi,
- [Does WebDataRocks use other libraries for Excel, PDF & HTML Exports?](https://www.webdatarocks.com/question/does-webdatarocks-use-other-libraries-for-excel-pdf-html-exports/): The Excel, PDF & HTML exports don't work when run locally.  In scanning the javascript, I see what appears to be references to other libraries that don't appear to be bundled in download.zip. For example, the following code would suggest a docProps and xl folder that are not part of the download. var M3m = "docProps/core.xml";var I3m = "STORE";var n3m = "uint8array";var x3m = "docProps/app.xml";var H3m = "xl/theme/theme1.xml";var q3m = "xl/worksheets/sheet";var k3m = "_rels/.rels";var Q3m = "xl/workbook.xml";var h3m = "xl/sharedStrings.xml";var z3m = "xl/_rels/workbook.xml.rels";var C3m = "xl/styles.xml";
- [Round off values](https://www.webdatarocks.com/question/round-off-values/): How to round off a particular column value in pivot table?
- [How to set dinamic column to increase](https://www.webdatarocks.com/question/how-to-set-dinamic-column-to-increase/): Hi,   How to set dinamic column to increase
- [Particuler Column decimal value change](https://www.webdatarocks.com/question/particuler-column-decimal-value-change/): Hi, I was using "formula": "sum(\"X\")/sum(\"Y\")", how to set particular column decimal value as zero    
- [Row and column filter not working](https://www.webdatarocks.com/question/row-and-column-filter-not-working/): dataSource: { data: getData() },options: { grid: { type: "classic", title: "A New Title" } },
- [Generating Reports as attachments](https://www.webdatarocks.com/question/generating-reports-as-attachments/): Would it be possible to use node.js to leverage WebDataRocks functionality to generate a PDF or Excel so it could be sent as an attachment?
- [How to create a highchart 3d Pie chart](https://www.webdatarocks.com/question/how-to-create-a-highchart-3d-pie-chart/): Hi, I am trying to generate a 3D pie chart using Highcharts, unfortunately a 3D pie chart type is not supported. I noticed that the "prepareDataFunction" specifies that it can be used for unsupported chart types. Is it possible to create a Highchart 3D pie chart using this functionality, and if so can you please provide a demo. I was able to use Google Charts to do this, but I would prefer using Highcharts. Thanks for your help By the way, this is a great tool! I love it! Kenny
- [How to wrap column label in pivot table?](https://www.webdatarocks.com/question/how-to-wrap-column-label-in-pivot-table/): How to wrap column label in pivot table?

## Answer
- [Answer for How can I add data to columns in the table?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-can-i-add-data-to-columns-in-the-table/): Hello Ercan,   Thank you for the question. Actually, the pivot form is not editable.   Regards, WebDataRocks Team
- [Answer for How Do I Save The Present state to a Server](https://www.webdatarocks.com/dwqa-answer/answer-for-how-do-i-save-the-present-state-to-a-server/): Hello Tope,   Thank you for the question. A similar question was answered in the following thread: How to save a layout? Hope it helps.   Regards, WebDataRocks Team
- [Answer for How to put pivottable in bootstrap grid?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-put-pivottable-in-bootstrap-grid/): Hello Len,   Thank you for the question. Please refer to the following example with 2 columns: https://codepen.io/webdatarocks/pen/bGBqWrp Hope it helps.   Regards, WebDataRocks Team
- [Answer for How to get the average excluding zeros](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-get-the-average-excluding-zeros/): Hello, Walter,   Thank you for your question.   Currently, it is not possible to leave the value of the calculated measure blank. As a workaround, we suggest removing a cell's content using the customizeCell API call.   We hope it works for you. Regards, WebDataRocks Team
- [Answer for Unable to hide unused grid](https://www.webdatarocks.com/dwqa-answer/answer-for-unable-to-hide-unused-grid/): Hello, Ien,   Thank you for your question.   We suggest subscribing to the reportcomplete and reportchange events within the Flexmonster constructor to avoid the described issue: var pivot = new WebDataRocks({ container: "#output", width: "100%", height: "100%", report: { dataSource: { filename: "https://cdn.webdatarocks.com/data/data.csv" }, slice: { rows: , columns: , measures: }, options: { grid: { showTotals: "off" } } }, reportcomplete: redraw, reportchange: redraw });   We have modified the initial example to demonstrate this approach.   Our team hopes it works for your case.   Kind regards, WebDataRocks Team
- [Answer for How can I do Editing table input?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-can-i-do-editing-table-input/): Hello, Ercan,   Thank you for your question.   Please have a look at the following sample: https://codepen.io/webdatarocks/pen/wvzvZjy. It shows how to make cells editable and a simple ajax request that sends the edited data.   Here are some explanations of the code: In the example, every cell value is changed to an <input> tag using the customizeCell API call. We have added the onChange handler (lines 77-105 in the example) to track the changes in the input field.   The onChange function sends a post request with both old and new values and the difference between them. Please specify the request URL as a link to the script that will handle the request. That should help to apply the changes to the original dataset.   Hope it works for you!   Regards, WebDataRocks Team
- [Answer for Format cells not applied in Highcharts  if data by url](https://www.webdatarocks.com/dwqa-answer/answer-for-format-cells-not-applied-in-highcharts-if-data-by-url/): Hi Sergey,   Thank you for posting your question.   Please note that the cell number formatting in the grid is not passed to the Highcharts instance. For Highcharts number formatting and other configurations, please refer to the following documentation page: https://www.webdatarocks.com/doc/highcharts-getdata/.   We hope this helps.   Best regards, WebDataRocks team
- [Answer for How does the error 'Maximum call stack size exceeded' happend when change language?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-does-the-error-maximum-call-stack-size-exceeded-happend-when-change-language/): Hi!   Thank you for posting your question.   We haven't managed to reproduce the described behavior on our side – we'd suggest making sure you are fully following the steps described on the corresponding documentation page while also making sure you are using the latest WebDataRocks version.   We hope this helps.   Best regards, WebDataRocks team
- [Answer for Custom aggregation functions](https://www.webdatarocks.com/dwqa-answer/answer-for-custom-aggregation-functions/): Hello Veniamin, Thank you for writing to us. Currently, there is no easy way to extend the existing aggregation functions list with the custom one. Regards, WebDataRocks Team
- [Answer for How to achieve Percentile or custom aggregation.](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-achieve-percentile-or-custom-aggregation-2/): Hi,  It seems you can write such formula in WebDataRocks. The formula will look like this one: sum("value") / max("value") * 100. Regards, Hugo
- [Answer for Event on change cell format](https://www.webdatarocks.com/dwqa-answer/answer-for-event-on-change-cell-format-3/): Hello, Sergey,   Thank you for writing to us.   We have checked and it seems that the reportchange event is not fired when setting the number formatting. Our team has added this issue to our backlog.    Also, you are welcome to check out Flexmonster Pivot, which is a product developed by the same team. The reportchange event is fired as expected here.   Regards,WebDataRocks Team
- [Answer for First Column locked on mobile](https://www.webdatarocks.com/dwqa-answer/answer-for-first-column-locked-on-mobile/): You can resize the first column manually on the computer and then save the configuration by pressing the "Save" button in the toolbar. The information about column sizes will be stored under the "tableSizes" key. Then you just have to set such config where needed.
- [Answer for Event on change cell format](https://www.webdatarocks.com/dwqa-answer/answer-for-event-on-change-cell-format-2/): reportchange is not triggered if we do any changes in "Format cells" dialog. See your demo https://codepen.io/webdatarocks/pen/bQvwzz Looks like there is no any everts for format cells changes?
- [Answer for How to achieve Percentile or custom aggregation.](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-achieve-percentile-or-custom-aggregation/): any alternate solution for above query would be much appreciated.
- [Answer for How to add pagination in pivot table.?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-add-pagination-in-pivot-table/): Hi Nikhil,   Thank you for writing to us.   Please note that currently, WebDataRocks does not support grid pagination.   We hope this helps.   Best regards, WebDataRocks team
- [Answer for Strange display: two toolbars](https://www.webdatarocks.com/dwqa-answer/answer-for-strange-display-two-toolbars/): Hi Snen,   Thank you for posting your question.   So far, we haven't managed to reproduce the described behavior on our side. It would help us if you could provide a sample project where this is reproducible.    Looking forward to your response.   Best regards, WebDataRocks team
- [Answer for Brazilian Portuguese localization published in cdn is outdated](https://www.webdatarocks.com/dwqa-answer/answer-for-brazilian-portuguese-localization-published-in-cdn-is-outdated/): Hi!   Thank you for writing to us.   Please note that the localization files on the CDN have been updated and both versions are now up to date.   We hope this helps.   Best regards, WebDataRocks team
- [Answer for Conditional Formatting for a row & export](https://www.webdatarocks.com/dwqa-answer/answer-for-conditional-formatting-for-a-row-export-3/): Good morning, Thank you so much for your answer. I will be studying it and get back to you.   Sincerely, Max
- [Answer for Conditional Formatting for a row & export](https://www.webdatarocks.com/dwqa-answer/answer-for-conditional-formatting-for-a-row-export-2/): Hi, Maxime! Thank you for your kind words about our product and for your questions. 1. Is there a way to keep the coloring as shown for conditional formatting?We would like to kindly mention that the coloring shown in the example can not be achieved with the conditional formatting. Our team suggests exporting the grid to the server and coloring the cells in the Excel file on the backend. 2. Another idea I had, I could add a column with a number: 1 if no change and 2 if changes.Could you please elaborate more on the expected behavior? A screenshot or an example would greatly help us in our investigation. 3. Can the full row be colorized based on one cell (and using conditional formatting)?The described functionality can be configured with the use of the customizeCell method, but not with conditional formatting. Please kindly note that customizeCell does not apply coloring to the exported file. As you mentioned that the “not cell-based” solution will partly help, we have prepared an example with the formatting applied to the specific row based on the row number. The formatting will also appear in Excel. Please have a look: https://codepen.io/webdatarocks/pen/RwRRjjX. Hope it helps! Best regards,WebDataRocks Team
- [Answer for Download report in PDF format without displaying data on grid](https://www.webdatarocks.com/dwqa-answer/answer-for-download-report-in-pdf-format-without-displaying-data-on-grid-2/): Hello, Sandeep, Thank you for writing to us. To achieve the described behavior, we suggest using Puppeteer — a JavaScript library for working with headless browsers.We would like to draw your attention to the sample GitHub project with Puppeteer and our premium product – Flexmonster. Feel free to use this example as a reference. Hope it helps. Best regards,WebDataRocks Team
- [Answer for While export to excel, how to convert seconds to hh:mm:ss](https://www.webdatarocks.com/dwqa-answer/answer-for-while-export-to-excel-how-to-convert-seconds-to-hhmmss/): Hello, Raj, Thank you for posting to our forum. Our team wants to inform you that we did not manage to reproduce the issue with the "time" data type while exporting to Excel. We tested both on JSON and CSV data sources and specified the time field as row, column, and measure – timing in the exported file is shown in the hh:mm:ss format. Could you please provide us with the code snippet or modify this example in a way the issue is reproducible? This would greatly help us in our further investigation. Looking forward to your response. Best regards,WebDataRocks Team
- [Answer for Toolbar Drop Down Menu Icons](https://www.webdatarocks.com/dwqa-answer/answer-for-toolbar-drop-down-menu-icons-3/): I was able to create a CSS override that corrected this issue.
- [Answer for Toolbar Drop Down Menu Icons](https://www.webdatarocks.com/dwqa-answer/answer-for-toolbar-drop-down-menu-icons-2/): I was able to create a CSS override that corrected this issue.
- [Answer for Swap default position of Values field](https://www.webdatarocks.com/dwqa-answer/answer-for-swap-default-position-of-values-field-2/): That's perfect, thank you. 
- [Answer for Swap default position of Values field](https://www.webdatarocks.com/dwqa-answer/answer-for-swap-default-position-of-values-field/): Hello, Finn,   Thank you for contacting us.   To change the default position of values, place the following object to the rows array of the Slice Object: rows: In this case, values will be displayed in rows by default. If you need to change the position of the values after the initialization of the component, use the runQuery method. It takes a Query Object as an argument and runs it. The Query Object contains a slice with rows, columns, measures, and reportFilters.   We hope it works for you. Please contact us if further assistance is needed.   Kind regards, Illia
- [Answer for Toolbar Drop Down Menu Icons](https://www.webdatarocks.com/dwqa-answer/answer-for-toolbar-drop-down-menu-icons/): Hello, Jeff,   Thank you for contacting us.   Our team did not manage to reproduce the described behavior. Therefore, we want to ask you for a sample where the issue would be reproducible. For example, you can use the CodePen template to share the example.   We are looking forward to hearing from you.   Best regards, WebDataRocks Team
- [Answer for Is it possible to show sub-totals to the right of the data, rather than the left?](https://www.webdatarocks.com/dwqa-answer/answer-for-is-it-possible-to-show-sub-totals-to-the-right-of-the-data-rather-than-the-left/): Hello, Gary,   Thank you for contacting us.   We would like to explain that the subtotals' position can not be changed. Subtotals are always displayed right under the expanded member.   Please contact us in case other questions arise.   Kind regards, WebDataRocks Team 
- [Answer for Bug table resizing when browser scale changes](https://www.webdatarocks.com/dwqa-answer/answer-for-bug-table-resizing-when-browser-scale-changes-5/): Hello, Hitesh,   Thank you for your question.   We want to kindly inform you that there are no updates on this matter for now.   Kind regards, WebDataRocks Team
- [Answer for How to display a (static) measure once](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-display-a-static-measure-once-2/): Hello,   Thank you for contacting us.   We would like to explain that all measures added to the slice will be aggregated and displayed based on intersections of fields added to columns and rows arrays. Therefore, it is not possible to change the behavior of a separate measure.   Our team suggests considering creating an additional instance of WebDataRocks to display the "Budget" measure with the desired configuration.   We hope it helps. Please contact us in case other questions arise.   Regards, Illia
- [Answer for How to display a (static) measure once](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-display-a-static-measure-once/): Hello,   Thank you for contacting us.   We would like to explain that all measures added to the slice will be aggregated and displayed based on intersections of fields added to columns and rows arrays. Therefore, it is not possible to change the behavior of a separate measure.   Our team suggests considering creating an additional instance of WebDataRocks to display the "Budget" measure with the desired configuration.   We hope it helps. Please contact us in case other questions arise.   Regards, Illia
- [Answer for Filter out a specific value](https://www.webdatarocks.com/dwqa-answer/answer-for-filter-out-a-specific-value-2/): Hello, Saad,   Thank you for reporting the problem.   We have managed to reproduce the issue on our side.Our team will consider it while releasing the next version of the component.   Please contact us in case further questions arise.   Best regards,WebDataRocks Team
- [Answer for Filter out a specific value](https://www.webdatarocks.com/dwqa-answer/answer-for-filter-out-a-specific-value/): Hello, Saad,   Thank you for reporting the problem.   We have managed to reproduce the issue on our side.Our team will consider it while releasing the next version of the component.   Please contact us in case further questions arise.   Best regards,WebDataRocks Team
- [Answer for How to convert row and column data in grid into Chinese?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-convert-row-and-column-data-in-grid-into-chinese/): Hello,   Thank you for contacting us.   We did not manage to find the attachment you have mentioned in your question. Please try uploading the file again.   As for now, we suggest checking out our localization guide to learn the general approach of localizing the component.   Concerning the data set itself, we want to explain that it cannot be changed after loading to WebDataRocks. Therefore, we recommend preprocessing your data set and feed it to the component with desired column names.   We hope it helps. Please contact us if further questions occur.   Regards, WebDataRocks Team
- [Answer for How to only show used cells and hide empty cells?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-only-show-used-cells-and-hide-empty-cells-2/): Hello, Finn,   Thank you for contacting us.   We would like to inform you that the mentioned example is the only known way to render only used part of the grid.   Please contact us in case other questions arise.   Kind regards, WebDataRocks Team  
- [Answer for Download report in PDF format without displaying data on grid](https://www.webdatarocks.com/dwqa-answer/answer-for-download-report-in-pdf-format-without-displaying-data-on-grid/): Hi Can someone help on it
- [Answer for Conditional Formatting for a row & export](https://www.webdatarocks.com/dwqa-answer/answer-for-conditional-formatting-for-a-row-export/): I think I need to clarify. It’s xlsx export, and when exporting conditional formatting the xlsx keeps the cell coloring but not using css. I would like to understand how that works to find a fix.
- [Answer for How to do conditional formatting dynamically?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-do-conditional-formatting-dynamically/): Hello, Raj, Thank you for writing to us. 
- [Answer for What requires to change Webdatarocks Grid to Flexmonster grid.](https://www.webdatarocks.com/dwqa-answer/answer-for-what-requires-to-change-webdatarocks-grid-to-flexmonster-grid/): Hello, Raj, Thank you for your questions. 
- [Answer for Multi level drill.](https://www.webdatarocks.com/dwqa-answer/answer-for-multi-level-drill-2/): Hello, Raj! Thank you for your question. Please have a look at our Highcharts with drill-down example.It has a two-level drill-down, but you are welcome to implement the third level on your side. Further information about integration with Highcharts could be found in this article.Also, we suggest browsing Highcharts functionality here: https://www.highcharts.com/. Hope it helps. Best regards,WebDataRocks Team
- [Answer for Multi level drill.](https://www.webdatarocks.com/dwqa-answer/answer-for-multi-level-drill/): My answer is not visible to me.
- [Answer for How to only show used cells and hide empty cells?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-only-show-used-cells-and-hide-empty-cells/): Hi all, I have come across this answer which manually calculates the size of the table by giving each cell a fixed height/width. Is this the only way to do this ? 
- [Answer for problem when i m using sorting in column](https://www.webdatarocks.com/dwqa-answer/answer-for-problem-when-i-m-using-sorting-in-column/): Hi!   Thank you for posting your question.   In order for us to reproduce the mentioned exception, do you think you could give us more details on how the described behavior can be achieved? Your report configurations and detailed steps would be really helpful.   Looking forward to your response.   Best regards, WebDataRocks team
- [Answer for Consistent error in webdatarocks](https://www.webdatarocks.com/dwqa-answer/answer-for-consistent-error-in-webdatarocks-2/): Hi Arpit,   Thank you for explaining the issue further.   We have managed to reproduce the described behavior and our team will consider it when releasing the next version of the component.   Please let us know if you have any other questions we can assist you with.   Best regards, WebDataRocks team
- [Answer for Convert measurable field (like Seconds) to hh:mm:ss](https://www.webdatarocks.com/dwqa-answer/answer-for-convert-measurable-field-like-seconds-to-hhmmss-4/): Hello, Raj,   Thank you for contacting us.   We want to explain that Flexmonster provides Highcharts with raw data. It means time formatting is not applied on values passed to the Highcharts instance. Currently, we are not ready to recommend the workaround to overcome this limitation.   Our team suggests checking our Flexmonster Pivot, which is a premium product developed by the same team. Flexmonster allows preprocessing the data before it is passed to the charting library (prepareDataFunction).   We hope it helps. Please contact us in case other questions arise.   Kind regards, WebDataRocks Team 
- [Answer for Center the header](https://www.webdatarocks.com/dwqa-answer/answer-for-center-the-header/): Hello,   Thank you for writing to us.   To change the alignment of the header cells, overwrite the CSS style of the corresponding elements. For example, use the following selectors to change the styling of the header cells in columns/rows correspondingly: .wdr-header-c, .wdr-header-r.   Please see the CodePen demonstrating the described approach for centering header cells in columns.   Our team hopes it works for your case. Do not hesitate to contact us in case other questions arise.   Regards, WebDataRocks Team
- [Answer for Fixed Columns](https://www.webdatarocks.com/dwqa-answer/answer-for-fixed-columns-3/): Hello,   Thank you for providing us with details.   Our team wants to explain that it is not possible to fix a specific column from the scrollable area. Also, we want to confirm that the desired behavior can not be imitated using the classic form.   Please contact us in case other questions arise.   Regards, WebDataRocks Team
- [Answer for Arabic issue in pdf export](https://www.webdatarocks.com/dwqa-answer/answer-for-arabic-issue-in-pdf-export/): Hello,   Thank you for reaching out to us.   We would like to kindly inform you that the current library which performs the export does not support such symbols. Therefore, we recommend using other types of export.   Also, you are welcome to check out Flexmonster Pivot, which is the premium product developed by the same team. Flexmonster allows adjusting the font that you can use to support almost any language in the world.   Regards, WebDataRocks Team
- [Answer for drill down high charts](https://www.webdatarocks.com/dwqa-answer/answer-for-drill-down-high-charts/): Hello,   Thank you for reaching out to us.   We want to ask you for an example where the problem is reproducible. Our team suggests modifying the previously provided CodePen so that the issue can be seen.   We are looking forward to hearing from you.   Kind regards, WebDataRocks Team
- [Answer for Bug table resizing when browser scale changes](https://www.webdatarocks.com/dwqa-answer/answer-for-bug-table-resizing-when-browser-scale-changes-4/): Any updates on this? For me this happens on almost all codepen examples of webdatarocks But it does not happen on the webdatarocks site itself Is there a workaround that can be used?      
- [Answer for Convert measurable field (like Seconds) to hh:mm:ss](https://www.webdatarocks.com/dwqa-answer/answer-for-convert-measurable-field-like-seconds-to-hhmmss-3/): This works as expected, but I noticed that it doesn't works for High Chart.(created using PIVOT table). It would be great if you could assist us on this.
- [Answer for Fixed Columns](https://www.webdatarocks.com/dwqa-answer/answer-for-fixed-columns-2/): Thanks, though it is not exactly what I want. For example, I have my first column after the field column as the counts column and would like to fixed the counts column when I scroll to the right. Don’t think it can be archived by classic table?   thanks,
- [Answer for How to sort rows for total sum?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-sort-rows-for-total-sum/): Hello, David!   Thank you for reaching out to us.   Our team wants to explain that sorting does not affect the order of measures. Sorting is performed within one measure, ordering corresponding members of the field. In your case, no fields are chosen for columns. As a result, sorting does not affect the grid. Please try placing an additional hierarchy to columns in order to learn how sorting by values works in Flexmonster.   In case the order of measures needs to be changed, the Slice Object should be used. Measures will be ordered in the same way they are placed in the measures array of the mentioned slice object.   We hope it works for your case. Please contact us in case other questions arise. Regards,WebDataRocks Team
- [Answer for Fixed Columns](https://www.webdatarocks.com/dwqa-answer/answer-for-fixed-columns/): Hello, Peter!   Thank you for contacting us.   Our team would like to explain that frozen columns represent the field's members. Scrollable columns of the page hold measures themselves.   In case your requirement is to represent members of each added field as a new column, we suggest using the classic form of the pivot. Please refer to the following sample where different forms of the pivot can be compared.   We hope it works for you. Please contact us in case any other questions arise. Kind regards, WebDataRocks Team
- [Answer for Angular8](https://www.webdatarocks.com/dwqa-answer/answer-for-angular8/): Hello,   Thank you for reaching out to us.   WebDataRocks can be integrated with Angular 2+ versions including Angular 8.   Please follow our tutorial on integration with Angular. Also, we recommend checking out the ready-to-use sample demonstrating integration with Angular on our GitHub.   In case you still have obstacles preventing you from integrating with Angular, please provide us with detailed information about the exact problem you are facing.   Our team is looking forward to hearing from you. Regards, WebDataRocks Team
- [Answer for duplicate chart data](https://www.webdatarocks.com/dwqa-answer/answer-for-duplicate-chart-data/): Hello,   Thank you for reaching out to us.   Our team would like to inform you that we did not manage to reproduce the problem using the provided code snippet.   Please prepare the sample where the issue would be reproducible. We suggest using the following CodePen example as a template: https://codepen.io/webdatarocks/pen/RwaVmqq.   Our team is looking forward to hearing from you.   Kind regards, WebDataRocks Team
- [Answer for How can I export charts as well as table ?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-can-i-export-charts-as-well-as-table/): Hello,   Thank you for reaching out to us.   Our team wants to explain that charts should be exported with the capabilities of the third-party charting library used in your case. Being integrated with a specific charting library, Flexmonster serves as a data provider and does not provide control over the library itself. Please refer to the documentation of the library used in your case in order to learn the way to export charts.   We hope it works for you. Please contact us in case other questions arise.   Regards, WebDataRocks Team
- [Answer for How to tuple all components](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-tuple-all-components-3/): Hello! Thank you for providing further details about the case. WebDataRocks does not support the described feature, but we would like to suggest possible workarounds:
- [Answer for Convert measurable field (like Seconds) to hh:mm:ss](https://www.webdatarocks.com/dwqa-answer/answer-for-convert-measurable-field-like-seconds-to-hhmmss-2/): Thanks you, so nice of you.
- [Answer for Grouping In WebDataRocks](https://www.webdatarocks.com/dwqa-answer/answer-for-grouping-in-webdatarocks/): Hello, Ahmed,   Thank you for reaching out to us.   We want to ask you to provide us with details about the result you want to achieve. A detailed explanation of the required functionality or illustrative examples (for example, screenshots) would be appropriate options.   We are looking forward to hearing from you.   Kind regards, WebDataRocks Team
- [Answer for Convert measurable field (like Seconds) to hh:mm:ss](https://www.webdatarocks.com/dwqa-answer/answer-for-convert-measurable-field-like-seconds-to-hhmmss/): Hello, Raj,   Thank you for your question.   The desired result can be achieved by specifying the time data type for the "Duration" field. Please see an example demonstrating the mentioned approach.   Detailed information about supported data types and the way to define them can be found in our documentation.   We hope it works for your case. Please contact us in case other questions arise.   Regards, WebDataRocks Team
- [Answer for How do we hardcoded Pivot structure from the first loading?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-do-we-hardcoded-pivot-structure-from-the-first-loading/): Hello, Vaynard! Thank you for writing to us. We would like to confirm that there is a way to specify the pivot table structure so the user does not need to rearrange it. To define which fields should be placed into the rows, columns, and measures, please use the Slice Object in the report.The view and functionality available for users could be specified in the Options Object. Please see an example that could be useful for the monitoring system case: https://codepen.io/webdatarocks/pen/ExKjeaJ. We hope it helps. Best regards,WebDataRocks Team
- [Answer for How to perform exapand & collapse feature by one click on multiple fields? Don't want to hard code.](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-perform-exapand-collapse-feature-by-one-click-on-multiple-fields-dont-want-to-hard-code/): Hello, Mohit! Thank you for your question. To implement the described functionality, we suggest using the setReport API call. Please define the slice with all desired expands, pass the report to the setReport method, and invoke it on click.Our team also recommends specifying the data source in the global object to load the data once. Please have a look at the example. Also, we would like to mention expandAllData() and collapseAllData() API calls. They expand/collapse all nodes and perform drill-down/drill-up of all hierarchies in the slice on the grid. Hope it helps. Regards,WebDataRocks Team
- [Answer for Hi Team, I’m trying to integrate webDataRocks in reactjs but i keep getting errors](https://www.webdatarocks.com/dwqa-answer/answer-for-hi-team-im-trying-to-integrate-webdatarocks-in-reactjs-but-i-keep-getting-errors-3/): Hello, Dorcas Essien,   Thank you for contacting us.   Our team wants to explain that no separate npm package containing WebDataRocks for React exists. We suggest checking out our step-by-step tutorial on integration with React in order to learn the correct way to embed WebDataRocks into React application.   Our team hopes it works for your case.   Kind regards, WebDataRocks Team
- [Answer for how to hide the empty cells/columns for multi level columns](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-hide-the-empty-cells-columns-for-multi-level-columns/): Hello,   Thank you for reaching out to us.   Our team wants to explain that such empty columns appear due to the fact the subtotals are turned off. This behavior can not be changed in the current version of WebDataRocks.   Empty columns may be avoided by turning on the subtotals.   Also, we would like to kindly draw your attention to Flexmonster Pivot, which is the premium product developed by the same team. It has built-in functionality, allowing to hide corresponding columns in case subtotals do not need to be displayed.   We hope it helps. Please contact us in case other questions arise.   Regards, WebDataRocks Team
- [Answer for How to get report table HTML content?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-get-report-table-html-content-9/): Hugo
- [Answer for Webdatarocks Highcharts – Save chart json from one page and display chart in another page](https://www.webdatarocks.com/dwqa-answer/answer-for-webdatarocks-highcharts-save-chart-json-from-one-page-and-display-chart-in-another-page/): Hello,   Thank you for the question. It is definitely possible to store the config in the localStorage and use it later on the other page. Could you please check that the script you are referring is attached to the question so that we can take a look for more details?   Regards, WebDataRocks Team
- [Answer for Default Sorting of measure not working for Angular.](https://www.webdatarocks.com/dwqa-answer/answer-for-default-sorting-of-measure-not-working-for-angular-2/): Hi, It seems you have the issue with typescript compiler. If you define your report property with the type any, typescript should compile it correctly.
- [Answer for error Access-Control-Allow-Origin](https://www.webdatarocks.com/dwqa-answer/answer-for-error-access-control-allow-origin-5/): Hi, I think the possible issue here is the asynchronous nature of ajax call. That means you won't have reportData loaded when it comes to new WebDataRocks execution. In such a case, you should either create WebDataRocks instance when you are totally sure that reportData is loaded or inject the reportData into WebDataRocks instance when reportData is ready.
- [Answer for How to tuple all components](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-tuple-all-components-2/): Thanks you team for your response. I am using "Classic" mode. (As a client requirement) Actually I want to expand whole row with multiple columns on a single click. So to achieve it and I did below code and works fine. But I want to make tuples dynamic or you can say I want to make all my batches inside the tuple. i.e I don't want to Hardcode every batch inside the tuple. expands: { expandAll: true, rows: }, {tuple: }, { tuple: } ]}e    
- [Answer for How to change formats in HH:MM:SS?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-change-formats-in-hhmmss-3/): Hi all,   Thank you for posting to our support forum.   WebDataRocks needs input dates in the ISO 8601 date format, for example "2020-08-20T15:50:00". Inside our component, dates can be treated in various ways by setting the data types for CSV or JSON.   Finally, to format how dates are represented, apply datePattern or dateTimePattern from the Options Object.   We hope it helps.   Regards, WebDataRocks team
- [Answer for How to tuple all components](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-tuple-all-components/): Hi Raj,   Thank you for your question.   In case you want to expand all nodes, we suggest using the expandAll property from the Slice Object.    If your use-case is different, could you please share more information on what are you trying to achieve?   Regards, WebDataRocks team
- [Answer for How to change formats in HH:MM:SS?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-change-formats-in-hhmmss-2/): This may help : https://www.webdatarocks.com/doc/customizecell/
- [Answer for Hi Team, I’m trying to integrate webDataRocks in reactjs but i keep getting errors](https://www.webdatarocks.com/dwqa-answer/answer-for-hi-team-im-trying-to-integrate-webdatarocks-in-reactjs-but-i-keep-getting-errors-2/): Hi Webdatarocks team, Am trying to import 'webdatarocks.react' into my react project but am getting the error that "webdatarocks.react@latest can not be found in the npm register"  
- [Answer for How to change formats in HH:MM:SS?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-change-formats-in-hhmmss/): Sorry it isn't an answer but I am looking at exactly the same thing today. Did you get anywhere?
- [Answer for Default Sorting of measure not working for Angular.](https://www.webdatarocks.com/dwqa-answer/answer-for-default-sorting-of-measure-not-working-for-angular/): Can you please let me know if Sorting of Measured(Calculative) field works in Angular. If possible please give an example.
- [Answer for How to do conditional formatting on cell.](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-do-conditional-formatting-on-cell-2/): Thanks for best solution, it worked.
- [Answer for How to respond with a valid json ?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-respond-with-a-valid-json-2/): Hello Rafael,   We are glad to hear you resolved the problem. Please let us know in case of any other questions.   Regards, WebDataRocks Team
- [Answer for How to respond with a valid json ?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-respond-with-a-valid-json/): My fault, it works like a charm... I just changed the first json config object to a valid format and everything works great. I created a method to serialize the "datatable" into a json with fields config inside. Thanks !!!!
- [Answer for Error in CSV local path](https://www.webdatarocks.com/dwqa-answer/answer-for-error-in-csv-local-path/): Hello, Sushil, Thank you for writing to us. Please note that WebDataRocks is a web-based pivot grid, and hard drive files can’t be read by the web-page. Our team would like to suggest storing files on the server and specifying the corresponding link in the filename.In case it is necessary to connect to the local CSV file, we would like to mention that our component allows the user to select the file. Please have a look at the example. Hope it helps. Best regards,Milena
- [Answer for Consistent error in webdatarocks](https://www.webdatarocks.com/dwqa-answer/answer-for-consistent-error-in-webdatarocks-3/): This behavior i feel it comes whenever we try to convert compact/classic form to flat form. We have integrated the library with highcharts initially. Now we are using chart.js
- [Answer for TOP 10 Records filter modal does not refresh until top/bottom is clicked](https://www.webdatarocks.com/dwqa-answer/answer-for-top-10-records-filter-modal-does-not-refresh-until-top-bottom-is-clicked/): Hello, Saad,   Thank you for reporting the problem. We have managed to reproduce the issue on our side.Our team will consider it while releasing the next version of the component. Please contact us in case further questions arise. Best regards,WebDataRocks Team
- [Answer for FieldList active all the time ?](https://www.webdatarocks.com/dwqa-answer/answer-for-fieldlist-active-all-the-time/): Hello, Moiz, Thank you for your question and nice words about our product. We would like to suggest developing a new field list located side by side with the grid.For implementation please use the following API calls: getAllHierarchies(), getAllMeasures(), runQuery() etc. Also, we would like to kindly draw your attention to Flexmonster Pivot, which is the premium product developed by the same team. It has built-in functionality, which allows showing the Field List next to the grid by defining one property in the report. Hope it helps. Regards,WebDataRocks Team
- [Answer for error Access-Control-Allow-Origin](https://www.webdatarocks.com/dwqa-answer/answer-for-error-access-control-allow-origin-4/): anyone help , how to use ajax in   reportData='<?php echo $FilterReport ?>';var pivot = new WebDataRocks({container: "#wdr-component",height: 395,toolbar: true,report: reportData});
- [Answer for Merge column](https://www.webdatarocks.com/dwqa-answer/answer-for-merge-column-3/): Hello, Ashlesha,   Thank you for writing to us.   We have prepared an example that solves your issue. As you can see expanded hierarchy members in columns (for example, Australia) have no borders inside.You are welcome to use the CSS to customize more and get the desired view of a merged column.   We hope it helps.   Best regards,WebDataRocks team
- [Answer for Can I move the grand total column at top for columns and at start for rows?](https://www.webdatarocks.com/dwqa-answer/answer-for-can-i-move-the-grand-total-column-at-top-for-columns-and-at-start-for-rows/): Hello, Ashlesha, Thank you for writing to us. Our component is designed to display totals and grand totals after all columns and rows respectively. This template is fixed.   The only way to solve your issue is to create one more instance of WebDataRocks and show either totals column or grand totals row. We hope it helps. Kind regards,WebDataRocks team
- [Answer for Consistent error in webdatarocks](https://www.webdatarocks.com/dwqa-answer/answer-for-consistent-error-in-webdatarocks/): Hi Arpit,   Thank you for posting your question.   We didn't manage to reproduce the described behavior so far. Do you think you could give us more details on this, such as the sample report with which the issue is reproducible, for example?    Thank you in advance.    Best regards, WebDataRocks team
- [Answer for Is there a way to auto email the report.](https://www.webdatarocks.com/dwqa-answer/answer-for-is-there-a-way-to-auto-email-the-report/): You can just use the exportTo() API call to export the pivot table to HTML – then send the downloaded file via email. As far as I know, the same works with Flexmonster.
- [Answer for How to get report table HTML content?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-get-report-table-html-content-8/): Hi Hugo, What will I send as the element sent to the method in the source you sent?   Thanks.
- [Answer for how to use difference in calculated value](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-use-difference-in-calculated-value/): Hello, Ramakrishna, Thank you for reaching out to us.   It seems we have answered your question into another forum thread. You are welcome to check out it by the link: https://www.webdatarocks.com/question/how-to-add-field-twice/.   Regards, WebDataRocks Team
- [Answer for How to do conditional formatting on cell.](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-do-conditional-formatting-on-cell/): The easiest way to add conditional formatting is to use the toolbar's Conditional formatting control. After that, you can save the new config with the "Save" button.
- [Answer for How to use webdarocks.fusioncharts.getData() with react](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-use-webdarocks-fusioncharts-getdata-with-react-2/): Hello Marco, Thank you for writing.   Please check our updated GitHub sample: https://github.com/WebDataRocks/pivot-react/blob/master/ES6/src/App.js. It describes the way you can refer to Webdatarocks instance.   To enable Fusionchart support please add an additional import:   import "webdatarocks/webdatarocks.fusionchart"; Regards, WebDataTocks Team
- [Answer for Localization with 2 pivot tables not working](https://www.webdatarocks.com/dwqa-answer/answer-for-localization-with-2-pivot-tables-not-working-5/): Hello,   Unfortunately, still there is no workaround for this issue.   Best regards,WebDataRocks team
- [Answer for How to get report table HTML content?](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-get-report-table-html-content-7/): Hello Cihan,   Actually, SSR (server-side rendering) is not required, if I understood you correctly. Exporting to the server is just a workaround to prevent downloading the file and getting its content to JS callback. Then, you can trigger printing html using some code, for example: https://stackoverflow.com/questions/2255291/print-the-contents-of-a-div   Hope this helps. 
- [Answer for How to add field twice](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-add-field-twice-3/): Hello, Ramakrishna,   Thank you for your question.    We would like to let you know that this is a known issue related to the difference aggregation. Our team can suggest the following workaround for this issue: Create several calculated measures with all the necessary aggregations Include the measure with difference aggregation to the slice and set "active": false   Please refer to the code snippet below: "measures": We hope this workaround helps.   Best regards, WebDataRocks team
- [Answer for When working on python data visualization, how to take care of security ?](https://www.webdatarocks.com/dwqa-answer/answer-for-when-working-on-python-data-visualization-how-to-take-care-of-security-2/): Hi,    Thank you for posting to our forum.    Please kindly note that WebDataRocks is a data visualization tool that is embedded in the client-side application. Accordingly, the data security as well as access levels should be handled in a parent application.    We hope our answer helps.     Best regards, WebDataRocks team
- [Answer for Merge column](https://www.webdatarocks.com/dwqa-answer/answer-for-merge-column-2/): I have a similar question. Can you please send a sample if possible for merging these cells using the wdr-header-c and wdr-empty CSS classes. It would be very helpful.   Thanks
- [Answer for Date showing incorrect](https://www.webdatarocks.com/dwqa-answer/answer-for-date-showing-incorrect/): Hello, Bujar,    Thank you for writing to us.    To fix the described issue our team kindly recommends defining type: "date string"and "datePattern": "UTC:dd-MM-yyyy". Please have a look at the example we have prepared for you. Also, we suggest browsing Data types and Options object articles for further details.   Do not hesitate to contact us in case additional questions appear.   Regards,   WebDataRocks Team
- [Answer for How to implement pivot table with chart in vue js](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-implement-pivot-table-with-chart-in-vue-js/): Hello, Suman,   Thank you for your question.    Please, find out an example of integrating amCharts into Vue project by following the link below: https://codepen.io/webdatarocks/pen/JjGpwyo. For more details about integrating WebDataRocks with amCharts, please see: https://www.webdatarocks.com/doc/integration-with-amcharts/.   We hope this helps.    Kind regards,  WebDataRocks Team
- [Answer for How to add field twice](https://www.webdatarocks.com/dwqa-answer/answer-for-how-to-add-field-twice-2/): HI, for the above, its not working using calculated values also. I have 1 measure Quantity and i want to display the difference of that quantity in another column using calculated value. but it seems for both only default sum aggregation is used. can you help. Best Regards
- [Answer for When working on python data visualization, how to take care of security ?](https://www.webdatarocks.com/dwqa-answer/answer-for-when-working-on-python-data-visualization-how-to-take-care-of-security/): I have come across a lecture based on this by Dr. Ferda Özdemir Sönmez, PMP, Ph.D. https://www.udemy.com/course/security-data-visualization/?couponCode=ONDOKUZ

## Sections
- [Integration with Python](https://www.webdatarocks.com/api/integration-with-python/)
- [List of API methods](https://www.webdatarocks.com/api/list-of-api-methods/)
- [cgdfgd](https://www.webdatarocks.com/api/cgdfgd/)

## Guides
- [Documentation (Vue)](https://www.webdatarocks.com/guide/documentation-vue/)
- [Documentation (Angular)](https://www.webdatarocks.com/guide/documentation-angular/)
- [Documentation (React)](https://www.webdatarocks.com/guide/documentation-react/)
- [API Reference](https://www.webdatarocks.com/guide/api-reference/)
- [Documentation (JS)](https://www.webdatarocks.com/guide/webdatarocks-documentation/)