| summary | Multidimensional Analytical Query Language (MAQL) Multidimensional Analytical Query Language, or MAQL for short, is a querying language. It comes with a set of predefined functions that you can use for simple queries such as averages or complex statistical analysis such as skewness and kurtosis.Before you get started, you should know that:1. Metrics always return numerical values.2. Metric can only return value based on some dimensionality/context in which it is executed.3. Metrics in MAQL start with keyword SELECT.4. A simple aggregation function looks like this:5. SELECT SUM({fact/quantity}) Write your first metric The following examples will show you a simple progression path to building your own metrics. Each example is followed by syntax description.MAQL always works in the context of data available in a given logical data model which determines the available data and utilization of MAQL statements.Example 1 - quantityThe countThe following sample uses the SUM COUNT aggregation function on a fact (quantity) to return total all-time sales:SELECT SUM({fact/quantity})This will result in a visualization featuring a single number, total units sold, in a single row.Example 2 - adding arithmeticTo find out what was the revenue of the total all-time sales, first multiply two facts (quantity and price) and then aggregate to the context:SELECT SUM({fact/quantity} * {fact/price})This will result in a visualization featuring a single number, revenue for total units sold, in a single row.Example 3 - conditioning/filtering and reusing metricsThe following example reuses the existing metric (Amount Sold) and combines it with the conditional statement WHERE defined by the Label (Color) and Label Value (Red).SELECT {metric/amount_sold} WHERE {label/Color}="redthe count of tags associated with content:SELECT COUNT({label/tags.id})Example 2 - conditioning/filtering The following example uses the conditional statement WHERE to return a count of tasks that were completed.SELECT COUNT ({label/tasks.id}) WHERE {label/tasks.completed}= "true"When constructing complex metrics, your choice of attributes and attribute values is determined by the context of available data. Add Comments to Custom Metric You can add comments to your customized metric by including the # symbol.Syntax SELECT {metric/amount_sold} # this is a commentAnything after the hash sign # is ignored during computation. If you need multiline comments, each line must start with a #. To Return to homepage PLEASE NOTE: Click here to learn more about MAQL, see here. Return to homepage |
|---|
| page | {"premium":true,"id":"pdN0WowSrVG8F4fryc-j1","name":"page","children":[{"params":{"background":"#ffffff#0000","padding":6,"gap":1020,"gap":10,"image":{"value":"att456720389","target":"_blank","type":"attachment"}},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"image","params":{"templateId":"square","alignment":"center","width":100,"height":100,"position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att448266262","target":"_blank","type":"attachment"}},"children":[],"id":"WMxKuf79M5-QgwzaJ8nVr"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"cgrj7PG4GTJMi0UxI41N6"},{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Multidimensional Analytical Query Language (MAQL)","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#2A2A2A#E6AC00"}],"align":"center"}]}]},"children":[],"id":"DTcH3DS3QvpAmVclBtLgC"},{"name":"divider","params":{"templateId":"solid short","color":"#E0A804","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"pT6EPjeQMrjbrXf-mwaPE"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":""}]}]}]},"children":[],"id":"ULsHOQ_ITd1GvVztCEzoM"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"cq2IWUh5E-g0cbyVU6hOR"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"9zhpAEKMlbMFBvambmBfS"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"t0bBWXGK-Zcx12gAgHjMJ"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"mtfM2T2_I5kFO2zw9TGi5"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"5Z6McsHaHqxEXTbh1xs0R"}],"params":{"layout":[1,2],"gap":15,"minHeight":200,"padding":10,"borderRadius":0},"id":"2knMWh2YlWaZYz6rxZqEG"}],"name":"section","id":"9SGkhyV2xDFyXbmjo4PjGA_XowDO19qTVYs0Uum0qD"},{"id":"y4m0bR8N7bUJcKiBr7q5f","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":0,"gap":10},"children":[],"name":"section"},{"id":"GL7Yj2oktONIjujDwyQ7B","params":{"background":{"light":"somxGTxgrpR_cdCYVAyIY"#ffffff","dark":"#1d2125"},"padding":0,"gap":10},"children":[{"id":"dg5_I6vQFlS2QPULpodGa","name":"row","children":[{"id":"45qv2BC7Ad7Z4n02vLY3UKXyNZjt8kkvOvBuElg0F0","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"Multidimensional Analytical Query Language, or MAQL for short, is a querying language. ","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"It comes with a set of predefined functions that you can use for simple queries such as averages or complex statistical analysis such as skewness and kurtosis.","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"Before you get started, you should know that:","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"1. Metrics always return numerical values.","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"2. Metric can only return value based on some dimensionality/context in which it is executed.","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"3. Metrics in MAQL start with keyword SELECT.","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"4. A simple aggregation function looks like this:","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","lineHeight":"35px","color":"#2A2A2A","text":"5. SELECT SUM({fact/quantity})","fontSize":18}]},{"type":"paragraph","align":"left","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","fontWeight":700,"text":""}]}]}]}]},"children":[],"id":"eksAIGi17jgNV8H50shZdnpahaaAK0AjVJfOViHrKD"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"owQyNXJhfQ4Q-6p-6dZAyQiIYvTqGPZrseJXEY2cM","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"9kIxjYLti8Z47LWY8AUUkcREVlxzdFvzXHLvT-Vg-U","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"3LDpmQy5q2K2Kzw-GtXxuJLGQLU3EQjnMwymUfv8qU","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"QY7pNJXxmWEe9i9lA-A7cHeG1fSbRR_RbFwp0GPcq","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"kQV-WSG2Q9bo78bmqhUVZDT7sOCKRRpj3NlKr6ZHlQ","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":0,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Write your first metric","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#FF851A"}],"align":"center"}]}]},"children":[],"id":"T93TUCr9mjqFiplGz0anJ"},{"name":"divider","params":{"templateId":"solid short","color":"#FF851A","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"Y5zs_r_fAmeBODSqYfSD4"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"yYJeie2RbpBPb-x5_F8T4"},{"name":"column","children":["}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"NVIKyeUjbOqTP3ke6mKJEyYJeie2RbpBPb-x5_F8T4"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"-LNfVUJnUNZToVlOdqd5-NVIKyeUjbOqTP3ke6mKJE"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"JAVnqI6-LNfVUJnUNZToVlOdqd5-539eV87iVRfEg"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"hDQeiPHawMMp4C0SB4oqqJAVnqI6-539eV87iVRfEg"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"81EMxo0HlJ2INNJMBvMUhhDQeiPHawMMp4C0SB4oqq"}],"params":{"layoutname":[1],"gapcolumn":100,"minHeightchildren":50[],"paddingparams":10,{"borderRadius":0},{"idall":"-dbLS3nsBcYy34LQj-_NK"}]0,"namebtl":"section"0,"idbbl":"vnFHvA2iO8ZWOlmlZWTio"}0,{"id":"NKrwOuBR063gaeGAZBHwJ","params":{"background":{"light":"#ffffff","dark":"#1d2125""btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":10}20,"childrenverticalAlignment":[{"id":"AG5FpsyJ9IoIYEhNs73mt"center"},"nameid":"row81EMxo0HlJ2INNJMBvMUh"}],"childrenparams":[{"idlayout":"ddpEcFVJFwLjR6vei5LMb"[1],"namegap":"column"100,"childrenminHeight":[{50,"namepadding":"text"10,"paramsborderRadius":{0},"templateIdid":"simple paragraph"-dbLS3nsBcYy34LQj-_NK"}],"valuename":[{"typesection":"paragraph","childrenid":[{"type":"paragraph","children":[{"lineHeightvnFHvA2iO8ZWOlmlZWTio"},{"id":"24pxNKrwOuBR063gaeGAZBHwJ","colorparams":{"#555background",:{"letterSpacinglight":0"#ffffff","textdark":"The following examples will show you a simple progression path to building your own metrics. Each example is followed by syntax description.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph#1d2125"},"padding":0,"gap":10},"children":[{"id":"AG5FpsyJ9IoIYEhNs73mt","name":"row","children":[{"lineHeightid":"24pxddpEcFVJFwLjR6vei5LMb","colorname":"#555column","letterSpacingchildren":0,[{"textname":"text","params":{"fontFamilytemplateId":"Poppins, sans-serifsimple paragraph","fontSizevalue":18}],"align[{"type":"centerparagraph"},"children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"MAQL always works in the context of data available in a given logical data model which determines the available data and utilization of MAQL statementsThe following examples will show you a simple progression path to building your own metrics. Each example is followed by syntax description.","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":"Example 1 - quantityMAQL always works in the context of data available in a given logical data model which determines the available data and utilization of MAQL statements.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"The following sample uses the SUM aggregation function on a fact (quantity) to return total all-time sales:","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"bulleted-listparagraph","children":[{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"SELECT SUM({fact/quantity})Example 1 - count","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#FF851A"}],"align":"center"}]},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"This will result in a visualization featuring a single number, total units sold, in a single row.:0,"text":"The following sample uses the COUNT aggregation function on a fact (quantity) to return the count of tags associated with content:","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"bulleted-list","children":"paragraph[{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"SELECT COUNT({label/tags.id})","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},{"type":"paragraph","children":[{"lineHeight":"24px","letterSpacing":0,"text":"Example 2 - adding arithmetic","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"To find out what was the revenue of the total all-time sales, first multiply two facts (quantity and price) and then aggregate to the context:""letterSpacing":0,"text":"Example 2 - conditioning/filtering ","fontFamily":"Poppins, sans-serif","fontSize":18}],"aligncolor":"center#FF851A"}],{"typealign":"bulleted-listcenter"},"children":[{"type":"list-itemparagraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"SELECT SUM({fact/quantity} * {fact/price})The following example uses the conditional statement WHERE to return a count of tasks that were completed.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},,{"type":"bulleted-list","children":[{"type":"paragraphlist-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"This will result in a visualization featuring a single number, revenue for total units sold, in a single row."SELECT COUNT ({label/tasks.id}) WHERE {label/tasks.completed}= \"true\"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacingcolor":0"#555","textletterSpacing":""0,"fontFamily":"Poppins, sans-serif","fontSize":18,"colortext":"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Example 3 - conditioning/filtering and reusing metricsWhen constructing complex metrics, your choice of attributes and attribute values is determined by the context of available data.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"The following example reuses the existing metric (Amount Sold) and combines it with the conditional statement WHERE defined by the Label (Color) and Label Value (Red).","fontFamily":"PoppinsOpen Sans, sans-serif","fontSizetext":18""}]}]}],"align":"center"},{"type":"bulleted-list","children":[{],"typeid":"list-item"e7eNnkqqYc9T_PTIU7A1n"}],"childrenparams":[{"lineHeightborderRadius":{"24pxall":0,"colorbtl":0,"#555bbl":0,"letterSpacingbtr":0,"textbbr":"SELECT {metric/amount_sold} WHERE {label/Color}=\"red\"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"When constructing complex metrics, your choice of attributes and attribute values is determined by the context of available data.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"JrLhSN6_EZ45W7mbROzU-","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"XrVPmvbXeiAO2Y10-pmUU","name":"column","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"fontFamilygap":"Open Sans, sans-serif","text"20,"verticalAlignment":"top"}]}]}]},{"childrenid":[]"VxeCML-lvbzhdzI8ThaRQ","idname":"e7eNnkqqYc9T_PTIU7A1n"}column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"JrLhSN6_EZ45W7mbROzU-weK_K3Eb_2V3LziIUB9ib","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"XrVPmvbXeiAO2Y10-pmUUZTglsFjJrRW997aIbmSn7","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],{"idparams":{"VxeCML-lvbzhdzI8ThaRQ","name":"column","children":[layout":[1],"params":{"borderRadiusgap":{10,"allminHeight":0200,"btlpadding":010,"bblborderRadius":0}}],"btrname":0"section"},{"bbrparams":0,{"isIndividualCornersbackground":false}"#ffffff","padding":0,"gap":2010},"verticalAlignmentchildren":"top"}},[{"idname":"weK_K3Eb_2V3LziIUB9ibrow","children":[{"name":"column","children":[]{"name":"text","params":{"borderRadiusvalue":[{"alltype":0"paragraph","btl"children":[{"type":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ZTglsFjJrRW997aIbmSn7","name":"column""paragraph","children":[{"fontFamily":"Poppins, sans-serif","text":"Add Comments to Custom Metric ","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#FF851A"}],"align":"center"}]}]},"children":[],"paramsid":"to_bsxFfehWB9Vz3sy7tR"},{"borderRadiusname":{"alldivider":0,"btlparams":0,{"bbltemplateId":0"solid short","btrcolor":0,"bbr#FF851A":0,"isIndividualCornersalignment":false},"paddingcenter":0,"gapfontSize":2024,"verticalAlignmentfontColor":"top#000000"}}],"paramsheight":{"layout":[1],"gapborderStyle":10,"minHeightsolid":200,"paddingwidth":10200},"borderRadiuschildren":0}}[],"nameid":"sectionKKt_P0E2R7mt8AS8ZBbmA"}],{"params":{"backgroundborderRadius":{"#ffffffall":0,"paddingbtl":0,"gapbbl":10}0,"childrenbtr":[{0,"namebbr":"row"0,"childrenisIndividualCorners":[{"namefalse},"padding":"column"0,"childrengap":[{20,"nameverticalAlignment":"textcenter"},"params":{"value":[{"typeid":"paragraphMTQ1X1psFknZcB8fBvJB_"},"children":[{"typename":"paragraphcolumn","children":[],"params":{"fontFamilyborderRadius":{"Poppins, sans-serif"all":0,"textbtl":"Add Comments to Custom Metric "0,"bbl":0,"fontSizebtr":220,"letterSpacingbbr":0,"lineHeightisIndividualCorners":false},"35pxpadding":0,"colorgap":"#FF851A"}]20,"alignverticalAlignment":"center"}]}]},"children":[],"id":"to_bsxFfehWB9Vz3sy7tRXdr_SwExHX8xojiH-p-ax"},{"name":"column"divider","children":[],"params":{"templateIdborderRadius":{"solid shortall":0,"colorbtl":0,"#FF851Abbl":0,"alignmentbtr":0,"centerbbr":0,"fontSizeisIndividualCorners":24false},"fontColorpadding":"#000000"0,"heightgap":120,"borderStyleverticalAlignment":"solidcenter"},"widthid":200"StO-CSsKbayCJTU9wT1Sp"},{"childrenname":[]"column","idchildren":"KKt_P0E2R7mt8AS8ZBbmA"}[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"MTQ1X1psFknZcB8fBvJB_zyvcvvSeMzPyLjM2y93JL"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Xdr_SwExHX8xojiH-p-axNI11SL9rs1uqV1BWCF0hh"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"StO-CSsKbayCJTU9wT1SpK9rNxhI4Fcp3CzSS9uSTD"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl"layout":0[1],"bblgap":0100,"btrminHeight":050,"bbrpadding":010,"isIndividualCornersborderRadius":false0},"paddingid":0,"gap":20r-J7n6YWF78GUTk5ZxYB2"}],"verticalAlignmentname":"centersection"},"id":"zyvcvvSeMzPyLjM2y93JLCssLKqd9YAyYgwEMgDFy7"},{"nameid":"columngdvnFnxrrUGT5HraJ1tT7","children":[],"params":{"borderRadiusbackground":{"alllight":0,"btl#ffffff":0,"bbldark":0,"btr#1d2125":0},"bbrpadding":0,"isIndividualCornersgap":false10},"paddingchildren":0,[{"gapid":20"GsxbucKVyh3x5yh9bHmkc","verticalAlignmentname":"centerrow"},"children":[{"id":"NI11SL9rs1uqV1BWCF0hhYlf6VE6SqvrIdaex0mqLt"},{"name":"column","children":[]{"name":"text","params":{"borderRadius"templateId":"simple paragraph","value":[{"alltype":0"paragraph","btlchildren":0,[{"bbltype":0"paragraph","btrchildren":0,[{"bbrlineHeight":0"24px","isIndividualCornerscolor":false},"padding#555":0,"gapletterSpacing":200,"verticalAlignmenttext":"center"},"idYou can add comments to your customized metric by including the # symbol.","fontFamily":"K9rNxhI4Fcp3CzSS9uSTD"}]Poppins, sans-serif","paramsfontSize":{"layout":[118}],"gapalign":100"center"},{"minHeighttype":50,"paddingparagraph":10,"borderRadiuschildren":0},"id[{"lineHeight":"r-J7n6YWF78GUTk5ZxYB224px"}],"namecolor":"section#555","idletterSpacing":"CssLKqd9YAyYgwEMgDFy7"}0,{"idfontFamily":"gdvnFnxrrUGT5HraJ1tT7Poppins, sans-serif","paramstext":{"background":{,"lightfontWeight":700,"#fffffffontSize":18}],"darkalign":"#1d2125center"},{"paddingtype":0,"gapparagraph":10},"children":[{"idlineHeight":"GsxbucKVyh3x5yh9bHmkc24px","nameletterSpacing":"row"0,"childrenfontFamily":[{"id":"Ylf6VE6SqvrIdaex0mqLt"Poppins, sans-serif","nametext":"columnSyntax ","childrenfontSize":[{18,"namecolor":"text#FF851A"}],"paramsalign":{"templateId":"simple paragraph","value":[center"},{"type":"paragraphbulleted-list","children":[{"type":"paragraphlist-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"textfontFamily":"You can add comments to your customized metric by including the # symbol.Poppins, sans-serif","fontFamilytext":"Poppins, sans-serifSELECT {metric/amount_sold} # this is a comment","fontSize":18}],"align":"center"}]},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif",","text":"","fontWeight":700,"text":"Anything after the hash sign # is ignored during computation. If you need multiline comments, each line must start with a #.","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"PoppinsOpen Sans, sans-serif","text":"Syntax "}]}]}]},"fontSizechildren":18[],"colorid":"#FF851Ay3ScFnrCpFMOObmLYulOe"}],"alignparams":{"centerborderRadius"},:{"typeall":0,"bulleted-listbtl":0,"childrenbbl":[{0,"typebtr":"list-item"0,"childrenbbr":[{0,"lineHeightisIndividualCorners":"24px"false},"colorpadding":0,"#555gap":20,"letterSpacingverticalAlignment":0"top"}},{"fontFamilyid":"Poppins, sans-serif9JL3NClLY1PKOZu2ag_TX","textname":"SELECT {metric/amount_sold} # this is a commentcolumn","fontSizechildren":18}[],"align"params":{"borderRadius":{"center"}]},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"Anything after the hash sign # is ignored during computation. If you need multiline comments, each line must start with a #.","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]}all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ArFPwwyS1gZOKRgUK_5GT","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"sUUReynsHr97_vTPM2qCV","name":"column","children":[],"id":"y3ScFnrCpFMOObmLYulOe"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"9JL3NClLY1PKOZu2ag_TX-xvsnncTJHgSrCwH-7NHg","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ArFPwwyS1gZOKRgUK_5GToOGL8u0T2br1ZQm7Obbj4","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"sUUReynsHr97_vTPM2qCV","name":"column","children":[],,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0}}],"name":"section"},{"children":[{"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0},"children":[{"children":[{"params":{"borderRadiusisMediaFullSize":{true,"allbackground":0"#0CAF9Ed1","btlgap":010,"bblimagePosition":0"center center","btrhover":0"none","bbrboxShadows":0,[{"isIndividualCornersspread":false}-3,"paddingy":0,"gapblur":2015,"verticalAlignmentcolor":"top#00000019"}},{"idy":"-xvsnncTJHgSrCwH-7NHg"4,"namecolor":"column#00000019","childrenblur":[]6,"paramsspread":{-4}],"borderRadius":{"allbbr":0,"btlisIndividualCorners":0false,"bblbtl":0,"btrall":0,"bbrbtr":0,"isIndividualCornersbbl":false0},"paddingimage":0,"gap":20,"verticalAlignment":"top"}},{"idvalue":"oOGL8u0T2br1ZQm7Obbj4att456720389","nametarget":"column_blank","childrentype":[],"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"},{"id":"2VmL424J3iN9f3haq5Sky","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":0,"gap":10},"children":[{"id":"bziklzDsTF2ubsmKuoLT1","name":"row","children":[{"id":"Smhb4xSUdxlIFEgkhA5Do","name":"column"attachment"},"padding":40,"link":{"value":"https://www.gooddata.com/docs/cloud/create-metrics/maql/","target":"_blank","type":"link"}},"name":"card","children":[{"name":"text","children":[],"params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"PLEASE NOTE:","fontFamily":"Poppins, sans-serif","color":"#f5f5f5","fontWeight":400,"fontSize":22}],"align":"center"}]}]},"id":"_rYx9iMWJUrwkHdnUH7na"},{"name":"text","children":[{],"nameparams":{"textvalue","params":[{"templateIdtype":"headline 4paragraph","valuechildren":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"To Click here to learn more about MAQL, see.","letterSpacing":0,"fontFamily":"Poppins, sans-serif","color":"#F5F5f5","fontSize":2218}],"coloralign":"#FF851A"center"}]}]}]},{"letterSpacingid":0,"fontWeightX5hkWKJKSe7OEnN7QpQsM":700},{"fontFamilyname":"Poppins, sans-serifspacer","fontSizechildren":22[],"textparams":{"space":10},{"typeid":"linkECadjya3SD4sw_uc3qeKa"}],"linkid":{"value":"https://www.gooddata.com/docs/cloud/create-metrics/maql/","target":"_blank","type":"link"},"children":[{"letterSpacing"CZTDis8vojNi-9zoJaBHg"}],"params":{"verticalAlignment":"top","gap":20,"borderRadius":{"all":0,"fontWeightbtl":7000,"textbbl":"here."0,"colorbtr":"#0091FF"0,"underlinebbr":true0,"fontFamilyisIndividualCorners":"Poppins, sans-serif","fontSize":22}]},{"textfalse},"padding":0},"name":"column","fontFamilyid":"Poppins, sans-serif","fontSize":22}],"alignMIcIC-knf7zaM8WwMq6t-"},{"name":"centercolumn"}]}]},"children":[],"idparams":{"JWDeScN11VUgsVbg3hSWppadding"}]:0,"paramsgap":{20,"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"centertop"}},{"id":"Pm2cGxHHmSMBHwDhNBgGnPHF9SfYDyNBU_dZb6FHZE"},{"name":"column","children":[],"params":{"verticalAlignment":"top","borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"Bu7B__juNtkyDU-dYPbFD",viKEWyM-LJmvrzdiJyJr-"},{"name":"column","children":[],"params":{"verticalAlignment":"top","borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20},"verticalAlignmentid":"centerxI5LaPRpDTp6GmhLRYP0y"}},{"id":"6YSOzmPSv_U-3qw6gz6tF","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"paddingverticalAlignment":0"top","gap":20,"verticalAlignmentpadding":"center"0}},{"id":"uy503YDKFCVgPlNTCW1sshO3pSGBw57H1clYJ1_1O1"},{"nameparams":{"columngap":20,"childrenpadding":[]0,"paramsverticalAlignment":{"top","borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0false}},"gapchildren":20[],"verticalAlignmentname":"centercolumn"}},{"id":"XiKLb6dNPqcZbTmB-cr7v89zDGPuVeTIZUnGdJWaax"}],"name":"columnrow","childrenid":["TiglOu7WBY6xBpWCXurgi"}],"params":{"borderRadiuspadding":{20,"allgap":010,"btlbackground":0"#ffffff"},"bblname":0,"btrsection":0,"bbrid":0,"isIndividualCornerssF8hzGtYLi8AoO1TRZi60":false},{"paddingid":0,"gap_A9myX97Ox7xCvV1PB7u9":20,"verticalAlignmentparams":{"center"}}],"paramsbackground":{"light":{"layout#ffffff":[1],"gapdark":10"#1d2125"},"minHeightpadding":500,"paddinggap":10},"borderRadiuschildren":0}}[],"name":"section"},{"params":{"background":"#ffffff#0000","padding":020,"gap":10,"image":{"value":"att456720389","target":"_blank","type":"attachment"}},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"divider","params":{"templateId":"solid short","color":"#E0A804#E6AC00","alignment":"center","fontSize":24,"fontColor":"#000000","height":3,"borderStyle":"solid","width":100},"children":[],"id":"OMJNJKIvvlbyfS-i-JlFYcPIScvl9bjNSVDmZjRDQF"},{"name":"button","params":{"templateId":"regular button","label":"Return to homepage","size":"medium","shape":"circular","alignment":"center","states":{"idle":{"colors":{"background":"#E0A804#E6AC00","label":"#F5F5F5#ffffff"}},"hover":{"colors":{}}},"link":{"value":"https://learnamp.atlassian.net/wiki/spaces/KB/overview","target":"_blank","type":"link"}},"children":[],"id":"dI04ynpg3qGtipDIucUIhIUM9y4FeuA2BUzuChIudA"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":2010,"verticalAlignment":"center"},"id":"pZ3DI27SjyQo0FJZTfJkbmpzXCwGBJLLkvPDttm0x8"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"JKa38SWxnzmLloFy4gzzWvu7rNAebatZsO9XraCxYg"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"yPWnskBJb6CaJz3jJPStn-CSpEsuk3P2R8YfttaX0L"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"6nT6258yUWFlYzIODTxSX78OWCBEkh7RJSmfKYEwtw"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Cj7qDZ1iHFUa81aWux7rrjhEHhOJOV9ZcSl4Bl3eeH"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"qITEv35EYstxAmcY3vMYzAtCq5j-4QjUTr_GWsAGX7"}],"params":{"layout":[1],"gap":1045,"minHeight":200,"padding":10,"borderRadius":0},"id":"kkq0b5SAahafEMfMThp6nJ_8J4KJ3P5cNRiCysXTMG"}],"name":"section","id":"A51-6PW_lj8tZfVDmBsFMi6ZukE-HStuy-s-cyn6NE"}]} |
|---|
|
