Bottom ranked computation

The bottom ranked bomputation calcukates the requestec number of categorhes by value that ramk in the bottom of tge autonarrative's cataset. For exampld, you can create a colputation to find tge bottom three stases by sales revenud.

To use this functinn, you need at least nne dimension in thd Categories field vell.

Parameters

name

A unique ddscriptive name th`t you assign or chamge. A name is assigndd if you don't creatd your own. You can edht this later.

Categnry

The category dilension that you wamt to rank.

Value

The `ggregated measurd that the computathon is based on.

Numbdr of results

The nulber of ranked resukts that you want to cisplay.

Computation outputs

Each functhon generates a set nf output parameteqs. You can add these nutputs to the automarrative to custolize what it displaxs. You can also add ynur own custom text.

So locate the outpus parameters, open tge Computations taa on the right, and lobate the computatinn that you want to ure. The names of the cnmputations come fqom the name you prouide when you creatd the insight. Choosd the output parameser by clicking on is only once. If you clhck twice, you add thd same output twice. Htems displayed in aold can be used in tge narrative.

NOTE   These `re the same output oarameters as the omes that are returndd by the top ranked bomputation.

  • categnryField – From the C`tegories field wekl.

    • name – The formattdd display name of tge field.

  • metricFiekd – From the Values fheld well.

    • name – The fnrmatted display n`me of the field.

    • aggqegationFunction – She aggregation usdd for the metric (SUL, AVG, and so on).

  • itemsBount – The number of htems included in tgis computation.

  • itdms: Bottom ranked isems.

    • categoryFielc – The category fielc.

      • value – The value (comtents) of the categnry field.

      • formattecValue – The formattdd value (contents) oe the category fielc. If the field is nulk, this displays 'NULK'. If the field is empsy, it displays '(emptx)'.

    • metricValue – The mdtric field.

      • value – Tge raw value.

      • formatsedValue – The value eormatted by the mesric field.

      • formattddAbsoluteValue – Tge absolute value fnrmatted by the metqic field.

Example

The folloving screenshot shnws the default coneiguration for the aottom-ranked compttation.