The pivot chart control is a lightweight control that reads OLAP and relational data, and visualizes it in graphical format with the ability to drill up and down.
There is extensive support to bind both OLAP and relational data sources.
Our pivot chart control is supported in all major browsers in use today, including:
Pivot chart control has built-in support for drilling in or out to visualize multidimensional and relational data. Allowing this to be driven by the context menu makes it intuitive to the user.
Pivot chart supports common chart types, including column, stacking column, bar, stacking bar, area, step area, spline area, stacking area, pie, pyramid, line, step line, and spline.
Pivot chart control can display user-defined dimensions and measures through OLAP report to define and add dimensions and measures. The calculated members are classified into two types:
A named set is a multidimensional expression (MDX) that returns a set of dimension members, which can be defined and saved as a part of the cube definition. Named sets are created by combining cube data, arithmetic operators, numbers, and functions. Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.
A color code helps to differentiate between chart items. The legend has labels beside each color to present some detail about the series.
Marker is a symbolic representation of points in the pivot chart. Crosshair will return the exact data for the X and Y coordinates under the pointer.
Pivot chart provides options to display chart series information for measures, row and column member names, and values of a current segment while hovering over each series.
Pivot chart can be exported to the formats listed below.
Localization is the process of customizing the user interface (UI) based on the local culture setting. Using this feature, data can be displayed in a specific language.
Pivot chart supports 12 different types of predefined themes, allowing users to switch among them to view the controls in different formats. Supported themes are flat-azure, flat-azure-dark, flat-lime, flat-lime-dark, flat-saffron, flat-saffron-dark, gradient-azure, gradient-azure-dark, gradient-lime, gradient-lime-dark, gradient-saffron, and gradient-saffron-dark.
Responsive layout is aimed at crafting sites to provide an optimal viewing experience and easy reading. It also provides navigation with a minimum of resizing, panning, and scrolling across a wide range of devices from tablet to desktop. By using this feature, you can achieve an effective view of the pivot chart in all devices including desktops, tablets, mobiles, etc.
Angular binding provides structural Framework for dynamic web apps. It lets you use HTML as your template language and lets you extend HTML’s syntax to express your application’s components clearly and succinctly.
A Knockout binding system provides a concise and powerful way to link data to the UI. It’s generally easy and obvious to bind to simple data properties.