Charts and Maps examples and tutorials

How do I create a stacked bar or line chart?

To create a chart, click on the Create new button in the upper right corner and choose the Chart option. Once in the editor, choose the variables that will be used to make up the graph. To the left of each variable, there is an arrow that will display editing options. The first dropdown option allows you to choose whether you want the graph to be a line chart (default Line option) or a bar chart (Bar option). If the bars option was chosen, the Absolute option can be selected, it will leave the bars side by side. On the other hand, the Stacked option makes the bars one on top of the other. The 100% Stacked option orders the bars on top of each other with an axis from 0 to 100%, this is the only option that does not support being combined with a line variable.

How do I create a multi chart?

To create a chart, click on the Create new button in the upper right corner and choose the Chart option. Once in the editor, choose the variables that will be used to make up the graph. To the left of each variable, there is an arrow that will display editing options. Below Display name there is an option that allows you to select which chart the data will be placed on. On a single chart, you can build a chart with multiple levels.

How do I create a Scatter Plot?

To create a chart, click on the Create new button in the upper right corner and choose the Chart option. Once in the editor, choose the Scatter option in the Type of chart dropdown menu. By doing so, you can choose the variables for the Y axis and the X axis, their size and color.

How do I create a country map?

To create a chart, click on the Create new button in the upper right corner and choose the Chart option. Once in the editor, make sure you have the Map tab option checked (below the Type of chart dropdown). You can create a chart with a line chart and a map, notice that in the chart viewer, in the lower left corner are the chart and map options. If you only want the map chart, uncheck the Chart tab option. Note that selecting the Map tab option opens a new tab called Map that allows you to make changes. The most important is Unmatched Entities, which allows you to match entities that have not been recognized by the editor. You can only make a map with a single variable that has data for different countries. For example, the only variable may be GDP and there are different data for the countries. It is important that the country in question is in the country field. If in the Data tab it appears as undefined, a change must be made in the entities of the dataset.

How do I create a map of provinces?

To create a chart, click on the Create new button in the upper right corner and choose the Chart option. Once in the editor, make sure you have the Map tab option checked (below the Type of chart dropdown). You can create a chart with a line chart and a map, notice that in the chart viewer, in the lower left corner are the chart and map options. If you only want the map chart, uncheck the Chart tab option.

You can only make a map with a single variable that has data for different provinces. For example, the only variable may be expenses and there are different data for the provinces. It is important that the province in question is in the entity field. If in the Data tab it appears as undefined, a change must be made in the entities of the dataset. Note that selecting the Map tab option opens a new tab called Map that allows you to make changes. In the Map dropdown you can choose the map of the country whose province data you want to show. If you want to make a map of a country that is not yet available, get in touch with customer support so that we can add it as soon as possible. Also, there is the Unmatched Entities option, which allows you to match entities that have not been recognized by the editor.

How do I create a two-axis chart?

To create a two-axis graph, touch the arrow positioned to the left of the desired variable. The variables' editor will be displayed, locate the Secondary Axis button and mark it. How do I build charts with information from other datasets?

Charts can be created with information from multiple datasets. But, if the datasets are not your own, you must follow the repository that contains them. To do this, click on the desired dataset, below the title there is a hyperlink to the repository. Once in the repository view, there is a button on the right in blue called Follow, by clicking on it you can use all the datasets of that repository to graph.

Luciano Cohan

Written by

Luciano Cohan

Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías

Related insights

  • Read more...

    Creating tables with Pipelines

    Our Pipelines feature is a powerful tool which allows report automatization. Let's say, for example, that you want to create an insight which shows dynamics of Argentina FX rates and a table with latest data, including percent changes. Wait! Did you just say "a table"!?

    **With Pipelines you can transform datasets in multiple ways (for

  • Read more...

    How can I create a Portfolio Tear-Sheet?

    Alphacast pipelines can be used to design and test portfolio and trading strategies. With the "Porfolio Analysis" Step on the pipeline editor you can create tear-sheets from daily returns and also dynamic rolling stats for different timeframes.

    image.png

    Step 1. Load the data and calculate a daily return variable.

    You can