Learn how to make web reporting your strong side with Flexmonster Pivot Table & Charts tool.
Previously we listed few useful tips on . Data cleaning is what typically goes next. Thus, today we are going to emphasise four crucial ideas which can help you save valuable time, avoid headaches and conduct qualitative data analysis.
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.
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.
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.
We always try to expand our documentation and add some useful articles for our customers. We also provide an option for you how to make the process of maintaining Flexmonster in your applications easier.
Powerful Business Intelligence (BI) capabilities are a great competitive advantage for almost any company.
The problem is that there is often a long and challenging road between wanting an effective BI platform and having an effective BI platform.
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.
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.
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.
