Controls

This option lets you decide how the numbers in your report are calculated. You’ve got three choices:

Mean:

• What it does: It calculates the average of your numbers.
• How it works: It adds up all the values in your dataset and divides the total by the number of values. Simple, right? This gives you a central value that represents your data.
• When to use it: Go for the mean when you want to know your data's overall average performance or value.

### Mode:

• What it does: It finds the most frequently occurring number in your dataset.
• How it works: The mode is the value that pops up most often. If multiple values appear with the same highest frequency, your dataset is considered multimodal.
• When to use it: Use the mode when you want to spot the most common value or trend in your data.

### Percentile:

• What it does: It calculates the value below which a certain percentage of your data falls.
• How it works: Percentiles split your dataset into 100 equal parts. For example, the 50th percentile (aka the median) is the value below which 50% of your data falls. Here are the percentiles you can choose from:30th Percentile: 30% of your data falls below this value.50th Percentile (Median): 50% of your data falls below this value.70th Percentile: 70% of your data falls below this value.85th Percentile: 85% of your data falls below this value.95th Percentile: 95% of your data falls below this value.
• When to use it: Percentiles are great for understanding the distribution of your data, especially if you’re focusing on specific segments like the top 15% or bottom 30%.

These options let you jazz up your charts with trendlines or regression lines to visualize your data better.

### Trendline:

• What it does: It adds a trendline to your chart to show the general direction of your data.
• How it works: The trendline is calculated using linear regression, which fits a straight line to your data points. This line shows the overall trend—whether it’s going up, down, or staying steady.
• When to use it: Use the trendline when you want to quickly spot patterns or trends in your data over time.

### Regression Line:

• What it does: It adds a regression line to your chart to show the relationship between your data points.
• How it works: The regression line is calculated using polynomial regression, which fits a curved line to your data points. This method is more flexible than linear regression and can capture more complex relationships in your data.
• When to use it: Go for the regression line when your data has a non-linear relationship and you want to dig into more intricate patterns.