> ## Documentation Index
> Fetch the complete documentation index at: https://support.affinity.co/llms.txt
> Use this file to discover all available pages before exploring further.

# How To Create Custom Dimensions Measures And Calculations In Affinity Analytics

> Help center reference

<Note>**Advanced** — power-user technique.</Note>

Trying to calculate, convert, or transform your existing fields to gain new insights? With Affinity Analytics, you can create new datapoints from existing fields in your list by creating custom dimensions, measures, and table calculations.

**Note**: This video contains the old navigation bar on the top, whereas the current navigation bar now lies on the left side of your screen. While the remaining content is still the same, rest assured that we will be updating our videos accordingly.

## Definitions to know

* **Dimensions** - The existing fields in your lists (e.g. Status, Owners, Amount, Location, etc.).
* **Measures** - The units of measurement for these existing fields (e.g. Count, Average, etc.)
* **Table Calculations** - Completely new fields generated from your existing fields.

## How to create custom dimensions, measures, and calculations

1. On the dashboard view you'd like to create these custom fields in, click the ellipsis (3 dotted icon), then click **Edit dashboard**.

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/1.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=773a15a74d282105fe865807337126b3" width="2428" height="1172" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/1.jpg" />

2. Click the ellipsis (3 dotted icon) on the specific tile that you'd like to create these custom fields in, then click **Edit**.

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/2.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=f4f3fde6f0ea13ccb350c83881a31baf" width="2408" height="1198" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/2.jpg" />

3. In this example, we'll go over how to create a new table calculation based on the **Check Size** dimension shown in this visualization tile. To create this new table calculation, click **+ Add** next to the **Custom Fields** section, then click **Table Calculation**.

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/3.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=03073940aede9d7bb39e73378008e305" width="2240" height="1172" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/3.jpg" />

4. Let's say this newly-calculated field is meant to track an adjusted amount of the **Check Size** based on the commission percentage our Sales Team receives for their closed deals. Therefore, click on the text box and select **Check Size**.

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/4.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=9d0c7ee6ddda9e8f09b051cdfb56db07" width="1654" height="1248" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/4.jpg" />

5. Now, we'll use the asterisk (\*) to multiply **Check Size** by the commission percentage of 15% (0.15). Then, select whatever currency format applies to you/your team in the **Format** field (e.g. Dollars, Pounds, or Euros), name this new field (e.g. Commission), and click **Save**.

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/5.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=fe99ecc37eaa608b6e71165f35ebc77d" width="1640" height="1234" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/5.jpg" />

6. Now, you'll see **Commission** as a new field showing up in the **Visualization** section - click **Run** to make sure any other changes applied render successfully, then click **Save**.

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/6.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=d08952bfe0c4e09f580947bf55cb08f3" width="2240" height="1176" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/6.jpg" />

7. Click **Save** one more time to ensure all changes to the dashboard view are saved, and you're all set!

<img src="https://mintcdn.com/support-affinity/qJlYCH8FNmmH35yn/images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/7.jpg?fit=max&auto=format&n=qJlYCH8FNmmH35yn&q=85&s=5c2a4f18f98aadf5b048f15eb140785f" width="2524" height="1200" data-path="images/features-analytics/how-to-create-custom-dimensions-measures-and-calculations-in-affinity-analytics/7.jpg" />

## Additional Information

Aside from the basic operators (i.e. addition, subtraction, multiplication, division), check out the full list of Looker functions/operators you can use for your custom dimensions, measures, and table calculations: [Looker functions and operators](https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators)
