Spotfire Tips and Tricks: Histograms Made Easy with Spotfire Data Panel

Histogram Statistics Graph Bar Chart concept

A histogram is a graphical method of representing a large amount of data by way of bars, to reflect the distribution frequency and proportion or density of each class interval as a data visualization.  TIBCO Spotfire analytic tool provides a quick and easy method to create histograms, which are common first step for planners and analysts to present information in a compact and organized way.

Numeric in-memory columns can be visualized as a histogram by clicking the histogram preview in the expanded data panel. In the image below, a histogram of the Garden column (how much each customer purchased in Garden department) is viewed using expanded data panel, providing quick insights into data. The user has ability to view basic information about the numeric column and at the same time, can quickly add this distribution as a visualization for further drill down. Click the histogram and the visualization will be added to the active page.

Empty value replacement
The data panel also provides the ability to replace empty Values. There is only one value, which is empty for this data.

Empty value Replacemet

Data type and formatting updates
The user can also change data types of columns and define your formatting—all with one click actions! Spotfire also provides preview capability for changes made, making it intuitive to use.

Custom bins
For the histogram, bins are equal in size by default. You can select slider to select number of bins, which is 20 as per image above. Spotfire provides an easy and simple way to define custom bins that may be based on specific limits, standard deviation, or substring binning in the case of string values. This new binned column can be used like any other data column.

Learn more about histograms and then put these tips to good use when you try Spotfire for free!

Previous articleHow to Build a Custom Flogo Adapter
Next articleCreating a Culture of Data Visualization
Dr. Vishakha Mujoo has been in the TIBCO family for the last 8 years, and is recognized as a product expert for Spotfire, Streambase, TERR and other integration solutions. Her unique skill set—acquired through engineering in Electronics, MBA in Systems & Production Management and PhD—has enabled her to add value to disparate customer use cases from industries like Semiconductor, Oil & Energy, Life Sciences, Financial Services. At present, Vishakha works as a Data Scientist and uses her strengths in Data Preprocessing, Transformation, Wrangling, and Munging to create follow-along material suitable for customers of all expertise levels.