how to show data with charts? And this data from confluence page's content.

Question

This question is in reference to Atlassian Documentation: JIRA Issues Macro

Hello. I have a question about confluence. I will describe a requirement and then explain my question.

Requirement: I have 300 companies' data, and one company's data in one page. Such as company A has location, information and so on. This data was  written on Confluence page. The company's location can be any city, such as Beijing, Shanghai.

Question: I want to show how many companies in Beijing? How many companies in Shanghai? Like those questions how to show with charts? Thanks.

Andrey Khaneev _StiltSoft_ · Answer

Hello,

You can use the following workflow:

* Add page properties macro on your pages with data you have
* On another page add Page Properties Report macro - you'll get a table with all your companies
* Wrap Page Properties Report macro with Pivot Table macro (Table Filter and Charts add-on), chose a "Location" column in Raw Labels parameter. You'll get a pivot table with count of each location.
* Wrap Pivot Table macro with Chart from Table macro to visualize your data.