| 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 salesthe count of tags associated with content:SELECT SUMCOUNT({factlabel/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}="redtags.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 learn 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":620,"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":"somxGTxgrpR_cdCYVAyIYGL7Yj2oktONIjujDwyQ7B","nameparams":{"rowbackground",:{"childrenlight":[{"id"#ffffff","dark":"45qv2BC7Ad7Z4n02vLY3U#1d2125"},"namepadding":0,"columngap":10},"children":[{"nameid":"dg5_I6vQFlS2QPULpodGa","name":"row","children":[{"id":"KXyNZjt8kkvOvBuElg0F0","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"Multidimensional Analytical Query Language, or MAQL for short, is a querying language. ","fontSize":18}]},{"type":"paragraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"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":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"","fontSize":18}]},{"type":"paragraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"Before you get started, you should know that:","fontSize":18}]},{"type":"bulleted-list","children":[{"type":"list-item"paragraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"1. Metrics always return numerical values.","fontSize":18}]},{"type":"list-itemparagraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"2. Metric can only return value based on some dimensionality/context in which it is executed.","fontSize":18}]},{"type":"list-itemparagraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"3. Metrics in MAQL start with keyword SELECT.","fontSize":18}]},{"type":"list-itemparagraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"4. A simple aggregation function looks like this:","fontSize":18}]},{"type":"list-itemparagraph","align":"leftcenter","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":16,"lineHeight":"35px","color":"#2A2A2A","text":"5. SELECT SUM({fact/quantity})"}]","fontSize":18}]},{"type":"paragraph","align":"centerleft","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":"#2A2A2A#FF851A"}],"align":"center"}]}]},"children":[],"id":"T93TUCr9mjqFiplGz0anJ"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75#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":"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":"-LNfVUJnUNZToVlOdqd5-"},{"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-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":"hDQeiPHawMMp4C0SB4oqq"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"81EMxo0HlJ2INNJMBvMUh"}],"params":{"layout":[1],"gap":100,"minHeight":20050,"padding":10,"borderRadius":0},"id":"-dbLS3nsBcYy34LQj-_NK"}],"name":"section","id":"vnFHvA2iO8ZWOlmlZWTio"},{"id":"NKrwOuBR063gaeGAZBHwJ","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":0,"gap":10},"children":[{"id":"AG5FpsyJ9IoIYEhNs73mt","name":"row","children":[{"id":"ddpEcFVJFwLjR6vei5LMb","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"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","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"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 statements.","fontFamily":"Poppins, sans-serif"}]},{""fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Example 1 - quantitycount","fontFamily":"Poppins, sans-serif","fontWeightfontSize":18,"color":700"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"The following sample uses the SUM COUNT aggregation function on a fact (quantity) to return total all-time salesthe count of tags associated with content:","fontFamily":"Poppins, sans-serif"}]},{"typefontSize":18}],"align":"center"},{"type":"bulleted-list","children":[{"type":"list-item","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"SELECT SUMCOUNT({factlabel/quantitytags.id})","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"This will result in a visualization featuring a single number, total units sold, in a single row.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"fontSizelineHeight":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Example 2 - conditioning/filtering ","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#FF851A"}],"align":"center"},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Example 2 - adding arithmeticThe following example uses the conditional statement WHERE to return a count of tasks that were completed.","fontFamily":"Poppins, sans-serif","fontWeightfontSize":70018}],"align":"center"},{"type":"paragraphbulleted-list","children":[{"fontSizetype":16,"list-item","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:SELECT COUNT ({label/tasks.id}) WHERE {label/tasks.completed}= \"true\"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]},{"type":"bulleted-listparagraph","childrenalign":[{"type":"list-item"center","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"textfontFamily":"SELECT SUM({fact/quantity} * {fact/price})","fontFamily":"Poppins, sans-serif"}]"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","children":[{"fontSize":16,"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 rowWhen 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":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"PoppinsOpen Sans, sans-serif","fontWeighttext":700""}]}]}]},{"type"children":[],"id":"paragraphe7eNnkqqYc9T_PTIU7A1n"}],"childrenparams":[{"fontSizeborderRadius":16,{"lineHeightall":0,"24pxbtl":0,"colorbbl":0,"#555btr":0,"letterSpacingbbr":0,"textisIndividualCorners":"Example 3 - conditioning/filtering and reusing metrics","fontFamily":"Poppins, sans-serif","fontWeight":700}]false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"typeid":"paragraphJrLhSN6_EZ45W7mbROzU-","childrenname":[{"fontSizecolumn":16,"lineHeightchildren":"24px"[],"colorparams":"#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":"Poppins, sans-serif"}]},{"type":"bulleted-list","children":[{"type":"list-item","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"SELECT {metric/amount_sold} WHERE {label/Color}=\"red\"","fontFamily":"Poppins, sans-serif"}]}]},{"type":"paragraph","children":[{"fontSize":16,"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"}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]},"children":[],"id":"e7eNnkqqYc9T_PTIU7A1n"}{"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":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"JrLhSN6_EZ45W7mbROzUVxeCML-lvbzhdzI8ThaRQ","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-pmUUweK_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":"VxeCML-lvbzhdzI8ThaRQZTglsFjJrRW997aIbmSn7","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"id"layout":[1],"gap":"weK_K3Eb_2V3LziIUB9ib"10,"minHeight":200,"namepadding":10,"columnborderRadius":0}}],"childrenname":[],"section"},{"params":{"borderRadiusbackground":{"all#ffffff":0,"btlpadding":0,"bblgap":010},"btrchildren":0,[{"bbrname":0"row","isIndividualCornerschildren":false},"padding[{"name":0"column","gapchildren":20,[{"verticalAlignmentname":"toptext"}},{"idparams":{"ZTglsFjJrRW997aIbmSn7value",:[{"nametype":"columnparagraph","children":[]{"type":"paragraph","paramschildren":[{"borderRadiusfontFamily":{"all":0Poppins, sans-serif","btltext":0"Add Comments to Custom Metric ","bblfontSize":022,"btrletterSpacing":0,"bbrlineHeight":0,"isIndividualCorners35px":false},"paddingcolor":0,"gap#FF851A":20}],"verticalAlignmentalign":"topcenter"}]}]},"params":{"layoutchildren":[1],"gapid":10,"minHeight"to_bsxFfehWB9Vz3sy7tR"},{"name":200,"paddingdivider":10,"borderRadiusparams":0}}],"name{"templateId":"sectionsolid short"},{"params":{"background"color":"#ffffff#FF851A","paddingalignment":0"center","gapfontSize":10}24,"childrenfontColor":[{"name#000000":,"rowheight":1,"childrenborderStyle":[{"namesolid":,"columnwidth":200},"children":[{],"nameid":"textKKt_P0E2R7mt8AS8ZBbmA"}],"params":{"valueborderRadius":[{"typeall":"paragraph"0,"childrenbtl":[{0,"typebbl":"paragraph"0,"childrenbtr":[{0,"fontFamilybbr":"Poppins0, sans-serif",isIndividualCorners"text":"Add Comments to Custom Metric ":false},"fontSizepadding":220,"letterSpacinggap":020,"lineHeightverticalAlignment":"35pxcenter"},"colorid":"#2A2A2AMTQ1X1psFknZcB8fBvJB_"}],{"alignname":"centercolumn"}]}]},"children":[],"idparams":{"to_bsxFfehWB9Vz3sy7tR"},borderRadius":{"nameall":0,"dividerbtl":0,"paramsbbl":{0,"templateIdbtr":0,"solid shortbbr":0,"colorisIndividualCorners":"#79BA75"false},"alignmentpadding":"center"0,"fontSizegap":2420,"fontColorverticalAlignment":"#000000center"},"heightid":1,"borderStyle":"solid","width":200}"Xdr_SwExHX8xojiH-p-ax"},{"name":"column","children":[],"id":"KKt_P0E2R7mt8AS8ZBbmA"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"MTQ1X1psFknZcB8fBvJB_StO-CSsKbayCJTU9wT1Sp"},{"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-axzyvcvvSeMzPyLjM2y93JL"},{"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-CSsKbayCJTU9wT1SpNI11SL9rs1uqV1BWCF0hh"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}"},"id":"K9rNxhI4Fcp3CzSS9uSTD"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"r-J7n6YWF78GUTk5ZxYB2"}],"name":"section","id":"zyvcvvSeMzPyLjM2y93JLCssLKqd9YAyYgwEMgDFy7"},{"nameid":"column","children":[]gdvnFnxrrUGT5HraJ1tT7","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":{"borderRadiustemplateId":{"allsimple paragraph":0,"btlvalue":0,[{"bbltype":0,"btrparagraph":0,"bbrchildren":0,[{"isIndividualCornerstype":false},"paddingparagraph":0,"gapchildren":20,[{"verticalAlignmentlineHeight":"center24px"},"idcolor":"K9rNxhI4Fcp3CzSS9uSTD#555"}],"paramsletterSpacing":{0,"layouttext":[1],"gap":100,"minHeight":200,"padding":10,"borderRadius":0},"id":"r-J7n6YWF78GUTk5ZxYB2"}],"name":"section","id":"CssLKqd9YAyYgwEMgDFy7"},{"id":"gdvnFnxrrUGT5HraJ1tT7","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":0,"gap":10},"children":[{"id":"GsxbucKVyh3x5yh9bHmkc","name":"row"You can add comments to your customized metric by including the # symbol.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"","fontWeight":700,"fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"idlineHeight":"Ylf6VE6SqvrIdaex0mqLt24px","nameletterSpacing":0,"fontFamily"column:"Poppins, sans-serif"children":[{"name,"text":"textSyntax ","paramsfontSize":{18,"templateIdcolor":"simple paragraph#FF851A"}],"valuealign":["center"},{"type":"paragraphbulleted-list","children":[{"type":"paragraphlist-item","children":[{"fontSize":16,[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"You can add comments to your customized metric by including the # symbol.","fontFamily":"Poppins, sans-serifSELECT {metric/amount_sold} # this is a comment","fontSize":18}],"align":"center"}]},{"type":"paragraph","children":[{"fontSizelineHeight":16"24px","lineHeightcolor":"24px#555","color"letterSpacing":0,"fontFamily":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","text":"","fontWeight":700}]}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":"PoppinsOpen Sans, sans-serif","text":"Syntax "}]}]}]},"fontWeightchildren":700}[]},{"typeid":"bulleted-listy3ScFnrCpFMOObmLYulOe"}],"childrenparams":[{"typeborderRadius":{"list-itemall":0,"childrenbtl":[{0,"fontSizebbl":160,"lineHeightbtr":0,"24pxbbr":0,"colorisIndividualCorners":false},"#555padding":0,"letterSpacinggap":020,"fontFamilyverticalAlignment":"Poppins, sans-serif","texttop"}},{"id":"SELECT {metric/amount_sold} # this is a comment"}]}]},{"type9JL3NClLY1PKOZu2ag_TX","name":"paragraphcolumn","children":[],"params":{"fontSizeborderRadius":16,{"lineHeightall":0,"24pxbtl":0,"colorbbl":0,"#555btr":0,"letterSpacingbbr":0,"fontFamilyisIndividualCorners":"Poppins, sans-serif","text":"Anything after the hash sign # is ignored during computation. If you need multiline comments, each line must start with a #."}]},{"type":"paragraphfalse},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"ArFPwwyS1gZOKRgUK_5GT","name":"column","children":[],"params":{"fontSizeborderRadius":16,{"lineHeightall":0,"24pxbtl":0,"colorbbl":0,"#555btr":0,"letterSpacingbbr":0,"fontFamilyisIndividualCorners":"Open Sans, sans-serif","textfalse},"padding":0,"gap":20,"verticalAlignment":"top"}]}]}]},"children":[],"id":"y3ScFnrCpFMOObmLYulOe"}},{"id":"sUUReynsHr97_vTPM2qCV","name":"column","children":[],"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,"isIndividualCorners":false},"padding":0},"padding":0,"gap":20,"verticalAlignment":"top"}}],"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0}}],"name":"section"},{"children":[{"params":{"layout":[1],"gap":2010,"verticalAlignmentminHeight":200,"toppadding"}}:10,{"idborderRadius":"sUUReynsHr97_vTPM2qCV"0},"namechildren":"column[{","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"}},{"id":"-xvsnncTJHgSrCwH-7NHg"y":4,"namecolor":"column#00000019","childrenblur":[]6,"paramsspread":{-4}],"borderRadius":{"allbbr":0,"isIndividualCorners":false,"btl":0,"bblall":0,"btr":0,"bbrbbl":0},"image":{"value":"att456720389","target":"_blank","isIndividualCornerstype":false"attachment"},"padding":040,"link":{"gap":20,"verticalAlignmentvalue":"https://www.gooddata.com/docs/cloud/create-metrics/maql/","target":"top_blank"}},{"idtype":"oOGL8u0T2br1ZQm7Obbj4link"}},"name":"columncard","children":[],"params":{"borderRadiusname":{"alltext":0,"btlchildren":0[],"bblparams":0,{"btrvalue":0,[{"bbrtype":0,"isIndividualCornersparagraph":false},"paddingchildren":0,[{"gaptype":20,"verticalAlignment":"top"}}]paragraph","paramschildren":[{"layouttext":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0}}],"name":"section"},{"id":"2VmL424J3iN9f3haq5Sky","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":0,"gap":10}"PLEASE NOTE:","fontFamily":"Poppins, sans-serif","color":"#f5f5f5","fontWeight":400,"fontSize":22}],"align":"center"}]}]},"id":"_rYx9iMWJUrwkHdnUH7na"},{"name":"text","children":[{],"idparams":{"bziklzDsTF2ubsmKuoLT1value",:[{"nametype":"rowparagraph","children":[{"idtype":"Smhb4xSUdxlIFEgkhA5Doparagraph","name"children":[{"type":"columnparagraph","children":[{"nametext":"textClick here to learn more about MAQL.","paramsletterSpacing":{0,"templateIdfontFamily":"headline 4Poppins, sans-serif","value":[{"type"color":"paragraph#F5F5f5","childrenfontSize":[{"type18}],"align":"paragraph"center"}]}]}]},"childrenid":["X5hkWKJKSe7OEnN7QpQsM"},{"textname":"To learn more about MAQL, see spacer","letterSpacingchildren":0[],"fontWeightparams":700,{"fontSizespace":2410},{"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,"fontSizebbl":240,"textbtr":0,"here.bbr":0,"colorisIndividualCorners":false},"#0091FFpadding":0},"underlinename":true}]},{"text"column","id":"MIcIC-knf7zaM8WwMq6t-"}],{"alignname":"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":0},"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"}]} |
|---|
|
