Database Design Documentation
How can we help?
Full Site Search

Line Graph

Generating a Line Graph

You can find Reports on the right side of your listing page or create report from the tab.

The Reports tab will display reports that you have saved, and an option to create new reports in your account.

Ragic can help you to generate a line graph showing trends over time.

You can select one or more numeric field(s) to be analyzed on the vertical y-axis and choose a date field to be analyzed on the horizontal x-axis.

You can change these anytime while viewing your report. You can also save these configuration by saving your report.

Configurations for Line Graphs

Here's an example of a line graph generated in Ragic. It will be generated after clicking on the Report tab and choosing "Line Graph”. You can then configure this chart on the upper-left corner of it.

You can simply click on the drop-down menus to select the fields you want to analyze.

Let's begin with the first row of this area. Here, you can choose how to break down your data and choose to plot total or average values in the y-axis.

You can click on the left drop-down menu in this row to break down your data.

The options of the drop-down menu include the default option "all data". When this option is checked, all the uncategorized data will be shown in one single line.

The other option(s) will be the selection field(s) in the data source sheet. Take the above picture as an example, the two other options: "Name" and "Gender" are the selection fields in the "Blood Pressure Tracker" sheet. When you check "Gender" here, there will be two lines shown on the graph: one represents the data of "male", the other represents the data of "female".

The second row of this area is where you can select the fields to analyze on the y-axis. You can choose to analyze the number of records or the numeric / money fields of the source data sheet.

If you select to analyze "all data" on the first row, you'll find a "+" icon next to this menu and can click on it to add more numeric fields to analyze. For example, you can select "Systolic Blood Pressure", "Diastolic Blood Pressure" and "Heart Rate" to analyze in the same time. They will be shown as lines in three different colors.

Please note that if you already select a certain field to break down your data in the previous step, there will be no plus icon shown here, which means that you can only select a numeric field to analyze.

The third row is where you can select the time to analyze on the x-axis. All the date fields and the "Create Date" of records will be listed as options here.

You can also choose a timeframe (day, week, or month) to view your graph.

Saving your Report

If you generate the same line graph report often, you can save your report by clicking the Save as a report button that comes up on the right side when you generate a report.

Printing or Saving your Report as a PDF

You can also save as a pdf file or print your report by clicking the print icon on the right side.

If you want to hide the border of report when printing, you can click the border icon on the right side.

Viewing Saved Reports

You can find your saved reports under the Reports tab for easy access.

Filtering your Report with Views

Your report will be generated according to the filter you have applied, but you can also generate reports for a certain shared view to display results within a different filtered criteria.

If a fixed filter view is applied to your sheet, the report will display results accordingly.

Report Embed

Ragic applications provide you with a tool to embed reports on your website. Alternatively, reports can be sent as a separate link to others.

The report embed tool can be found by clicking the icon in the upper right corner on any report.

Reset Report

If you would like to reset your report, you can click on the return arrow icon to reset it.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google