Jump to content
  • Spotfire Tips & Tricks: Histograms made easy with Spotfire Data Panel


    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.  Spotfire provides quick and easy method to create Histograms, which are common first step for planners and analysts to present information in a compact and organized manner.

     

    Quick Histogram

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

     

    histogram_0.thumb.png.d73755f8f05761764aec06fba540b103.png

    Empty Value Replacement

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

     

    empty_value_replacement.thumb.png.277d7cc4ab06e187812f14eff99df265.png

    Data Type and Formatting updates

    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.

     

    datatypeformatting.thumb.png.61e7179451d35403926513c399db5972.png

    Custom Bins

    For the histogram, bins are equal in size by default. You can select a slider to select a number of bins, which are 20 as per the 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 case of string values. This new Binned column can be used like any other data column.

     

    binning.thumb.png.1dc0ef0b911abe91c5652b685896e81f.png

    You can learn more about Histograms here.


    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...