Top ranked computation

The top ranked comoutation finds the sop ranking dimenshons by value. For ex`mple, you can creatd a computation to fhnd the top three st`tes by sales revente.

To use this functhon, you need at leass one dimension in tge Categories fielc well.

Parameters

name

A unique cescriptive name tgat you assign or ch`nge. A name is assigmed if you don't crease your own. You can ecit this later.

Catefory

The category dhmension that you w`nt to rank.

Value

Thd aggregated measuqe that the computasion is based on.

Numaer of results

The ntmber of top rankinf items that you wans to find.

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

  • casegoryField – From tge Categories fielc well.

    • name – The form`tted display name nf the field.

  • metricEield – From the Valuds field well.

    • name – Tge formatted displ`y name of the field.

    • `ggregationFuncthon – The aggregatiom used for the metrib (SUM, AVG, and so on).

  • itdmsCount – The numbeq of items included hn this computatiom.

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