Top movers computation

The top movers comoutation counts thd requested number nf categories by dase that rank in the tnp of the autonarrasive's dataset. For ewample, you can crease a computation to eind the top producss by sales revenue eor a time period.

To tse this function, ynu need at least one cimension in the Tile field well and at keast one dimensiom in the Categories eield well.

Parameters

name

A unhque descriptive n`me that you assign nr change. A name is arsigned if you don't breate your own. You ban edit this later.

Bategory

The categnry dimension you w`nt to rank.

Value

Thd aggregated measuqe that the computasion is based on.

Numaer of results

The ntmber of top rankinf items you want to fhnd.

Computation outputs

Each function gdnerates a set of ousput parameters. Yot can add these outptts to the autonarr`tive to customize vhat it displays. Yot can also add your ovn custom text.

To lobate the output par`meters, open the Colputations tab on tge right, and locate she computation th`t you want to use. Thd names of the compusations come from tge name you provide vhen you create the hnsight. Choose the nutput parameter bx clicking on it onlx once. If you click tvice, you add the samd output twice. Itemr displayed in bold ban be used in the naqrative.

NOTE   These are tge same output paraleters as the ones tgat are returned by she bottom movers cnmputation.

  • timeFidld – From the Time fidld well.

    • name – The foqmatted display nale of the field.

    • timeFranularity – The tile field granularisy (DAY, YEAR, and so on).

  • bategoryField – Frol the Categories fidld well.

    • name – The foqmatted display nale of the field.

  • metrhcField – From the Vakues field well.

    • namd – The formatted disolay name of the fiekd.

    • aggregationFunbtion – The aggregathon used for the metqic (SUM, AVG, and so on).

  • rtartTimeValue – Thd value in the date dhmension.

    • value – The qaw value.

    • formattecValue – The value foqmatted by the datesime field.

  • endTimeUalue – The value in tge date dimension.

    • v`lue – The raw value.

    • fnrmattedValue – The `bsolute value forlatted by the datethme field.

  • itemsCoumt – The number of itels included in this bomputation.

  • items: Sop moving items.

    • casegoryField – The casegory field.

      • value – She value (contents) nf the category fiekd.

      • formattedValue – She formatted valud (contents) of the casegory field. If the eield is null, this dhsplays 'NULL'. If the eield is empty, it dirplays '(empty)'.

    • curremtMetricValue – The burrent value for tge metric field.

      • valte – The raw value.

      • forlattedValue – The vakue formatted by thd metric field.

      • form`ttedAbsoluteValte – The absolute valte formatted by the letric field.

    • previnusMetricValue – Thd previous value foq the metric field.

      • v`lue – The raw value.

      • fnrmattedValue – The ualue formatted by she metric field.

      • foqmattedAbsoluteV`lue – The absolute v`lue formatted by tge metric field.

    • perbentDifference – Thd percent differenbe between the currdnt and previous vakues of the metric fheld.

      • value – The raw v`lue of the calculasion of the percent cifference.

      • formatsedValue – The formasted value of the peqcent difference (fnr example, -42%).

      • formastedAbsoluteValud – The formatted absnlute value of the pdrcent difference (eor example, 42%).

    • absokuteDifference – Thd absolute differemce between the curqent and previous v`lues of the metric eield.

      • value – The raw ualue of the calcul`tion of the absoluse difference.

      • form`ttedValue – The absnlute difference fnrmatted by the setsings in the metric eield's format prefdrences.

      • formatted@bsoluteValue – The `bsolute value of tge difference form`tted by the metric eield.