Blog

Visualize your MongoDB data with Pivot Table and Data Compressor

Our team continues to work hard on the component's performance optimization which has always been of great importance to our users and customers.

Therefore, in the light of a new 2.6 version of Flexmonster release, we are happy to inform you about the new significant feature - Compressor for JSON data source which will boost the performance of your project when loading the JSON data from MongoDB or other NoSQL Database into Flexmonster Pivot Table & Charts.

(more…)

Opening the black box of Heat Map Visualization

As the world becomes a more competitive place to live in and amounts of data are constantly increasing, it’s crucial to keep up with the newest trends in data visualization to convey its meaning and make it easier for a human brain to perceive.

Whereas tables and charts have to be interpreted and understood, a Heat Map tends to be a self-explanatory kind of visual storytelling. It embodies a 2D visualization with color as a 3rd dimension. You can visualize your data through variations in coloring which correspond to variance across multiple variables. (more…)

Top 3 ways to include Flexmonster into your project

Today I’m going to tell you about the options to include Flexmonster JavaScript library in your project. Among possible ways, you can choose the one that suits you best. Well, let’s start. (more…)

What Data Source to Choose to Boost Your Pivot’s Performance

Flexmonster Pivot Table & Charts allows you to work with a large volume of data. It was designed to render big data in a fast and robust way. All companies from small businesses up to worldwide enterprises can benefit greatly from using Flexmonster. Our component easily renders 1 million unique rows and works with OLAP data cubes, which are the unique features distinguishing our component from others.

The most important criteria for choosing the optimal data source setup for Flexmonster is the amount of data you have - your data volume. If you have some hesitations about which combination of the data source and Flexmonster will work the best for you - take a look at useful shortcuts we propose you below:

(more…)

NEW! 2.5 Release: load more data & visualize it faster

We’ve made great progress since our last summer release. This time we deeply worked on memory that component uses in a browser. You often have this question "How much data Flexmonster component can handle?". Being a client-side tool, it mostly depends on browser memory. Thus, we have been working on optimizing the component’s memory usage, especially when dealing with large amounts of data.

Today we are ready to show the changes we’ve made and how you can affect your business using the latest 2.5 version of Pivot Table & Charts component.

Let’s see: (more…)

On the Dark side of UI

We had this one frequent request from our clients that we’ve decided to fulfill. It’s not a secret that the dark UI trend that has started in the 2016 and still follows us in the design world.

We are not going to convince you to go to the dark side (are we?) but we have a lot of clients, who prefer dark style in their applications. So, for those who use it or are going to use it, we’ve made the predefined Dark Theme that you can use right now by adding just one line of code.

Before you do it, we want to show the look & feel:

(more…)

Tremendous memory performance optimization in Flexmonster

Usually, significant improvements happen in major releases. However, this time we would like to shed some light on the extraordinary improvement that was done by our developers during several minor releases this winter. We are talking about the tremendous reduction of browser’s memory consumption by our component. (more…)

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. (more…)

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 and JSON data sources. It shows the total sum of some value that changes as you add or subtract some values in the next row. (more…)

Pivot table based on the data from SQL databases: how to achieve the best performance

   This blog post will be especially interesting for those integrators who use SQL databases in their projects. Recently we have started getting more and more similar requests such as:

  1. “We use SQL DB and we want to reduce the time of data loading inside the component.”
  2. “We have a lot of rows in our SQL DB, but due to browsers restrictions we can’t load them all...”
  3. “We have several user roles in our system with different permissions and we want to show the data from our SQL DB according to the levels of access.”

At first sight, those three situations are different, but as you will see, they can be solved in the same way. (more…)

Connecting to SQL Databases: Fast data loading with updated Flexmonster Data Compressor for .NET, Java, PHP

If you are the one who has already used our Compressor, we have good news for you about important updates that our team recently implemented. And if you haven’t tried it yet, please read the information and don’t delay using it.

Whom it may concern:  All who works with relational data.

Flexmonster development team has updated Flexmonster Data Compressor - the special server-side compression tool that helps you to increase data loading speed from a server to customer’s browser and makes data loading notably faster. (more…)

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. (more…)