Report is automatically generated output from some analyses – it includes relevant statistics and information. Below an example of Report from Histogram: In some cases, like in the Seasonal adjustment Census X-13 analysis, the report will also contain information about error. As mentioned above, Report output is available only in some analyses, and these are: … Continue reading “Report”
Matrix is a type of table with numbers arranged in rows and columns. This type of presentation allows to see values or property of it. As it is visible in above screenshot, Matrix gives you possibility to highlight values according to specified conditions. It is possible to set two conditions in total. It’s worth to … Continue reading “Matrix”
Overview How to create a Fed dot plot? Examples Overview There is no dedicated chart type for this, but it’s possible to use Time chart with a bit of formulas and get a proper Fed dot plot. How to create a Fed dot plot? Set whole chart to Weekly frequency. Add on Series list: All … Continue reading “Fed dot plot / FOMC policy dot plot”
Overview How to create a Waterfall chart? Examples Overview With a little bit of arranging series you can show series as a Waterfall chart on a Category chart. How to create a Waterfall chart? On Series list add series and same amount of ‘0’ as series. Decide the order of the series on chart – … Continue reading “Waterfall chart”
Overview How to create a Spaghetti chart? Example Overview Spaghetti-like chart can be created on a Scatter chart with Show direction function. How to create a Spaghetti chart? Add Scatter chart. On Graph layout (Ctrl+L) add two series under Line chart graph type – first series will be on x-axis, second on y-axis. Click on … Continue reading “Spaghetti chart”
Overview How to create a Lollipop chart? Example Overview There is no dedicated chart type for Lollipop charts. However, with a little help of two additional analyses and graph types, you can create lollipops on Category chart. How to create a Lollipop chart? Use Scalar to perform calculations. If needed, add Sorting analysis too. Add … Continue reading “Lollipop chart”
Overview How to create a Box plot? Example Overview There is no dedicated chart type for classic Boxplot, but you can make something very similar with Category chart. Unfortunately, there is no possibility to show outliers. How to create a Box plot? Use Scalar analysis. Add Calculations: High, Low, Percentile 25, Percentile 75 and Median. … Continue reading “Box plot”
Overview How to create a simple pyramid chart? Finding data Which analysis can I use? Displaying age pyramid Examples Questions How to adjust the gap between bars? How to change size of bar/glyph? How to edit the formatting of all the values in a text column at the same time? Overview You can create Age … Continue reading “Pyramid/Demography bar chart”
This lifehack can be used to see analysis and chart side-by-side when changing settings. In the command bar of the application, you’ll see a button with a P on it – this allows you to present charts in a separate window. Besides being the first step in compiling a presentation of charts there are two … Continue reading “Opening charts in a separate window”