Graph

Graphs are data visualizations that you can add to display data in an application.

Graph Settings

To use a graph widget, in addition to the default settings, you must specify one of the following types of graphs.
Type of GraphDescription
BarsBar graphs show comparison among categories vertically. Specify the following settings for a bar graph:
SettingDescription
X-axis LabelDisplayed below the graph horizontally.
Y-axis DataThe data source for the bars.
Y-axis LabelDisplayed on the left side of the bar graph.
Add All FieldsThis will add all the columns from the chosen entity. Each column can be labeled independently.
Sort BySince an entity can contain several different types of data, it is possible to sort the data depending on the data in an entity.
ColumnsColumn graphs are similar to bar graphs but are shown vertically instead of horizontally. Specify the following settings for a column graph:
SettingDescription
X-axis LabelDisplayed below the graph horizontally.
X-axis DataThe data source for the columns.
Y-axis LabelDisplayed on the left side of the graph.
Add All FieldsThis will add all the columns from the chosen entity. Each column can be labeled independently.
Sort BySince an entity can contain several different types of data, it is possible to sort the data depending on the data in an entity.
LinesLine graphs show how data changes over specific intervals of time. Specify the following settings for a line graph:
SettingDescription
X-axis LabelDisplayed below the graph horizontally.
X-axis DataThe data source for the lines.
Y-axis LabelDisplayed on the left side of the graph.
Add All FieldsThis will add all the columns from the chosen entity. Each column can be labeled independently.
Sort BySince an entity can contain several different types of data, it is possible to sort the data depending on the data in an entity.
PieIn a pie graph, rather than axis points, there is a value that can be set to a query to post data on the pie graph. Specify the following settings for a pie graph:
SettingDescription
ValueThe data source for the pie graph.
TitleThe title of the graph.
Y-axis LabelDisplayed on the left side of the bar graph.
Sort ByDepending on the data, sorting may be necessary in order to highlight certain information. Once the sort feature has been selected, it is possible to select ascending or descending order.

Possible Uses

Graphs are a way to show data visually. For example, if 50 students enrolled for a course, you can use a graph widget to show how their grades have changed over time or it may be beneficial to show what grades the students received by percent.

When you plot the data stored in the M2M Entities using a graph widget, timestamp values are displayed in the following format: hh:mm

Downloading Data from a Graph

You can download data from an entity in a Microsoft Excel worksheet using a graph widget. To do so, in the Graph Properties section, select the Allow Download check box. The download button appears in the upper-right corner of the widget in the application.

Note:
  • Downloading occurs based on the query last executed as shown in the graph.
  • If the query is executed for the specific date range using Input boxes, for example, data is downloaded based on the condition specified.
  • The entity data connected to the graph is downloaded, not the graph itself.
  • If multiple queries are connected to the graph, a separate Microsoft Excel worksheet is generated for each query, and it is downloaded in a single worksheet.
  • In the time_stamp related fields of the M2M_data　Entity, the values of milliseconds are also stored. However, only hour, minute, and second values can be displayed when you use the graph widget.