Documentation

Limit Result-Set

Limiting the result set displayed in a chart is sometimes necessary to create a clearer picture of the data and to get the insights you really need. In the Chart Creator, you can add customized parameters to your fields to constraint the results displayed. See the instructions below to learn how to limit your results and how to apply top and bottom filters to your charts in datapine.

 

Apply a condition

 

how to apply a condition to limit your data result set

 

  1. Open the Chart Creator and add the fields you wish to visualize to Measures & Dimensions. In the Field Editor on the right, choose an aggregation type for the input field. We’ve added the sum of profits to Measures and the product name to the X-Axis Dimension to get our products by profit per unit.
  2. We now want to display only the ‘Top 5 Products by Profit per Unit’. Therefore, click on the field in Measures on which you wish to apply the limitation of the result set. In our case it’s the ‘Profit’ field. The field editor on the right side of the screen will now be displayed.
  3. Click on Add Criteria to setup a new condition.
  4. Define whether you wish to apply your condition to the field values or to the aggregation of the field. As we want to see the ‘Top 5 Products by Profit per Unit’ we chose AVG(Profit).
  5. Setup the conditional rule. First select the limitation function from the dropdown menu and then enter the thresholds you wish to apply. We’ve selected Top # and added the threshold 5.
  6. Apply the new condition to your chart.

You may add more than one condition to your metrics. Just click on Add Criteria to add more conditions to your fields.

To delete a criteria, just click on the small delete icon in the right upper corner of the condition and then apply it to your chart.

 

 

Operators

 

The standard operators for field values and for aggregated values include:

 

Btw                     

Choose this option to display a defined range of values.

 

=

Choose this option to display all data equal to a defined value.

 

!=                           

Choose this option to display all data excluding the defined value.

 

<

Choose this option to display all data less to a threshold.

 

<=

Choose this option to display all data less or equal to a threshold.

 

Choose this option to display all data larger than your threshold.

 

>=

Choose this option to display all data greater or equal to your threshold.

 

If you have chosen to apply the condition to the field’s values you will have these additional options:

 

Is NULL

Choose this option to only display empty values.

 

Not NULL

Choose this option to exclude empty values.

 

For aggregations such as count, sum, average or distinct count you will have the following additional functions:

 

Top #

Choose this option to display a number of results in Top Range.

 

Bottom #

Choose this option to display a number of results in Bottom Range.

 

Top %

Choose this option to display your data in Top Range for a given percentage of the total.

 

Bottom %            

Choose this option to display your data in Bottom Range for a given percentage of the total.