Page Comparison

...

Definition:
A Tableau Bin is way to group data (dimension) by incremental values of a numeric field (measure)

Ranking product sales by Qty Sold in selected multiples

The question: What multiples of qty sold generates the most sales for an item?

...

In the example above the highest selling item is CONBABY2.
The 1st highest selling qty multiple is in the 270 to 279 Qty Sold (bin) group.
The 2nd highest selling qty multiple is in the 780 to 790 Qty Sold (bin) group.
CONCLUSION: Check that you keep enough QOH so you can fulfill those sales.

Sales by Bin Qty with QOH example

Using the Tableau data blending feature, add the IN_OnHandToday data source and show the current QOH
02a Bins: Item Qty Sold BIN with QOH - DataSelf Analytics

...

Sales by Bin Qty as a Chart example

Sometimes a graphical representation is more meaningful to show patterns or differences.
See an example at 02a Bins: Item Qty Sold BIN Chart - DataSelf Analytics

...

Sales by Bin Qty Dashboard showing both table and chart example

Sometimes it is beneficial to show both the table & graphical views together like this example,
02a Bins: Item Qty Sold Bins Dashboard - DataSelf Analytics

...

Comparing sales by multiyear groups (bins)

You already know how to group sales by year and use table calculations to show the % difference between years. But how do you show the differences between 5-year increments? Using bins you can group in multi-year increments. See the example at 02a Bins: Sales by Year Bins1 - DataSelf Analytics

...

1. Create a calculated field for YEAR([Invoice Date])

2. Right click on the calculated field and create Bin

   

3. Enter the Bin Size to group years. In this example the Invoice Year is being grouped (binned) in 5-year multiples

   Image Modified

4. Here is an example of using a parameter to set the year bin size:
   02a Bins: Sales by Year Bins2 - DataSelf Analytics
   

Looking at past sales from Today in 30-day bin groups

With bins you can look at sales history relative to today in multi-day increments. With a parameter, you choose the increment. See an example at 02a Bins: Rolling Parameter Days Sales Bins Tabular - DataSelf Analytics

1. Create a calculated field showing the invoice date relative to number of days from today.

   

2. Create a bin based on the DateDiff calculated field. Set the bin size to your choice

   Image RemovedImage Added

3. To make the bin size customizable, create a parameter to control bin size.

4. If you want more detail on the date groups of each bin, create calculated fields for MIN([Invoice Date]) & MAX([Invoice Date]) and add them to the Rows section.
   

   

5. To see the difference in the sales amount between bin groups, create a table calculation for % Difference from previous row as shown in the example above.
   

6. These are examples of displaying the data graphically to show the difference more effectively
   In the first two views, the DateDiff (bin) is the Column Footer. The DateMin can show as a ToolTip or a Label.
   02a Bins: Rolling Days Sales Bins Bar Chart Asc - DataSelf Analytics,
   02a Bins: Rolling Days Sales Bins Bar Chart Desc - DataSelf Analytics
   
   In the following two views, DateDiff (bin) is marked as a color to provide the grouping. DateMin is the Column Footer
   02a Bins: Rolling Days Sales Bins Bar Chart Asc 2 - DataSelf Analytics
   02a Bins: Rolling 30 Day Sales Bins Line Chart - DataSelf Analytics
   

...