| summary | How to do I export visualizations? In Analytical Designer, you can export your visualizations as XLSX or CSV files.Export dataOpen or create the visualization you want to export.Click the three dots in the top right corner.In Export to, select XLSX or CSV.Save the file. File TypesXLSXExport your data to an XLSX file if you want to analyze the formatted data in a spreadsheet.XLSX with Unmerged CellsBy default, visualizations that are grouped by attributes contain merged cells in the exported XLSX file.To export without merging, unselect Keep attribute cells merged in the Export to XLSX dialog. The following image shows the difference between exported data with merged and unmerged cells in the Date (Date) column. Custom Number FormatBy default, when you export visualizations to XLSX, the number formats applied to the cells containing metrics are propagated to the result XLSX file exactly as defined in the visualization.For example, if some metrics in an visualization have a number format that displays negative numbers in red and positive numbers in green, this format will be applied to the cells with these metrics in the XLSX file.NoteTo pass into XLSX any custom format as is, it’s possible to use the [excel] command in the custom metric editor followed by the static Excel custom format. For example, #,##0.00[excel][red]#,##0.00;.The command [excel] must always be the last command in the definition.CSVIf you want to process report data in more detail in another application, and do not need formatting, export the report as a CSV file. 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":"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":"att452329508","target":"_blank","type":"attachment"}},"children":[],"id":"wFyOU4MBOsm4y9WCzEVJn"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":-1,"fontFamily":"Poppins, sans-serif","lineHeight":"80px","text":"How to do I export visualizations?","color":"#79BA75","fontSize":28}],"align":"center"}]}]},"children":[],"id":"9u4aEcfNaYoEtHduYWgDQ"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":10,"verticalAlignment":"center"}},{"id":"UTk7RAYVeVxrrpj8NmYPS","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"QjlnfFkSGipQtbHLFcQlb","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"5h4A2XJxT9N8jMwBfbrBq","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_WAQ5JuNEQKXWPX","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_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":"Np0X4Y4Utxfa4yLbq0iCv","params":{"background":{"light":"#ffffff","dark":"#1d2125"},"padding":80,"gap":10},"children":[{"id":"n1si10eYCzYP3lhuiJNla","name":"row","children":[{"id":"ilUatE8_7O4dEIKxAFC70","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"In Analytical Designer, you can export your visualizations as XLSX or CSV files.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","letterSpacing":0,"text":"Export data","fontFamily":"Poppins, sans-serif","fontSize":22,"color":"#79BA75"}],"align":"center"},{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"numbered-list","children":[{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Open or create the visualization you want to export.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Click the three dots in the top right corner.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"In Export to, select XLSX or CSV.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"list-item","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"Save the file.","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"}]}]}]},"children":[],"id":"wA_OM1atfnphtE3Tg-MNv"},{"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":"att587300996","target":"_blank","type":"attachment"}},"children":[],"id":"GgWTbg9Ib1Ob759Mjl0bF"},{"name":"text","params":{"templateId":"headline and paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"File Types","letterSpacing":-1,"lineHeight":"unset","fontFamily":"Poppins, sans-serif","fontSize":22,"color":"#79BA75"}],"align":"center"},{"type":"paragraph","children":[{"text":"","lineHeight":"24px","letterSpacing":0,"color":"#79BA75","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","children":[{"lineHeight":"24px","letterSpacing":0,"text":"XLSX","color":"#79BA75","fontFamily":"Poppins, sans-serif","fontSize":18}],"align":"center"},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"Export your data to an XLSX file if you want to analyze the formatted data in a spreadsheet.","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"text":"XLSX with Unmerged Cells","color":"#79BA75","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"By default, visualizations that are grouped by attributes contain merged cells in the exported XLSX file.","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"color":"#555","text":"To export without merging, unselect Keep attribute cells merged in the Export to XLSX dialog.","fontFamily":"Poppins, sans-serif","fontSize":18}]},{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"color":"#555","fontFamily":"Poppins, sans-serif","text":""}]},{"type":"paragraph","align":"center","children":[{"fontSize":16,"lineHeight":"24px","letterSpacing":0,"color":"#555","fontFamily":"Poppins, sans-serif","text":""}]}]}]},"children":[],"id":"rnenKcarKOazdk3EeRpM1"},{"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":"att587792523","target":"_blank","type":"attachment"},"width":397,"height":222},"children":[],"id":"xfmJstzyVsddf_LEfEKnT"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"text":"","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":"The following image shows the difference between exported data with merged and unmerged cells in the Date (Date) column."}]}]}]},"children":[],"id":"KdNvrvr6wpZbyNjeYgwgY"},{"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":"att587792530","target":"_blank","type":"attachment"},"width":822,"height":231},"children":[],"id":"OjsvKLuE2ZWq4GvMPm09P"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"lineHeight":"24px","letterSpacing":0,"text":"Custom Number Format","fontFamily":"Poppins, sans-serif","fontSize":18,"color":"#79BA75"}],"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":"By default, when you export visualizations to XLSX, the number formats applied to the cells containing metrics are propagated to the result XLSX file exactly as defined in the visualization."}]},{"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":"For example, if some metrics in an visualization have a number format that displays negative numbers in red and positive numbers in green, this format will be applied to the cells with these metrics in the XLSX file."}]},{"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":"Note"}]},{"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":"To pass into XLSX any custom format as is, it’s possible to use the [excel] command in the custom metric editor followed by the static Excel custom format. For example, #,##0.00[excel][red]#,##0.00;."}]},{"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":"The command [excel] must always be the last command in the definition."}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"CSV","color":"#79BA75"}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":""}]},{"type":"paragraph","align":"center","children":[{"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Poppins, sans-serif","fontSize":18,"text":"If you want to process report data in more detail in another application, and do not need formatting, export the report as a CSV file."}]}]}]},"children":[],"id":"Hi9q0dCUyOrZOxV6jQYsJ"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"OQu6qcdqtdLom55j12ONH","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"k_HkyzsviqhxnPp1jsh2b","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"lAZ-c07Pxb5dWMPjn-aLo","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"KQxr_sKt_koYVRIDBTDuS","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"}},{"id":"dwzRaqgXF8vw1s_gTgPd3","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":"#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":"H9Mukm-wmHTkiklmSBn1i"},{"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":"nv_BrTjHHIc__SyNPfWgP"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":10,"verticalAlignment":"center"},"id":"E0XIgBiNXamcwopx5QnYD"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"ykfhPMmI6yiKiN1PnS2F1"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"7c1ouLLQuub7jexf1Kinp"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"pNfGit-oSYSsTljOOMtst"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"3iTiIBYxOXWXSiPaqT2o5"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"JiVbBSJPKYhW9txW3O-ZE"}],"params":{"layout":[1],"gap":45,"minHeight":200,"padding":10,"borderRadius":0},"id":"3uAt19jzJnxA5PYXrUyVh"}],"name":"section","id":"tDwvGqaNVT028FsIbvJDu"}]} |
|---|
|
