Create, edit, and delete bins—ICRW

Bins enable you to associate multiple dimension attribute values into groups. This ability makes bins similar to groups. For example, within a Product Name column you could group products into categories using bins. For example, you might create bins for Computer, Household, and Automotive products.

Subscription Interactive Custom Report Writer

Platform Services

Regional availability

All regions
User type Interactive Custom Report Writer: Business, Project Manager
Permissions

Interactive Custom Report Writer: Run, List, View, Add, Edit, Delete

Platform Services: Run, List, View, Add, Edit, Delete

About Bins

Bins let you group a set of data from a larger data set to create a limited data set within columns. Bins allow you to group multiple values into smaller groups, providing the ability to create a report-within-a-report, such as including subtotals. You can create multiple bins for each column in the report.

For example, suppose you created a report that contains product names, orders, and sales for the products. You could create a bin that contains only computer products. You could then create a second bin that contains everything else. The resulting report is divided into two groups instead of individual products.

When data is in a bin, the system automatically aggregates the data within the specified groups.

Create a bin

  1. Open an ICRW report to Edit.
  2. On the Define tab, select (or add) the column you want to use to create a bin.
  3. Select A downward facing arrow tip to indicate a series of options that can be viewed by selecting the arrow to exapand the list.to expand the list and select Edit formula.
  4. In the Edit Column Formula page, open the Bins tab, scroll to the bottom of the page, and select Add Bin.
  5. Enter a value for the operator to use to determine members of the bin.
  6. Select values for to determine the bin members.
    For example, you might choose the operator "Is greater than" and then enter a value of "100,000." For non-numeric columns, select all the records to include.
  7. Optional: Select Add more options to add other variables to the formula.
  8. To ensure that no one modifies the filter, select Lock filter, then choose OK.
  9. Enter a Bin name and optionally, enable Treat result as a numeric value or expression to add additional syntax.
  10. Select OK.

The formula area shows the CASE statements that were generated based on your selections.

Edit a bin

  1. On the Define tab, select (or add) the column containing the bin.
  2. Select A downward facing arrow tip to indicate a series of options that can be viewed by selecting the arrow to expand the list. to open the Options dialog box and select Edit formula.
  3. On the Edit Column Formula page, tab to Bins and select Select this icon to edit the bin. to modify the bin.
  4. Optionally, to change a bin name, select Select this icon to change the name of a bin..
  5. Make the necessary changes and select OK.

Delete a bin

  1. On the Define tab, select (or add) the column containing the bin.
  2. Select A downward facing arrow tip to indicate a series of options that can be viewed by selecting the arrow to expand the list. to open the Options dialog box, and select Edit formula.
  3. On the Edit Column Formula page, tab to Bins and select the An X sign used in prompts, columns, filters, and selection steps to delete a selected object. beside the bin name.
  4. Optionally, to clear all the bins for that column, select Clear All.
  5. Select Yes to save the information in the column formula, or No to delete the information entirely.
  6. Select OK.