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.

Boost Your Flexmonster Experience with Update Data API Call

There are tons of features you can combine in Flexmonster to reach the pivot table functionality you need. On our YouTube channel, we have started a series of videos called “Tips & Tricks” where we share different interesting approaches to maximize your Flexmonster experience.

The last video, Live data refresh/update hack, explains the details of updateData() API call usage. In this blog post, we will delve into the topic and see how it works from the inside.

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.

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. Imagine a list of numbers. A running total keeps track of the sum of these numbers as you go down the list, adding each new number and subtracting any that are removed.

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

In our last blog, we presented a data definition framework. 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.

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.