Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Appanvil karma designer
summary How to do I sort 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},"image":{"value":"att452329508You can use sorting to order the data in your visualization. To configure sorting, click the sorting icon on the filter bar: To sort the data, you must slice your data with at least one attribute. Sorting is available for:bar chartscolumn chartsarea chartscombo chartsbullet chartspie chartsdonut chartsheatmapsYou can sort data:AlphabeticallyNumericallyChronologically Sorting methods Alphabetical sorting You can sort the data alphabetically from A to Z, or vice versa. The data is sorted using the attribute values. Numerical sorting You can sort the data numerically from the smallest number to the largest, or vice versa. The data is sorted using the metric values.If the visualization contains multiple metrics, select the metric you want to use for sortingIf you select Total, the data is sorted by the sum of all metric values. Chronological Sorting If you add a date attribute, you can sort your data chronologically from the oldest to the newest, or vice versa. The data is sorted using the date attribute values.Note: You must group the data by Day, Week, Month, Quarter, or Year. Other groupings, such as day of week or month of quarter, do not support chronological sorting. Mixed Sorting If you slice your data by multiple attributes, you can use different type of sorting for each attribute.Note: If you select numerical sorting for the first attribute, the data is always sorted by the total sum of all metrics for each attribtue value.In the following example, the Average number of checks with desserts and Average number of checks with entrees are sliced by Date (Year) and Location City.For Date (Year), the data is sorted numerically from smallest to largest by the sum of all metricsFor Location City, the data is sorted alphabetically. Return to homepage
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":"wFyOU4MBOsm4y9WCzEVJnmrVzFPzSxpE1I0rajsC1u"},{"name":"textrow","paramschildren":[{"valueid":[{"type"1cCQXDL6jDSJctZpqsjIS","name":"paragraphcolumn","children":[{"typename":"paragraphimage","childrenparams":[{"letterSpacingtemplateId":-1"square","fontFamilyalignment":"Poppins, sans-serifcenter","lineHeightwidth":"80px","text":"How to sort visualizations?","color":"#79BA75","fontSize":28}],"align":"center"}]}]},"children":[],"id":"9u4aEcfNaYoEtHduYWgDQ"}],"params":{"100,"height":100,"position":"center center","borderRadius":{"all":0,"btlbbl":0,"bblbbr":0,"btrbtl":0,"bbrbtr":0,"isIndividualCorners":false},"paddingimage":0,{"gapvalue":10"att452329508","verticalAlignmenttarget":"center_blank"}},{"idtype":"UTk7RAYVeVxrrpj8NmYPS"attachment"}},"children":[],"nameid":"columnwFyOU4MBOsm4y9WCzEVJn"},{"childrenname":[]"text","params":{"borderRadiusvalue":[{"alltype":0"paragraph","btlchildren":0,[{"bbltype":0,"btrparagraph":0,"bbrchildren":0,[{"isIndividualCornersletterSpacing":false}-1,"paddingfontFamily":0,"gap":20"Poppins, sans-serif","verticalAlignmentlineHeight":"center80px"}},{"idtext":"QjlnfFkSGipQtbHLFcQlbHow do I sort visualizations?","namecolor":"column"#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"column","minHeightchildren":200[],"paddingparams":10,{"borderRadius":{"all":0}}],"namebtl":0,"section"}]}

You can use sorting to order the data in your visualization. To configure sorting, click the sorting icon on the filter bar:

sort buttonImage Removed

To sort the data, you must slice your data with at least one attribute.

Sorting is available for:

  • bar charts

  • column charts

  • area charts

  • combo charts

  • bullet charts

  • pie charts

  • donut charts

  • heatmaps

You can sort data:

  • Alphabetically

  • Numerically

  • Chronologically

Alphabetical Sorting

You can sort the data alphabetically from A to Z, or vice versa. The data is sorted using the attribute values.

sort alphabeticallyImage Removed

Numerical Sorting

You can sort the data numerically from the smallest number to the largest, or vice versa. The data is sorted using the metric values.

If the visualization contains multiple metrics, select the metric you want to use for sorting

If you select Total, the data is sorted by the sum of all metric values.

sort alphabeticallyImage Removed

Chronological Sorting

If you add a date attribute, you can sort your data chronologically from the oldest to the newest, or vice versa. The data is sorted using the date attribute values.

Note

You must group the data by Day, Week, Month, Quarter, or Year. Other groupings, such as day of week or month of quarter, do not support chronological sorting.

sort alphabeticallyImage Removed

Mixed Sorting

If you slice your data by multiple attributes, you can use different type of sorting for each attribute.

Note

If you select numerical sorting for the first attribute, the data is always sorted by the total sum of all metrics for each attribtue value.

In the following example, the Average number of checks with desserts and Average number of checks with entrees are sliced by Date (Year) and Location City.

  • For Date (Year), the data is sorted numerically from smallest to largest by the sum of all metrics

  • For Location City, the data is sorted alphabetically.

...

bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"JPQqpTkQOlpB_6winUeTy","name":"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":"hLZMr9Jd4GrU5IHs8bh0G","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":23,"gap":10},"children":[{"id":"F42DjGP8ghmjw93qKRvTB","name":"row","children":[{"id":"rMIAuHf7i54iCQNyy-Wle","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 use sorting to order the data in your visualization. To configure sorting, click the sorting icon on the filter bar:","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":""}]}]}]},"children":[],"id":"CuMhS9oT3yq3Vbl8lIFlI"},{"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":"att588775439","target":"_blank","type":"attachment"},"width":585,"height":86},"children":[],"id":"qpon3XfYI4S5DkT3pn0cl"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"To sort the data, you must slice your data with at least one attribute. ","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":"Sorting is available for:"}]},{"type":"numbered-list","children":[{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"bar charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"column charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"area charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"combo charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"bullet charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"pie charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"donut charts"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"heatmaps"}]}]},{"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":"You can sort data:"}]},{"type":"numbered-list","children":[{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"Alphabetically"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"Numerically"}]},{"type":"list-item","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"Chronologically"}]}]}]}]},"children":[],"id":"_kWkvVZAIWSS5CiztHHNb"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"yLCBnZI2VWYqoFn9zfzwy","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"o9Uz4bhpqGOHa4PNBl9cC","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"7pDl_prqILqrmBBd2YzBj","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"l8MWCvM-evR3iQiF-Yini","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"gGHPhAYF7iBM9qJojyDLq","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":"Sorting methods","fontSize":22,"letterSpacing":0,"lineHeight":"35px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"8dPC65N-pzasxNU2viRcl"},{"name":"divider","params":{"templateId":"solid short","color":"#79BA75","alignment":"center","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid","width":200},"children":[],"id":"62qWrgcKgycQFBtEujzDJ"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"uEqpq-zGsdqWCquJXL5xo"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"i0y1PfAORmyVB480bKDsb"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"xSW3eeWJyak62yOCWR3x9"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"AkgDKxO3S_vC2TnVmImdu"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"vVyX6kFsGMhmzD2q3rtM6"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"ccnqVVbHMbpc2HMdh-iZh"}],"params":{"layout":[1],"gap":100,"minHeight":50,"padding":10,"borderRadius":0},"id":"8tHf8zQoPeXfJCChyoflH"}],"name":"section","id":"-oHG3zEN3o1JRhqFNu_5A"},{"params":{"background":"#ffffff","padding":20,"gap":80},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"image","params":{"templateId":"full-width","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588447795","target":"_blank","type":"attachment"}},"children":[],"id":"K8uQFKiKg1dLXkO7fXFpK"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"l2tONza4LyvPEOWG1yCPs"},{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"Alphabetical sorting","fontFamily":"Poppins, sans-serif","fontSize":18,"lineHeight":"50px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"AqDhxoh7j5xNytkpzecys"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"You can sort the data alphabetically from A to Z, or vice versa. The data is sorted using the attribute values.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","lineHeight":"unset"}],"align":"center"}]}]},"children":[],"id":"qxLpHB9nbzoDWl-psYawh"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"_74nN_3ey2udjFDh7J06b"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"wvRKru_yy67ZlDDc74VBQ"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"vP8J6dbXfRinjiovotodm"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"CPFPB4heOJ4yogorL2uZr"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"QhULq6FCax8GwfmVjaZ-R"}],"params":{"layout":[1,1],"gap":65,"minHeight":200,"padding":10,"borderRadius":0},"id":"Ei4wwypz1wEGgn8CuP7kH"},{"name":"row","children":[{"name":"column","children":[{"name":"divider","params":{"color":"#dadada","alignment":"start","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid"},"children":[],"id":"pRU5RvOfihIStFu4wkYb7"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"N7MnpV_HHGYF0LJdU-yxI"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"uvx1pT5v0SMrKSOirMrk1"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"dXsc7yYkb_tZmXBhEYvSm"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"ljpVL3SmN3RyqSLnXKBih"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"xr7oEvKztr8Tn2gduYuJ7"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"PaNU015fOCVwkBd_YQH82"}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0},"id":"8PoAZJgsi0kZhqiorAPZP"},{"name":"row","children":[{"name":"column","children":[{"name":"image","params":{"templateId":"full-width","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588218432","target":"_blank","type":"attachment"}},"children":[],"id":"oV40smK1N-PEZlGI3eQFm"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"JX3ZuuyYvCpd_1a-RVtNo"},{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"Numerical sorting","fontFamily":"Poppins, sans-serif","fontSize":18,"lineHeight":"50px","color":"#79BA75"}],"align":"center"}]}]}]},"children":[],"id":"Kh2yjZYYkPfmoBzBqnEN3"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"You can sort the data numerically from the smallest number to the largest, or vice versa. The data is sorted using the metric values.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","lineHeight":"unset"}],"align":"center"},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"If the visualization contains multiple metrics, select the metric you want to use for sorting","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"If you select Total, the data is sorted by the sum of all metric values.","lineHeight":"unset"}]}]}]},"children":[],"id":"JU4U3jSv3LyvJ5K106ruz"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"OIvzwWcaG95GDsMSwS2hL"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Fx464twRpejP2mTnmBxoA"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"rACUbw-mR1i6Oa9mRE2k0"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"uh1BIZNv9xG0Kt7yn3ZAL"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"mTvskxXOPbx__e5DgKhd4"}],"params":{"layout":[1,1],"gap":65,"minHeight":200,"padding":10,"borderRadius":0},"id":"sLcyCOJVeKC5IhUb-DaZ4"},{"name":"row","children":[{"name":"column","children":[{"name":"divider","params":{"color":"#dadada","alignment":"start","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid"},"children":[],"id":"lMkU4pqdHEgSmvyis4Zsq"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"gGdAQZYuE_8zRMtgix3RI"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"aek9o6OrxMBqxhHW15zgn"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"rAWGXPai4QrFllwXAV8z7"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"bg3TLI5FvozrtxwIaPuOY"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"dWV-mspp_y02CNtTWQte3"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Rf7Q_jcqPFwcWSl2BSruU"}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0},"id":"4Y8A37dtKesMEGDFyecyy"},{"name":"row","children":[{"name":"column","children":[{"name":"image","params":{"templateId":"full-width","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588316704","target":"_blank","type":"attachment"}},"children":[],"id":"ctQxKijRuZlmkv31CDkXb"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"SgyL6LXHmLm5gux4r8yXj"},{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"Chronological Sorting","fontFamily":"Poppins, sans-serif","fontSize":18,"lineHeight":"50px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"MvG89rOpQGN8Itu1AbwiI"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"If you add a date attribute, you can sort your data chronologically from the oldest to the newest, or vice versa. The data is sorted using the date attribute values.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","lineHeight":"unset"}],"align":"center"},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"Note: You must group the data by Day, Week, Month, Quarter, or Year. Other groupings, such as day of week or month of quarter, do not support chronological sorting.","lineHeight":"unset"}]}]}]},"children":[],"id":"Gh8AS4DVWUoIagdRQNzyY"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"BB9r5gTdvEvKRv1a2s1Mx"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"21euCURIlhBnpBaiRe684"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"C5ousIo-pdGc0QYkECe9j"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"yblQ5jQzJ7d7mecqJyyOc"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"-2z9OteiDaZ3P_6kGrxs9"}],"params":{"layout":[1,1],"gap":65,"minHeight":200,"padding":10,"borderRadius":0},"id":"2-W2IkVXMVJ_sPMYAejza"}],"name":"section","id":"qf6_yoqDsye6JBzvuOW3U"},{"params":{"background":"#ffffff","padding":20,"gap":80},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"divider","params":{"color":"#dadada","alignment":"start","fontSize":24,"fontColor":"#000000","height":1,"borderStyle":"solid"},"children":[],"id":"9y918cUpntQhyfl_tktj4"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"f6eRvtyvhJOd0qOnbHB2t"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"Pu2d71VdUiQGsjzrkMp1q"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"NIxFv5vXBSkn5wYrpC15C"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"FrGxh0v-_BCx9EwW7hheg"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"e_Bp77tOOhyVKrdcqzGy1"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"eErDi-Kvl9AULsQQqnAqZ"}],"params":{"layout":[1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0},"id":"DROQJ_XZvNoddYCgAbSkk"},{"name":"row","children":[{"name":"column","children":[{"name":"image","params":{"templateId":"full-width","alignment":"center","position":"center center","borderRadius":{"all":20,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att588415010","target":"_blank","type":"attachment"}},"children":[],"id":"tZoI5s5E60609iVg8c1F4"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"qaEN9LRAmcjRJP-1FJtgc"},{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"Mixed Sorting","fontFamily":"Poppins, sans-serif","fontSize":18,"lineHeight":"50px","color":"#79BA75"}],"align":"center"}]}]},"children":[],"id":"WDu5bu1KVC7Pl1pDIKJU1"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"If you slice your data by multiple attributes, you can use different type of sorting for each attribute.","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","lineHeight":"unset"}],"align":"center"},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"Note: If you select numerical sorting for the first attribute, the data is always sorted by the total sum of all metrics for each attribtue value.","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"In the following example, the Average number of checks with desserts and Average number of checks with entrees are sliced by Date (Year) and Location City.","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"For Date (Year), the data is sorted numerically from smallest to largest by the sum of all metrics","lineHeight":"unset"}]},{"type":"paragraph","align":"center","children":[{"letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#2A2A2A","text":"For Location City, the data is sorted alphabetically.","lineHeight":"unset"}]}]}]},"children":[],"id":"qiuecLyPkvH7-NXtU31kO"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"_jdy-goFZlYqSEcjvdyQP"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"2Lev1wKqFeSTa2Akfjv6j"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"m6E9RIoqClpHp1SrR52MJ"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"_ScRqdk9HrHWvuRJ0NIes"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"bDMvXR1kvmD2lmZ21JLzE"}],"params":{"layout":[1,1],"gap":65,"minHeight":200,"padding":10,"borderRadius":0},"id":"Z_brlP4vJ6Q-xT-bpnY9V"},{"id":"VUXLcPsTe4RjhgT4yWgJY","name":"row","children":[{"id":"iLpg7gV9O5_dcgJMrffF_","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"GwlNoFQATV52hrtfRvtyf","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"e942vTpycpU9S7oJfPtFs","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"bfSDfmfNZV69amTM8ftbj","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"71M7CxsPzPEaRkCdLnUoe","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"R5ACF5ZGErYA4-xcGq3uV","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,1,1],"gap":10,"minHeight":50,"padding":10,"borderRadius":0}}],"name":"section","id":"D9HbHlO4jEliP6cgf_FUI"},{"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":"

...

bjbuO7LvtAsvIBFNWIl3c"},{"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":"

...

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

...

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

...

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

...

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

...

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

...

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

...

GEoF-oNU0pcVX9OqGsE_

...

d"}],"params":{"layout":[1],"gap":45,"minHeight":200,"padding":10,"borderRadius":0},"id":"

...

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

...

dQ08e6AhyflckDV8X2xse"}]

...

}