To visualize and analyze rankings, trends, or proportions of items in your records, you can use bar charts in Ragic reports. For example, you can compare sales data, track quarterly sales trends, or examine the proportion of each department’s expenses relative to the total.
Note: If you don't see any report options on your sheets, it may be related to your report access rights. For issues with viewing or generating reports, please contact your SYSAdmin to check and adjust the access rights configuration.
In addition to viewing saved reports created by your SYSAdmin in the Reports tab, you can also generate your own reports.
After generating the Bar Chart, the following page will appear. The settings for the bar chart are explained below:
At the top left, select the type of bar chart. Currently, there are three types available, which can be presented in either "Vertical" or "Horizontal" format:
(1) Clustered Bar Chart: Used for comparing data across multiple categories.
(2) Stacked Bar Chart: Used for comparing parts of a whole.
(3) 100% Stacked Bar Chart: Used for comparing the percentage each data contributes to the total.
You can select the # of records or Numeric/Money fields from the sheet.
Select the "Primary Category" and "Secondary Category" fields, as well as the sorting method for each category.
After selecting the two category fields, the bar chart report will be displayed below. Hover over the bar chart to view the actual values or percentages for each item.
If you wish to analyze only one field, you can select the same field for both category fields.
Choose the item from the "Secondary Category" field, and then you can customize the bar chart colors for it.
(1) Hide data with 0 values: Check this option to hide data with zero values.
(2) Show data table: Check this option to display a table below with the actual values or percentages from the sheet.
You can use the Printer Friendly or Download as PDF option to export reports.
When your sheet has Shared Views or the Fixed Filter applied, you can filter the report based on those views.
You can embed the report into your website or share a link with others.
You can adjust the report’s style settings, including font, font size, boundaries, etc.