Need a special offer?Find out if your project fits.
+

Reporting

Learn how to make web reporting your strong side with Flexmonster Pivot Table & Charts tool.

The art of collecting, cleaning and storing small data. Part 1.

In our last blog, we presented a . Among all data categories from internal and external sources, human generated data may be crucial for a company. Also, even in the era of Big Data spreadsheets are still very commonly used in small companies and corporations. In other words, there are millions of people collecting and working with the small data type of data which can be easily fitted in an Excel spreadsheet.

USEFUL: Add running totals to enhance web reporting

In today’s blog post I want to tell you how to get more from Flexmonster pivot with the help of running totals.

To begin with, I’ll tell you what is it - running totals. This is one of the aggregations available for CSV, JSON, FDS databases, MongoDB, MS Analysis Services, and even custom data source APIs. It shows the total sum of some value that changes as you add or subtract some values in the next row.

Grid customization and styling beyond CSS

The look and feel of the component can be fully customized by means of CSS. It refers to colors, borders, buttons, pop-ups, and grid cells. But there are cases when just CSS is not enough for pivot table report. For example, when you want to represent the numbers in cells by pictograms showing how ‘good’ or ‘bad’ these numbers are. Another inquiry, you need to highlight the segment of the table representing sales in Canada. In yet another case, it is required for several report cells to contain hyperlinks to some external data. If you would like to style up entire columns, rows or specific cells based on the data nature, Flexmonster component can suggest you customizeCell function to achieve these goals.

Update data in run time

Flexmonster pivot table component is a convenient tool for data analysis and visualization. It offers fast pivot grid control, built-in pivot charts, integration with 3rd party charting libraries. Moreover, the application can have more than one instance of the component. That allows creating a dashboard view with different charts and tables.

Pivot Table – The Cornerstone of Data Analysis

As you might have noticed, we often refer to Flexmonster as a pivot table. But what does that term exactly mean? How do pivot tables function and what can you actually do with them? Let us get back to the basics of pivot tables and find out.

Pivot table is a data processing tool, a two-dimensional table used to summarize, explore, and present large amounts of data.

Manage time zones easily in your application

This blog post tells about the most popular date- and time-related issues our clients reported while analyzing data from databases, CSV, or JSON. We are happy to suggest a new simple approach which helps to manage time zones effectively.