The community of Analytics developers are invited to follow and participate in the developer network. OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

How to create bar chart out of pie chart? (one bar, split by x axis entries)

Essentially, I want to create a "pie chart" out of my data and display it in bar form instead of circular form. One bar, broken down into the individual entries in the x axis. The individual blocks representing each x axis entry has a length that corresponds to its y axis value.

HTML5 is the default format for charts in the OpenText commercial designer. It isn't an option in the Open Source designer which is why you don't see it.

I have attached an example. Here are the steps I took to create the single stack chart:

Create a computed column in the data set for each of the categories. My query returns 4 countries, so I added 4 computed columns, one for each country. The column expression is standard JavaScript. It sets the value to 0 unless the category and category data values match.

Add a groupBy column in the data set that sets the same string for every row. It will be used to create the single stacked bar. The data value you choose will appear as the X-axis label on the chart.

Create a chart and select "Stacked Bar" or "Percentage Stacked Bar" for the chart type.

On the Select Data tab, set the X-axis to the groupBy computed column.

Add a Y-axis series for each of the other computed columns (countries).

On the Format Chart tab, select "Series" and provide a name for each series.