Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.
To find a feature or item, use the Quick search bar.
For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight
Bottom ranked computation
The bottom ranked computation calculates the requested number of categories by value that rank in the bottom of the autonarrative's dataset. For example, you can create a computation to find the bottom three states by sales revenue.
To use this function, you need at least one dimension in the Categories field well.
Parameters
- name
-
A unique descriptive name that you assign or change. A name is assigned if you don't create your own. You can edit this later.
- Category
-
The category dimension that you want to rank.
- Value
-
The aggregated measure that the computation is based on.
- Number of results
-
The number of ranked results that you want to display.
Computation outputs
Each function generates a set of output parameters. You can add these outputs to the autonarrative to customize what it displays. You can also add your own custom text.
To locate the output parameters, open the Computations tab on the right, and locate the computation that you want to use. The names of the computations come from the name you provide when you create the insight. Choose the output parameter by clicking on it only once. If you click twice, you add the same output twice. Items displayed in bold can be used in the narrative.
Note
These are the same output parameters as the ones that are returned by the top ranked computation.
-
categoryField– From the Categories field well.-
name– The formatted display name of the field.
-
-
metricField– From the Values field well.-
name– The formatted display name of the field. -
aggregationFunction– The aggregation used for the metric (SUM, AVG, and so on).
-
-
itemsCount– The number of items included in this computation. -
items: Bottom ranked items.-
categoryField– The category field.value– The value (contents) of the category field.formattedValue– The formatted value (contents) of the category field. If the field is null, this displays 'NULL'. If the field is empty, it displays '(empty)'.
-
metricValue– The metric field.value– The raw value.formattedValue– The value formatted by the metric field.formattedAbsoluteValue– The absolute value formatted by the metric field.
-
Example
The following screenshot shows the default configuration for the bottom-ranked computation.
