Tag Archives: histograms

Bins

9 Replies

Easy bin building:

– select a measure
– click on Show Me!
– pick the histogram

Tableau tries to create roughly 10 bins, adds a dimension for the bin to the dimensions list
can change bin size

Alternate for Bins (allows for reference lines on a histogram):

– Create a calculated field such as: INT([Sales]/100)*100-IIF([Sales]<0,100,0)
– Put Number of Records on Columns, calculated field on rows.
– Then can have calculated fields like: TOTAL(AVG([Sales])), TOTAL(MEDIAN([Sales])), etc.
– Will need to set Compute using to the calculated field.

Example here: https://www.tableausoftware.com/support/forum/topic/reference-line-over-distribution-graph

Some stuff on bins & blends (might need this to pull off getting the percentile)
http://reports4u.co.uk/2011/08/17/tableau-create-bins-from-a-measure-calculated-field-pt-2/
http://www.tableausoftware.com/support/forum/topic/creating-bin-dimension-aggregated-calculated-field
http://www.tableausoftware.com/support/forum/topic/aggregating-aggregate-histograms

From Joe Mako:

BYO Bin calc:

INT([Value]/[Bin Size])*[Bin Size]-IIF([Value]<0,[Bin Size],0)

Manually choosing the number of bins/binning a dimension by a measure:

http://kb.tableausoftware.com/articles/knowledgebase/numberofbins

[loop category=”wikicontent” tag=”bins,bin,histogram,histograms”]
[field title] – Added [field date]
[content]
[/loop]

Related posts:

    [loop tag=”bins,bin,histogram,histograms” exclude=”this” relation=”and” compare=”not” taxonomy=”category” value=”wikicontent”]

  • [field title-link][field thumbnail-link]

[/loop]