Histogram Widget
*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
Download: Histogram Widget
Version: 1.93
Introduction
This article explains how to install and configure the Histogram widget as seen below.
A Histogram is a plot plot that lets you discover, and show, the underlying frequency distribution (shape) of a set of continuous data. This allows the inspection of the data for its underlying distribution, outliers, skewness, etc.
Purpose/Benefits
This widget will allow users to create a graphical display where the data is grouped into ranges/bins (such as "40 to 49", "50 to 59", etc), and then plotted as bars. Similar to a Bar Graph, but in a Histogram each bar is for a range of data. The widget will allow the user to control the number of bins, and will automatically calculate the size of each bin accordingly.
How to Install and Configure the plugin
Step 1 - Add The Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server. Now, when you create a new widget the "Histogram Plugin" should show up in the list of options.
Step 2 - Create the "Histogram Plugin" Widget
On your dashboard, click the Create Widget button and select Advanced Configuration. Next, select the "Histogram Plugin" from the drop down list. For this you will need to specify the Categories (optional) and a Value fields (required). For the below example, we have added the following: Categories from "Driver Name" field, and "Value" from the "Miles" field, and changed the number of bins to 10.
As a result, the above Histogram will display the number of Drivers for each Mile group.
The widget also offers the following design options:
1. Binning Method:
- Automatic - sers enter the number of bin by moving the slider, value ranges between 1 - 20, and bin size is calculated automatically
-
Manual - users type in the bins in the text field seperated by a comma. example: 10,40,-20,30,70,-10,85. the values don't have to be in order, the widget will sort them automatically. See below example:
2. Labels - will allow users to display the number of occurrences above each bin as a value or as percent
3. Bar Border - toggle on/off of drawing a border around each Bin
4. Gradient Fill - toggle on/off using gradient fill affect to color each bin
5. Bar Width - this is only valid for Manual binning and control the width of each bin. This can be using the size of the bin , or evenly distributed
6. Bar Bin Precision- this parameter will allow to control the precision when calculating bin size. This will accommodation for dataset where the distribution number are in small increments
References/Notes
- There is no support for custom formulas within the Value field (any complex formulas should be contracted on the Elasticube level)
- There widget doesn't provide the ability to select/filter on a specific bin (or bar)
- If only the Value field is select, then the Histogram widget will count the number of "Values" that falls within each group range
- If Manual binning is selected having a widget filter using the same field in the Value parameter will have no effect
Release Notes
- 5-Jan-2017 - Initial release
- 6-Jan-2017 - Fix CSS elements within the widget that interfered with the other dashboard widgets
- 9-Jan-2017 - handle the rendering case where there is a widget filter that limits the range of the Value field
- 11-Jan-2017 - rotate the X-Axis label so it displays nicely when the values are in the thousands. Also automatically hide the X-Axis labels and bars labels when chart is minimized below threshold
- 01-31-2017 - fix the label formatting issue where value label were not created when formatter object was missing
- 02-07-2017 - fix issue where widget filter were affecting all other Histogram widget filters
- 02-07-2017 - fix issue where the labels are not centered when bin count is over 10
- 2-10-2017 - Label formatting was done on the bins value instead of the X Axis values. It is now fixed
- 2-24-2017 - Adjust the y Axis spacing from the left edge to give it enough space for large values
- 04-05-2017
- Fix the issue where negative values did not show up in the X-Axis
- Added the option to draw a border around each bar
- Added the option to set Gradient Bar fill
- Add the ability to setup the bins manually
- Add the ability to control the Bin width either based on size of bin or
evenly distribute - 04-06-2017
- Add the ability to set the precision for bin size to accommodate for a data-set where the number are distributed // in small increments - 02-21-2018 - update styler controls to work with 7.x
- 09-13-2018 - Fix JAQL API endpoint when running under version 7.2
-
Hi Ronen,
we have been experiencing some issues with Sisense histogram plugin.
1) When applying a filter for a specific widget, i get this filter applied to all other widgets as well.
For example, i have two metrics: delivery time and time_at_restaurant.
In histogram i want to delivery_time to be limited 0 to 180 and time_at_restaurant 0 to 40, when i change filter within one widget it's applied to other as well.
Sometimes filters seem to work properly but many times they are applied wrongly.2) Also, filters seem not to work within one widget sometimes. Please see the picture below.
3) If you select to show values in the design part it doesn't show anything, please see picture below
Would be great if you can help with this asap.
thanks! -
Hi Altynai,
Sorry that you have had some issue.
The show label value issue is now fixed and you can download the latest version from the link above.
Regarding the filtering issue, we would need to better understand the behavior first. Could you work with our support and show them this behavior first and then I will have a follow up with them to get a better understanding of the issue.
Thanks,
Ronen
-
Hi,
the filtering issue seems to be solved - thanks a lot!
the 'values' mode still has an issue though - it always shows 0 on y axis,
There are couple of more functionalities we'd like to have:
- possibility of choosing breaks we want (not number of breaks but manual input, e.g., -inf, 20,25,30,35,45,60,+inf)
- possibility of grouping by another variable
would it be possible to fix/add those?
thanks,
Altynai -
Hi Sisense gang,
What's going wrong with this histogram?
Is it possible to edit the widget script to user-define bins? Is it possible to do this in the elasticube?
Any help much appreciated!
EDIT - is there something else dodgy about this widget? Other widgets on this dash are no longer representing correct data... nothing else changed except installing the histo plugin.
SECOND EDIT - ok something really strange is going on - data in the elasticube has changed. The column I was using for the values in the histogram has been entirely set to 0 in the ecube. Fixed by rebuilding entire ecube...
-
Hi Rachel,
Sorry that you are facing some issue with the widget. We are working on a new version to allow input of user defined bins, and also some minor bug fixes.
Would it be possible for you to send the ECData file and .Dash file to our support and ask them to forward it to me so I can take a look at the issue.
Thanks,
Ronen
-
Thank you for your reply Ronen. Have uninstalled the plugin and started from scratch with a new dash following unexpected behaviour, so I can't send over the original unfortunately.
Re-installed the histo plugin and restarted, but seem to be unable to replicate - the widget doesn't work at all now, tried on several ecubes but get "no results" every time.
But good news about the development :)
-
Histogram Widget (Version 1.9) with support for Manual Binning is released!
This release introduces the following features and bug fixes:
1.Add the ability to setup the bins Manually
2. Fix the issue where negative values did not show up in the X-Axis
3. Added the option to draw a border around each bar
4. Added the option to set Gradient Bar fill
5. Add the ability to control the Bin width, when entering bins manually, either based on size of bin or evenly distributeEnjoy,
Ronen
-
is it possible to adjust bars to lines, we are looking for histogram with smooth curves.
Core Changes:
- There will be a “break by”, allowing the user to break the Histogram into multiple Histograms based on a particular column.
- Each Histogram will render as a smoothed curve instead of a traditional Histogram.
- The Y-value of each bar on the X axis will determine the location of the curve.
Desired Changes:
- There will be the option to add dashed vertical lines, each based on an individual aggregate function. The dashed lines will not vary based on their Y-value, and instead will have one global X-value for the entire chart.
- There will be some kind of “chart smoothing” option in order to produce normal curves with a single peak.
-
There is an issue with this plugin where dashboard filters that are disabled within the widget still affect it. In other words, it doesn't ignore filters after disabling them, hence results in having "No results" on it. I have a filter from a completely different table from which the histogram is being built. This filter is disabled within the histogram and it is still taken into account.
-
Although general functionality is fine (it basically does what a histogram should) we also managed to find one bug.
In order for the bug to occur following two conditions need to be met simultaneously:
- Widget binning method set to automatic
- Dashboard filters set the way to filter out all records (in example date scope set to future)
Here, normally one would expect from a widget to inform about the fact that no record match selected criteria, while tested histogram behaves as if there were no filters chosen at all. It presents data calculated for full, not filtered data set. This might be a bit confusing.
-
Hi,
I have this metric 'Age of Uncleared Payment' which is calculated as follows:
Age of Uncleared Payment= NOW()-TransactionProcessingDate
For pivot table, the above formula in values section works well and I can see all the values of metrics.
For histogram plugin, the above formula in values section does not generate any histogram.
Could you please look into this?
-
I observed on the Dynamic bucket plugin a grey area on how boundaries between bins are counted.
should 0 to 10 include 10 or any value <10? On the final bin it should include the max value?
What I think I see is that it is double counting on the boundaries e.gr 0 to 10 including 10 then 10 to 20 including 10 again... Is this my imagination.
It certainly does not align with the Dynamic Buckets plugin.
Please sign in to leave a comment.
Comments
17 comments