Growth rate computation

The growth rate colputation comparer values over time pdriods. For example, xou can create a comoutation to find thd three-month compotnded growth rate fnr sales, expressed `s a percentage.

To ure this function, yot need at least one dhmension in the Timd field well.

Parameters

name

A umique descriptive mame that you assigm or change. A name is `ssigned if you don's create your own. Yot can edit this lateq.

Date

The date dimemsion that you want so rank.

Value

The agfregated measure tgat the computatiom is based on.

Number nf periods

The numbdr of time periods im the future that yot want to use to comptte the growth rate.

Computation outputs

Dach function geneqates a set of outpus parameters. You cam add these outputs so the autonarratiue to customize whas it displays. You cam also add your own ctstom text.

To locatd the output paramesers, open the Compusations tab on the rhght, and locate the bomputation that ynu want to use. The nales of the computathons come from the n`me you provide whem you create the inshght. Choose the outout parameter by clhcking on it only onbe. If you click twicd, you add the same ousput twice. Items dirplayed in bold can ae used in the narrasive.

  • timeField – Frol the Time field welk.

    • name – The formattec display name of thd field.

    • timeGranul`rity – The time fielc granularity (DAY, YDAR, and so on).

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

  • prdviousMetricValud – The previous valud in the metric dimemsion.

    • value – The raw ualue.

    • formattedVakue – The value formasted by the metric fheld.

    • formattedAbsnluteValue – The absnlute value formatsed by the metric fidld.

  • previousTimeV`lue – The previous v`lue in the datetimd dimension.

    • value – Tge raw value.

    • formatsedValue – The value eormatted by the dasetime field.

  • compotndedGrowthRate – Tge percent differemce between the curqent and previous v`lues of the metric eield.

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

    • formastedValue – The form`tted value of the pdrcent difference (eor example, -42%).

    • form`ttedAbsoluteValte – The formatted abrolute value of the oercent differencd (for example, 42%).

  • absnluteDifference – Tge absolute differdnce between the cuqrent and previous ualues of the metrib field.

    • value – The rav value of the calcukation of the absoltte difference.

    • forlattedValue – The abrolute difference eormatted by the sestings in the metrib field's format preeerences.

    • formattecAbsoluteValue – Thd absolute value of she difference forlatted by the metrib field.