Blog

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 Component 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…)

Multidimensional vs Tabular SSAS models: we support both

When analyzing really large data sets, we use Microsoft SQL Server Analysis Services. OLAP cubes allow coping with much bigger data volumes than relational databases. However, lots of users claimed that multidimensional cubes were hard to understand, especially when designing the model.

That was one of the reasons why SSAS Tabular Model was introduced in 2012. (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…)

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…)

NEW! Flexmonster 2.4 version is released

You know, we have this passion for what we do. For each new release, our developers work on new improvements to make the product stand up to new trends and perspectives.

Flexmonster pivot is designed to be friendly for developers and we try to enrich the product with all required features for this. And of course, we care about the user experience our end-users have with our Pivot table.

So, this release is all about style: new handy user interface, the variety of built-in themes, new options to visualize data in the grid. (more…)

New 2.4 version feature: Welcome LESS and built-in themes

The feedback from our customers is a crucial source of improvements for Flexmonster team. We carefully collect the requests, analyze them and implement the most expected ones in our major releases.

In the 2.4 release, we decided to simplify the maintenance of CSS. (more…)