# Overview: Advanced Settings The Advanced Settings window allows you to change the way data is displayed on the Datablock using advanced fields like Granularity, Format, and Scale. ## How to access Advanced Settings from the Designer ![advanced metric settings](/assets/overview-advanced-settings_1.24fb68f4fe292db3abd359ba21e0774b5a7d81f470e30ed993a2cc441c37e625.ba843e8f.gif) 1. Navigate to the **Designer** and click on the Datablock you want to access Advanced Settings for. This will open the **Datablock Editor** on the righthand side of the Designer. 2. At the bottom of the **Datablock Editor,** click **Advanced Metric Settings** to open the **Advanced Metric Settings** window. If you are using a Pipeline, Funnel, Table, Radial Progress, or Pie Chart visualization, you will need to click on a specific **Row** to reveal the corresponding **Advanced Metric Settings**link for that Row. ## How to access Advanced Settings for Calculated Metrics ![](/assets/overview-advanced-settings_2.666564d4c45cb06e896d478137f77f6ead56a1b3be6df6ee73d1bc32ebcc2ffd.ba843e8f.gif) To open Advanced Settings for a Metric in a Calculated Metrics, open the **Data Calculations** window and click on the appropriate **Metric** in the equation. Click on the **Adanced** **Settings** icon in the top right of the selection window to open the **Advanced Settings** for the Metric. ## How to use Advanced Settings ![](/assets/overview-advanced-settings_3.b2119962bd89fa5b257307e2ad36242051a9c228a4a021598e52b49d6687fd69.ba843e8f.png) **A) Tabs:** Depending on the visualization, these Tabs may differ. For Charts, these Tabs represent the line (or bar), the comparison line (or bar), and the number that is displayed at the top of the graph. Changing the text for the Chart Tabs updates the legend below the graph on the Datablock. **B) Data Source:** This is the Data Source that's populating the Datablock. It's recommended that the Data Source is set in the Datablock Editor, not in the Advanced Settings window. **C) Metric:** This is the Metric that's populating the Datablock. It's recommended that the Metric is set in the Datablock Editor, not in the Advanced Settings window. **D) Date Range:** This is the Primary Data Range of the Datablock. It's recommended that the Primary Data Range is set in the Datablock Editor, not in the Advanced Settings window. **E) Cumulative:** For Charts, this toggle controls whether the graph is displayed cumulatively or not. It's recommended that this is set in the Datablock Editor, not in the Advanced Settings window. **F) Granularity:** This determines the data points that are plotted on your chart. "Daily" would plot daily Metric values, "Weekly" would plot weekly Metric values, etc. The options available are based on the data we are able to access for the selected Metric. Learn more about Granularity [here](/overview-advanced-settings). **G) Format:** This determines the unit or formatting that will be added to the Datablock. Example of Formats are "$," "%," etc. Learn more about Format [here](/overview-advanced-settings). **H) Scale:** The Scale determines the rounding that is applied to the Metric Value. Examples of Scale are "Auto," "Thousand," etc. Learn more about Scale [here](/overview-advanced-settings). **I) Compared Metric:** This determines the value to measure your Metric against. Examples of Comparisons are "Previous Period," "Goal," etc. Learn more about Compared Metrics [here](/overview-advanced-settings). **J) Auto-Update:** This determines if all Advanced Settings Tabs will be updated based on what's set on the first Tab. If Auto-Update is enabled, all Tabs are updated. If Auto-Update is disabled, you can edit each Tab individually. Learn more about Auto-Update [here](/overview-advanced-settings). **K) Data Preview:** The Data Preview allows you to get a more granular view at the data included in the Datablock. This includes Dates, Metric Values, Comparison Period Values, and Comparison Change Values. Learn more about Data Preview [here](/overview-advanced-settings). ## What is Granularity? Granularity refers to the level of detail present in a set of data. This affects the presentation of a Line/ Bar Chart, and which Goal values the Metric is measured against. Some Metrics support Hourly, Daily, Weekly, Monthly, and Yearly Granularity, while others have some limitations in terms of Granularity options. You can find more information on Granularity limitations in the Additional Information section of the appropriate [Data Source Guide](//help.databox.com/category/206-data-source-guides). The Granularity that should be selected depends on the Date Range of the Datablock. In most cases, a Datablock with the Date Range of “This Year” or “Year to Date” is viewed with Monthly Granularity. This will result in a Line Chart that plots Monthly Metric Values. If Daily Granularity was selected, every individual day's Metric Value will be plotted on the Line Chart. When This Quarter or Quarter to Date are selected on the Datablock, typically Monthly or Weekly is selected as the Granularity. This selection depends on the level of detail you want to view on the Line Chart. If Monthly is selected, 1 Metric Value will be plotted for each month in the Quarter. This means there will be a maximum of 3 data points on the Line Chart because there are 3 months in a Quarter. If Weekly is selected, 1 Metric Value will be plotted for each week in the Quarter. This means there would be a maximum of 12 data points on the Line Chart to account for each week in the Quarter. Shorter Date Ranges like "This Month," "Month to Date," "This Week," "Week to Date," and "Last 30 Days" are typically viewed with Daily Granularity, so each day has a Metric Value plotted on the Chart. This allows you to closely analyze the data and easily identify emerging trends. If you are viewing a Line Chart with Monthly Granularity, you can only compare to a Monthly Goal that is set for the Metric. Similarly, if you are viewing a Line Chart with Daily Granularity, you can only compare to a Daily Goal that is set for the Metric. ## How to use Granularity [Examples] In this example, we will look at the Sessions Metric from HubSpot Marketing on a Line Chart with Year to Date selected. If Granularity is set to Monthly, we will see the number of monthly Sessions for the year plotted on the Line Graph. ![](/assets/overview-advanced-settings_4.b3666e20a7712f7c1741029c764a2e73a37e5be6c38f0028e7e3560ddfa026c6.ba843e8f.png) If Granularity is set to Weekly, we will see the number of weekly Sessions for the year plotted on the Line Graph. ![](/assets/overview-advanced-settings_5.ae9448826f2fa1b171bad22ba1cfa3cd784b52e9f5b95ad13d039730e8541e6f.ba843e8f.png) If Granularity is set to Daily, we will see the number of daily Sessions for the year plotted on the Line Graph. When using Daily Granularity on a Chart with a longer Date Range, only some days will be visible on the x-axis. All daily values can be viewed by hovering over the line on the Datablock. ![](/assets/overview-advanced-settings_6.7de76066fab49cc707e6ae8c4737b6fa7dff40f7a2c9aa251f380c9b47f06359.ba843e8f.png) ## What is Compare With? ![](/assets/overview-advanced-settings_14.3d595be64787ceac624b1c9bc3bdd2fb3b25181602eb9da01b3bb75c4c5cb3d5.ba843e8f.png) The Compare With selection can be updated in the Advanced Metric Settings window and in the Datablock Settings directly in the Designer. Using Advanced Metric Settings, you have the ability to select **None**, **Previous Period**, **Same Period Last Year,[Custom Range](/select-date-ranges), Other Metric,** or **Goal** to measure your Metric against. The data for the selected Date Range, Metric, or Goal will be measured against your current performance and displayed on the Datablock. Not all visualizations support comparison data, so this section will not be visible in every Advanced Settings window. Learn more about which visualization types support comparison data [here](/choose-the-best-visualization-for-your-data). ## How to use Compare With [Examples] Let's say we're looking at **Sessions** for the current **Month to Date****.** If **Previous Period** is selected as the **Compare With** value, the current month's performance will be compared to the previous month's performance at the same time. If **Same Period Last Year** is selected as the **Compare With** value, the current month's performance will be compared to the current month's performance from the previous year. If **Custom Range** is selected as the Compare With value, the current month's performance will be compared to the selected Custom Range period. If **Other Metric** is selected as the **Compare With** value, the current month's performance will be compared to the selected Metric. If **Goal** is selected as the **Compare With** value, the current month's performance will be compared to the Goal value set for the month. ## What is Change Function? ![](/assets/overview-advanced-settings_15.9dd9158c7f14c1c1ab36c3e70dfe69d14de922dfb7c94d0112251e31e676176f.ba843e8f.png) The Change Function refers to the way your current performance compared to the **Compare With** selection is displayed on the Datablock. By default, **Percentage Change** is selected as the **Change Function.** If **Previous Period** is selected as the **Compare With** Value, this means that the percentage change from the previous period will be displayed on the Datablock. This is calculated through the following equation: (Current Metric Value - Previous Period Metric Value) / (Previous Period Metric Value) You can update the **Change Function** to show the **Ratio** or **Absolute Change** for the Metric. Selecting **Ratio** will change the comparison equation to the following: (Current Metric Value / Previous Period Metric Value) * 100 Finally, selecting **Absolute Change** will make it so the difference between the previous period's performance and the current performance will be displayed on the Datablock. This will change the comparison equation to the following: Current Metric Value - Previous Period Metric Value ## How to use Change Function [Examples] Let's say we're looking at **Sessions** for the current **Month to Date** and comparing to the **Same Period Last Year**. So far this month, we have **42,510 Sessions** tracked. Last year at this time, we had **29,998** tracked for the month. If **Percentage Change** is selected as the **Change Function**, the following calculation will be performed on the backend: (42,510 - 29,998) / (29,998) = 41.7 Therefore, **42%** will be displayed on the Datablock. ![](/assets/overview-advanced-settings_16.7d4109451d7984bc519338c2a33ce33d9529bbf24894d08804b0a4446fbe0885.ba843e8f.png) If **Ratio** is selected as the **Change Function**, the following calculation will be performed on the backend: (42,510 / 29,998) * 100 = 141.7 Therefore, **142%** will be displayed on the Datablock. ![](/assets/overview-advanced-settings_17.565150115c759884a6669740919402fb82796355db38aab4ee952f89d5bd05dd.ba843e8f.png) If **Absolute Change** is selected as the **Change Function**, the following calculation will be performed on the backed: 42,510 - 29,998 = 12,512 Therefore, **12,512** will be displayed on the Datablock. ![](/assets/overview-advanced-settings_18.459a8f6a73a0ac9eb19dd2613f73ab1611d0056cb3f0c43db085a2d6b5cf70bf.ba843e8f.png) ## How to set the Change Format ![](/assets/overview-advanced-settings_19.ac29b563d9c19810c0faec8795da24f7559b25e408bc2729e76fd62915591a82.ba843e8f.png) The Change Format works the same as the Format field, but this specifies the way the comparison data will be displayed on the Datablock. This field automatically updates based on the **Change Function** selected. By default, the **Change Function** is set to **Percentage** and the **Change Format** is set to **+0%**. If the **Change Function** is changed to **Absolute Change**, the **Change Format** will automatically update to **+0**. Learn more about Format options [here](/overview-advanced-settings). ## How to use Auto-Update For Chart visualizations, you will see Tabs indicating multiple Lines/ Bars and Numbers on your Datablock. ![](/assets/overview-advanced-settings_20.1782578eb3b12cba26ad6b7ac6df5405cd08f2e0d3dc4301dae48e844e34a6a5.ba843e8f.gif) For visualizations that support multiple Date Ranges, you have the ability to treat each Date Range separately and configure unique settings. ![](/assets/overview-advanced-settings_21.549c269b22e6eacfec035adce16227d611434d4af4ed0520832e1efcee0255f9.ba843e8f.gif) By default, **Auto-Update** is **enabled**, meaning any changes you make to the first Tab or Date Range will update the settings for all other Tabs or Date Ranges as well. When **Auto-Update** is **disabled**, all Tabs and Date Ranges will be unique, so any changes you make to one Tab or Date Range will not be applied to other Tabs or Date Ranges. You can also change the name of Lines on a Line Chart, Column Headers on a Table, etc. by clicking on the Tab title and directly entering the new title in the text field. Learn more [here](/choose-the-best-visualization-for-your-data). ## How to use the Data Preview The Data Preview allows you to get a more granular view at the data included in the Datablock. This includes Dates, Metric Values, Comparison Period Values, and Comparison Change Values. If you are viewing **Sessions** for the current **Year to Date**with **Monthly Granularity** selected, the Data Preview will show data for each month of the current year, up until the current month. If you are viewing **Sessions** for the current **Year to Date** with **Daily Granularity** selected, the Data Preview will show data for each day of the current year, up until the current day. As you make changes in the **Advanced Settings** window, the **Data Preview** will update to reflect your current selection. This allows you to verify your selections and ensure the Datablock is displaying data in an optimal way. ![](/assets/overview-advanced-settings_22.0beeb0c6a29ee09b3adbe0398014319427a297f105a70c33a88f3c68cb2d4afa.ba843e8f.gif)