# Absolute and percentage change aggregations For measures, you can set *Absolute change, Percentage change, Marketshare absolute change and Marketshare percentage change* aggregations. ### **Absolute change** The **Absolute Change** calculates the exact increase or decrease between two data points. This is essential for identifying trends, shifts, and changes in your data over time.

* **Dimension:** Select the dimension that the absolute change will be calculated over. * **Value 1 and Value 2:** Specify the two points between which the absolute change will be calculated. They define the scope of the comparison. * **Calculation formula:** *measure @Value 1 - measure @Value 2*. This represents the subtraction of one measure's value from another, showing the net change. * Click on **Create** to apply the absolute change aggregation to the selected measure. ### **Percentage change** The fields for the calculating percentage change is the same as that of the absolute change. However, the formula is different because it provides the change as a proportion of the initial value, which is expressed as a percentage.

The following formula calculates the change relative to the original value (Value 1). $$(Value 2−Value 1)/Value 1×100(Value 2−Value 1)/Value 1×100$$ Percentage change is a standard metric for performance analysis, and it also helps in identifying trends in data over time, regardless of dataset size. ### **Marketshare absolute change** **Marketshare Absolute Change** can be used for assessing the direct change in market share over specific periods and comparing market share between different market segments or product lines.

* **Dimension**: Select the relevant dimension. * Choose the specific data points for comparison. * **Value 1:** Select the initial point of comparison, such as the beginning of a quarter or year. * **Value 2:** Choose the endpoint for comparison, such as the end of a quarter or year. * **Calculation formula:** *measure @Value 1 - measure @Value 2*. This represents the subtraction of one measure's value from another, showing the net change. * After setting up the absolute change calculation, you are prompted to also add a **Market Share Target** filter, allowing for a targeted analysis of market share changes. * Click on **Create** to apply the marketshare absolute change aggregation to the selected measure. ### **Marketshare percentage change** The fields for the calculating marketshare percentage change is the same as that of the absolute change. However, the formula is different because it provides the change as a proportion of the initial value, which is expressed as a percentage.

The following formula calculates the change relative to the original value (Value 1). $$(Value 2−Value 1)/Value 1×100(Value 2−Value 1)/Value 1×100$$ Market share percentage change helps businesses understand their performance in the context of the market relative to competitors." --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://help.tellius.com/tellius-6.3/search/know-your-charts-in-tellius/absolute-and-percentage-change-aggregations.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.