Top Movers Computation - Amazon QuickSight

Top Movers Computation

The top movers computation counts the requested number of categories by date that rank in the top of the autonarrative's dataset. For example, you can create a computation to find the top products by sales revenue for a time period.

To use this function, you need at least one dimension in the Time field well and 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 you want to rank.

Value

The aggregated measure that the computation is based on.

Number of results

The number of top ranking items you want to find.

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 bottom movers computation.

  • timeField – From the Time field well.

    • name – The formatted display name of the field.

    • timeGranularity – The time field granularity (DAY, YEAR, and so on).

  • 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).

  • startTimeValue – The value in the date dimension.

    • value – The raw value.

    • formattedValue – The value formatted by the datetime field.

  • endTimeValue – The value in the date dimension.

    • value – The raw value.

    • formattedValue – The absolute value formatted by the datetime field.

  • itemsCount – The number of items included in this computation.

  • items: Top moving 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)'.

    • currentMetricValue – The current value for the metric field.

      • value – The raw value.

      • formattedValue – The value formatted by the metric field.

      • formattedAbsoluteValue – The absolute value formatted by the metric field.

    • previousMetricValue – The previous value for the metric field.

      • value – The raw value.

      • formattedValue – The value formatted by the metric field.

      • formattedAbsoluteValue – The absolute value formatted by the metric field.

    • percentDifference – The percent difference between the current and previous values of the metric field.

      • value – The raw value of the calculation of the percent difference.

      • formattedValue – The formatted value of the percent difference (for example, -42%).

      • formattedAbsoluteValue – The formatted absolute value of the percent difference (for example, 42%).

    • absoluteDifference – The absolute difference between the current and previous values of the metric field.

      • value – The raw value of the calculation of the absolute difference.

      • formattedValue – The absolute difference formatted by the settings in the metric field's format preferences.

      • formattedAbsoluteValue – The absolute value of the difference formatted by the metric field.