Page Comparison

Appanvil karma designer

summary	Calculate Metrics in Visualizations	page	{"premium":true,"id":"pdN0WowSrVG8F4fryc-j1","name":"page","children":[{"id":"brLCqdKcox4nCaRSBXAvT","params":{"background":"#0000","padding":80,"gap":10,"image":{"value":"att456720389","target":"_blank","type":"attachment"}},"children":[{"id":"mrVzFPzSxpE1I0rajsC1u","name":"row","children":[{"id":"1cCQXDL6jDSJctZpqsjIS","name":"column","children":[{"name":"image","params":{"templateId":"square","alignment":"center","width":100,"height":100,"position":"center center","borderRadius":{"all":0,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false} How do I calculate metrics in visualizations? You can calculate your own metrics from the metrics already available in your visualizations using basic arithmetic functions. These ‘calculated metrics’ are available only in the visualizations where you create them - Analytical Designer does not save these calculated metrics to the Data Catalog.You can calculate metrics from:Metrics, facts and attributes that you add to the Metrics section from the Data CatalogDerived metrics created using time-over-time comparisonOther calculated metricsYou can use the following arithmetic functions: Create a Calculated Metric Steps:Create a visualization with at least two items in the Metrics section.In the Metrics section, hover your mouse over the plus sign and click Create metric. 3. In the Outcome is dropdown menu, select the function that you want to use to calculate the new metric. 4. In the Where section, click Choose Metric and select a metric from the list of available items for both parts of the function (A and B). The metrics and attributes that you select are highlighted above in the Metrics section. Analytical Designer adds a new metric to the Metrics section and displays it in the visualization. Names of Calculated Metrics Analytical Designer creates automatic names for calculated metrics. The name consists of the name of the function and the metrics used. For example, Difference of Sum of Budget and Sum of spend.For details about changing the name, see article Rename Metrics, Attributes, and Dates in Visualizations. Compare Calculated Metrics over Time You can compare calculated metrics over time as any regular metric. Calculated metrics from metrics already derived from time-over-time comparison cannot be compared over time again. Calculated Metrics vs. Original Metrics Calculated metrics depend on the metrics that are used to create them. If you delete the metric used to create the calculated metric, the calculated metric and metrics derived from it are also removed. When you drag the metric to the Data Catalog, Analytical Designer highlights all the metrics to be deleted and then displays a message.If you switch to a visualization type that cannot display the metrics used to create the calculated metric, the calculated metric is hidden. Delete a Calculated Metric To delete a calculated metric, drag and drop it to the Data Catalog. Return to homepage
page	{"premium":true,"id":"pdN0WowSrVG8F4fryc-j1","name":"page","children":[{"id":"brLCqdKcox4nCaRSBXAvT","params":{"background":"#0000","padding":80,"gap":10,"image":{"value":"att452329508att456720389","target":"_blank","type":"attachment"}},"children":[],{"id":"wFyOU4MBOsm4y9WCzEVJnmrVzFPzSxpE1I0rajsC1u"},{"name":"textrow","paramschildren":[{"valueid":[{"type"1cCQXDL6jDSJctZpqsjIS","name":"paragraphcolumn","children":[{"typename":"paragraphimage","childrenparams":[{"letterSpacingtemplateId":-1"square","fontFamilyalignment":"Poppins, sans-serifcenter","lineHeightwidth":"80px"100,"textheight":"Calculate Metrics in Visualizations"100,"colorposition":"#79BA75","fontSize":28}],"align":"center"}]}]},"children":[],"id":"9u4aEcfNaYoEtHduYWgDQ"}],"params":{"center center","borderRadius":{"all":0,"btlbbl":0,"bblbbr":0,"btrbtl":0,"bbrbtr":0,"isIndividualCorners":false},"paddingimage":0,{"gapvalue":10"att452329508","verticalAlignmenttarget":"center"_blank","type":"attachment"}},{"children":[],"id":"UTk7RAYVeVxrrpj8NmYPSwFyOU4MBOsm4y9WCzEVJn"},{"name":"columntext","childrenparams":[],{"paramsvalue":[{"borderRadiustype":{"allparagraph":0,"btlchildren":0,[{"bbltype":0,"btrparagraph":0,"bbrchildren":0,[{"isIndividualCornersletterSpacing":false}-1,"paddingfontFamily":0"Poppins, "gap":20sans-serif","verticalAlignmentlineHeight":"center"}},{"id":"QjlnfFkSGipQtbHLFcQlb","name":"column"80px","text":"How do I calculate metrics in visualizations?","color":"#79BA75","fontSize":28}],"align":"center"}]}]},"children":[],"id":"9u4aEcfNaYoEtHduYWgDQ"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":2010,"verticalAlignment":"center"}},{"id":"5h4A2XJxT9N8jMwBfbrBqUTk7RAYVeVxrrpj8NmYPS","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"jCbzjA_WAQ5JuNEQKXWPXQjlnfFkSGipQtbHLFcQlb","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"JPQqpTkQOlpB_6winUeTy5h4A2XJxT9N8jMwBfbrBq","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}}],{"paramsid":{"layout":[1]jCbzjA_WAQ5JuNEQKXWPX","gapname":45,"minHeightcolumn":200,"paddingchildren":10[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false}}],"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"JPQqpTkQOlpB_6winUeTy","name":"section"}]}

You can calculate your own metrics from the metrics already available in your visualizations using basic arithmetic functions. These ‘calculated metrics’ are available only in the visualizations where you create them - Analytical Designer does not save these calculated metrics to the Data Catalog.

You can calculate metrics from:

Metrics, facts and attributes that you add to the Metrics section from the Data Catalog
Derived metrics created using time-over-time comparison
Other calculated metrics

You can use the following arithmetic functions:

Function	Expression	Example	Default format
`Sum`	A+B	Sum of A and B	##.##
`Difference`	A-B	Difference of A and B	##.##
`Product (Multiplication)`	A×B	Product of A and B	##.##
`Ratio`	A÷B	Ratio of A and B	##.##
`Change`	(A-B)÷B	Change from B to A	##.##%

Create a Calculated Metric

Steps:

...

Create a visualization with at least two items in the Metrics section.

In the Metrics section, hover your mouse over the plus sign and click Create metric.

In the Outcome is dropdown menu, select the function that you want to use to calculate the new metric.

In the Where section, click Choose Metric and select a metric from the list of available items for both parts of the function (A and B).

The metrics and attributes that you select are highlighted above in the Metrics section.

Analytical Designer adds a new metric to the Metrics section and displays it in the visualization.

...

Example

You run advertising campaigns and you have a set budget for each category of advertising. You would like to know how much money you have left for each different type of advertising.

Your Data Catalog includes the following data:

The budget for your campaigns (Budget)
The spending on your campaigns so far (Spend)
A list categorizing your advertising channels (Category)

You can use these metrics to calculate the amount of money you have to work with.

Steps:

Drag Budget and Spend to the Metrics section.
Drag Category to the Rows section.
In the Metrics section, click Create Metric and select:
- Difference as the outcome
- Sum of Budget as M1
- Sum of Spend as M2

The following image shows the final visualization:

calculated metrics example Image Removed

Names of Calculated Metrics

Analytical Designer creates automatic names for calculated metrics. The name consists of the name of the function and the metrics used. For example, Difference of Sum of Budget and Sum of spend. For details about changing the name, see Rename Metrics, Attributes, and Dates in Visualizations.

Compare Calculated Metrics over Time

You can compare calculated metrics over time as any regular metric. For details, see Use Time-over-Time Comparison in Visualizations.

Calculated metrics from metrics already derived from time-over-time comparison cannot be compared over time again.

Calculated Metrics vs. Original Metrics

Calculated metrics depend on the metrics that are used to create them. If you delete the metric used to create the calculated metric, the calculated metric and metrics derived from it are also removed. When you drag the metric to the Data Catalog, Analytical Designer highlights all the metrics to be deleted and then displays a message.

deleting calculated metrics Image Removed

If you switch to a visualization type that cannot display the metrics used to create the calculated metric, the calculated metric is hidden.

Delete a Calculated Metric

To delete a calculated metric, drag and drop it to the Data Catalog.

...

column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}}],"params":{"layout":[1],"gap":45,"minHeight":200,"padding":10,"borderRadius":0}}],"name":"section"},{"id":"AlV8tRNrUbhNIqv5QfPxt","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":74,"gap":10},"children":[{"id":"NGNn-LA9vXoPpyZfNs5Cp","name":"row","children":[{"id":"_mU5dbxyxThXLdo6vRdLT","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"You can calculate your own metrics from the metrics already available in your visualizations using basic arithmetic functions. These ‘calculated metrics’ are available only in the visualizations where you create them - Analytical Designer does not save these calculated metrics to the Data Catalog.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"You can calculate metrics from:","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"numbered-list","children":[{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Metrics, facts and attributes that you add to the Metrics section from the Data Catalog","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Derived metrics created using time-over-time comparison","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Other calculated metrics","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"You can use the following arithmetic functions:","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]}]},"children":[],"id":"IB8oPfCyGo63xY76SVU9I"},{"name":"image","params":{"templateId":"full-width rounded","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588513369","target":"_blank","type":"attachment"}},"children":[],"id":"ube6mgiuWoEeUKNXMCw4c"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"VsxjQfPFCbwLSP7Hv6jco","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ih0zsbahEPxciRqD8ar_D","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"-UvrflFUE-BHj2Nr6mqNi","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"0-Ka0w02UYICmirYFgWTU","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"vxnU1L5nmoznbemB02ItV","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0}}],"name":"section"},{"params":{"background":"#ffffff","padding":20,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Create a Calculated Metric","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"J9dmLEjDS7eOYmVxy7GQh"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"qb3kfHaROQF_z66E5lgsO"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Steps:","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"numbered-list","children":[{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Create a visualization with at least two items in the Metrics section.","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"In the Metrics section, hover your mouse over the plus sign and click Create metric.","fontFamily":"Poppins, sans-serif","fontSize":18}]}]},{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]},"children":[],"id":"6p2MwFna8aZEm6mTRJfgB"},{"name":"image","params":{"templateId":"full-width rounded","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588578855","target":"_blank","type":"attachment"}},"children":[],"id":"q9MB1VL9FN2Vh_0j250W3"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"3. In the Outcome is dropdown menu, select the function that you want to use to calculate the new metric."}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":""}]}]}]}]},"children":[],"id":"J1luaGiNmjNrE-eValub1"},{"name":"image","params":{"templateId":"full-width rounded","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588382245","target":"_blank","type":"attachment"}},"children":[],"id":"I8t-VyQnBzqGu4CuntKkv"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"4. In the Where section, click Choose Metric and select a metric from the list of available items for both parts of the function (A and B). The metrics and attributes that you select are highlighted above in the Metrics section."}]},{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":""}]}]}]}]}]},"children":[],"id":"bEtIfPDQp_dftG_F5i-_A"},{"name":"image","params":{"templateId":"full-width rounded","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att589004801","target":"_blank","type":"attachment"}},"children":[],"id":"OBS2Q0p8SHn_f7LqJ3g_E"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Analytical Designer adds a new metric to the Metrics section and displays it in the visualization.","fontFamily":"Poppins, sans-serif","fontSize":18}]}]}]}]}]}]},"children":[],"id":"YzxqhgO9WcDI6bJKImJY2"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"gVzMsIeeLlPXNNEfukqe2"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"YSX2EFehwte4dELlvmuSF"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"MjgO7_2UTsS3_FgGKxsdA"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"AlYUhr4PgJ3M7CW1mdZDt"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"49F1dLBAto2exD33DSB6T"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"bQDn4OpFo7YOI7WUH_iB-"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"CvwUuRs1YlWjaoCpkr7hU"}],"name":"section","id":"tYVR1JpcbE5Lk-PVhxATa"},{"params":{"background":"#ffffff","padding":20,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Names of Calculated Metrics ","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"vNLlLWCxks8mJp0dwIbuT"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"Re0AtimfcWnyZT7otYavb"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Analytical Designer creates automatic names for calculated metrics. The name consists of the name of the function and the metrics used. For example, Difference of Sum of Budget and Sum of spend.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"For details about changing the name, see article ","color":"#555"},{"type":"link","link":{"value":"https://learnamp.atlassian.net/wiki/spaces/KBDI/pages/587038763/Rename+Metrics+Attributes+and+Dates+in+Visualizations","target":"_blank","type":"link"},"children":[{"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"Rename Metrics, Attributes, and Dates in Visualizations.","underline":true,"color":"#555"}]},{"text":"","color":"#555"}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]}]}]},"children":[],"id":"zO6_27dO4ibmaHIfODPch"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"YoQgu5ZMNX96-KTLl8ujk"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"QCfJkGd7861YXT86jIJHa"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"ni0CsUuc-ymI8gORP48ER"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"coslOkwSnyucd_QNTSqsQ"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"HBaTTd4OVrmpjKlYI89WS"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"GaRUnu2u4X9uJx2c1lXy1"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"QO6-9wHVW_xHG_6mnyMlh"}],"name":"section","id":"lhmWuwwH573BsdDGRaOxP"},{"params":{"background":"#ffffff","padding":20,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Compare Calculated Metrics over Time","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"cv-YJrVQTHX6qhoxyZ3a7"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"0i0TxZBAxbQWWV6Pjjq6J"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"You can compare calculated metrics over time as any regular metric. ","fontFamily":"Poppins, sans-serif"}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Calculated metrics from metrics already derived from time-over-time comparison cannot be compared over time again.","fontFamily":"Poppins, sans-serif"}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":""}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]},"children":[],"id":"PwS_pwXl7cc_kCt4oIlJq"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"TkM-81J4pJJInhXUVefzr"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"y4navuwz_9LLlgL_3s3D6"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"A_Ro0QyfaX3kJW-Er9vw3"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"2y7LZXYMb4ogLoYLvRl-K"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"beZB7Yjj7Ov_8s9hCMpoV"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Or2y7j5aa9WsjI5dwPghI"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"qEkAbU3cz1rhqAGbS0JBI"}],"name":"section","id":"lX-xVxQA38TF8DAs5ebxw"},{"params":{"background":"#ffffff","padding":20,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Calculated Metrics vs. Original Metrics","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"igTPuCxVgkA6ObLE_c79B"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"hlGVZ17DYlLbE7Bjan1ep"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Calculated metrics depend on the metrics that are used to create them. If you delete the metric used to create the calculated metric, the calculated metric and metrics derived from it are also removed. When you drag the metric to the Data Catalog, Analytical Designer highlights all the metrics to be deleted and then displays a message.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"If you switch to a visualization type that cannot display the metrics used to create the calculated metric, the calculated metric is hidden."}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]},"children":[],"id":"BL-xQP9OiBRAMnlAnIQ7p"},{"name":"image","params":{"templateId":"full-width rounded","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att589201409","target":"_blank","type":"attachment"},"width":605,"height":273},"children":[],"id":"SHzA9Dy20B5C65NdFYzoL"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Ty7DkhFoeZQxZWWaK-5A3"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"g87K6AjFd2Kc3g_CEXq3H"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"rYgx461tcZLgXeQDj8IH4"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"U3p0u0llPCEyqX0c0s1dT"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"0hPDYaJEhKYH7dFe7z4un"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"vZ0na3qjiQCiTmo3fEaeb"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"usu3G-DqxTHeWDIQtK5bu"}],"name":"section","id":"IVPfw03ZZz-9RgacfLfqG"},{"params":{"background":"#ffffff","padding":20,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Delete a Calculated Metric ","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"i5IlWKi0OcGf5plkPpIp-"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"8rembczRSNXFEn2YsWfrg"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"To delete a calculated metric, drag and drop it to the Data Catalog.","fontFamily":"Poppins, sans-serif"}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]},"children":[],"id":"Vw9-lAUmg3pyz1RZ9xo94"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"G2dsXUgWEjDfiK6Nsk4ir"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"uQzNdnpU5ah0G3n48oGGo"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"NFfHs4YNRApZpWcj3632I"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"lh-GW9QXwwJl-a2Dodrro"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"2HvYItoVIoZJAoQWiTJ9A"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"L-ieq3chQPgtFWf_-7RH8"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"jiMXqc8Cga4xyOWv2KLGR"}],"name":"section","id":"9vVeexrWlTC5BP7S-_yxf"},{"params":{"background":"#0000","padding":71,"gap":10,"image":{"value":"att456720389","target":"_blank","type":"attachment"}},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"divider","params":{"color":"

...

#78B875","alignment":"center","fontSize":24,"fontColor":"#000000","height":3,"borderStyle":"solid","width":100},"children":[],"id":"

...

El5qRenl3OfVF786_N5WI"},{"name":"button","params":{"templateId":"regular button","label":"Return to homepage","size":"medium","shape":"circular","alignment":"center","states":{"idle":{"colors":{"background":"#79BA75","label":"#ffffff"}},"hover":{"colors":{}}},"link":{"value":"https://learnamp.atlassian.net/wiki/spaces/KB/overview","target":"_blank","type":"link"}},"children":[],"id":"

...

u45RqtQOBg34oxovAj-

...

FV"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":10,"verticalAlignment":"center"},"id":"

...

wRCWIVOnClf8WPLTOp9uy"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"

...

SZmLPq35lU9BQasNLfBOL"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"

...

565qtdGy1bqIr81E5Ru6F"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"

...

mtgMoC7OrJzUEV94dIZMu"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"

...

7m7UqjyF7u6gBCYGDiomB"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"

...

dDZv-SJb9UTbBn-Oln6N6"}],"params":{"layout":[1],"gap":45,"minHeight":200,"padding":10,"borderRadius":0},"id":"

...

NBATTz1cZwQ6cHMtb_eSq"}],"name":"section","id":"

...

DlTjgH93E_xS26iRL5Aft"}]

...

}

Versions Compared

Old Version 2

New Version Current

Key