How do I set custom values for bins (automated segmentation for charts)?.

The concept of bins is to automate segmentation of data, especially for charting.

In practice once you have a basic chart structure identified, it is likely you will then want to have some direct control over the segmentation of data displayed

The starting point is the Edit Property dialogue (see this link)

  • You can edit each property by hovering over the gap just to the left of the data entry box, which brings up a cog symbol. 
  • Click the cog. This opens the Edit Property dialog
  •  If the "Type" is set to Number  you can choose options for Custom Bins.

Additional Advice

  • there is no specific limit on bins/"intervals", other than you cannot have more bins than the number of different values present for this property in the dataset
  • if there is no '0' in the list of custom bin settings (see the first two screenshots in this article) and as the minimum value in the dataset is '1', a bin of '<2' is generated
  • if you want sequential numbers to be shown, some of which have zero instances to display, the custom bins are likely to be explicitly "1,2,3,4,5,6,7,8" though note that if '8' is your top value, this will not appear unless the custom list is "1,2,3,4,5,6,7,8,9". In this instance consider selecting the 'Auto' option for bins (see the last bullet point below).
  • if the highest value in the bin setting is 7, but the next lowest range is one below, 6 (in fact, the range 5 - 6), so any value above 7 is shown as '>6'
  • if you set the highest bin setting as say 100, (so values shown are 2,3,5,7,100), then a range '7 - 99' will show: if you want a greater than symbol to show, the highest value in the dataset (say 9) must be greater than the highest bin setting (say 7)
  • if you want all values to appear (say when filtering), choose the Auto option and increase the number to the right of the auto selection button to the maximum possible (which will be the number of different values present in the dataset)

 

 

Have more questions? Submit a request

Comments