A line graph is commonly used to display change over time as a series of data points connected by straight line segments on two axes.

Properties

UI Properties

  • Label: Label is the text that is displayed over the control and helps the user to understand the purpose of the Line Graph Control.
  • Properties: These properties help you customize the Label by changing the text size, weight( Light, Normal, Bold, Extra Bold, X Extra Bold), alignment (Left, Center, Right, Justified) and color of the label.
  • Type: The Type field is automatically generated depending upon the type of control used. In this case, it is a “line_chart” type.
  • Unique Name: A Unique Name is used to uniquely identify a control in your App. Every control that is added on the screen gets an auto-generated Unique Name on the basis of the Label name given to the control.
  • Hidden: The hidden option helps you to hide the field from the user. This might help to perform any action or computation you do not want the user to see. You can also use it to display certain fields only when a specific condition is met/not met.
  • Caching: When the caching option is selected and if a LOOKUP formula is applied to this control, the state that the LOOKUP returns will be cached and the user will be able to see this state of the field even when he accesses the microapp later with no connectivity. This option is required when you want your app to be accessible in offLine mode as well and getting the latest data from the sheets always is not critical.
  • Hide Label: This option hides the label of the control from the view.

Properties

  • X-Axis Title: This option allows you to give a title to the X-Axis of the chart.
  • Y-Axis Title: This option allows you to give a title to the Y-Axis of the chart.
  • Chart Height: This allows you to set the height of the Line Graph. By default, the height is set to 450 px.
  • Aggregate Data: This option can be used when you need to quantify the number of certain elements using a chart. For example, if you have a list of employees with department names you want to plot graphs about how many employees are in each department you just bind the department column and aggregate it.
  • Data Values: When this option is selected you will be able to see the values corresponding to each arch next to it.
  • Legends: It is the Line of a chart that helps describe each of the parts that help make up a chart. You can enable legends by selecting this option.

How to Use Line Graph Control?

Start with selecting the Line Graph Control from the Charts section of the Controls Menu.

Line Graph Control is displayed on the screen in the builder from where the maker can now assign all the above-mentioned properties as per requirements.

Use the F option to bind data to Line Graph Control and the V option to add validations to the field. You can learn more about validations here. There are two ways in which you can bind data to the chart

  1. Sheet: The Sheets option allows you to get value from a sheet and display it in the control.
  2. Formula: Formula options can be used to apply formulas and use the output of those formulas to set the control. You can learn more about formulas here.

Preview

Line Graph with values.

You can switch on or switch off one of the value arrays by clicking on the legend of that value array.

Did this answer your question?