Sparkline control

The Sparkline Control is a Chart control used to provide a graphical presentation of data but without any axes or coordinates. It only indicates variation or trends and is often a very small chart that can be used for visual presentation in line with the text. These can be line or bar charts.

Sparkline control is commonly used to show financial trends, stock market fluctuations or trends over a period, and so on.

Properties

UI properties

  • Label: Label is the text that is displayed above the container box and helps the user to understand what they are supposed to write.

  • 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 “dhq_sparkline” 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.

  • Tooltip: This allows you to add the Tooltip text that would provide a hint to the user for providing input. The Tooltip icon would be visible if you switch on the Show tooltip icon toggle property available below.

  • Description: Is the description that you can add for your controls. The Description would only be visible if you switch on the Show Description toggle property available below.

  • Submit Data: This field lets you determine whether to send the value of the control or not in Workflow based on various control states. There are three conditions that could be set for this field.

    1. Always: When this condition is selected, the data in the Control will be submitted irrespective of the state of the Control.

    2. Never: When this condition is selected, the data in the Control will never be submitted irrespective of the state of the Control.

    3. No When Hidden: When this condition is selected, the data in the Control will be submitted if the control is visible and not submitted when the control is hidden.

  • Required: When you select the required option, the field becomes a mandatory field and the user can not submit without filling it.

  • Read Only: When you select this option, the user will no longer be able to edit this field.

  • Show Tooltip Icon: This allows you to toggle switch ON or OFF to show or hide the tooltip icon where the tooltip text would appear.

  • Show Description: This allows you to toggle switch ON or OFF to show or hide the Description text.

  • Hidden: The hidden option helps you to hide the field from the user. This might help to perform some computation you don’t want the user to see or if you want to show 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 value that the LOOKUP returns will be cached and the user will be able to see this value in the field even when the user 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 field from the view.

  • Trigger Dependents: When you Disable Trigger Dependents, it helps you to reduce or optimize the unnecessary evaluation of the dependent control’s formula. For a detailed explanation refer to this article here..
    By default, Trigger dependents are enabled. However, in complex apps by switching it off, you would limit the evaluation in the dependent control and in turn ensure quicker response times.

Properties

sparkline properties

  • Graph
    • Height: Is the height of the Graph
    • Width: Is the width of the graph
    • Alignment: Specifies the alignment of the graph
    • Show tooltip: Enables you to switch ON or OFF the tooltip that displays the data at that point when clicked or mouse cursor hovers.
    • Type: Is the type of graph as line graph or bar graph.

Line Graph properties

If you have selected the type of graph as a line graph the following properties for Line graph need to be set.

  • Size: Is the size of the line
  • Color: Is the color of the line
  • Fill color: This allows you to switch ON or OFF toggle to specify whether the area under the line graph is to be colored. You can then choose the color from the custom options available.

Data points

These indicate the values mapped on the graph.

  • Color: Is the default color of the data point
  • Lower color Is the color of data point with the lowest value
  • Upper color: Is the color for data point with the maximum value
  • Radius: Is the size of the data point

Highlighted

  • Data point: Specifies enabling of the data point of the selected or highlighted on the line graph. You can further specify the color of the data point on the graph.
  • Data line: Specifies enabling of the data line to be displayed at the point selected or highlighted on the line graph. You can further specify the color of the data line.

Bar Graph properties

If you select the graph type as bar graph the following properties are to be set.

  • Width: Is the width of bars of the graph

  • Color: Is the color of the bars

  • Spacing: Is the spacing between the bar

  • Negative: Is the color of the negative values

  • Tooltip: If you have enabled the Tooltip then the following properties would be enabled.

    • Size: Is the font size of the tooltip text
    • Weight: Is the weight of the tool tip text
    • Color: Is the color of the tooltip text
    • Background color: Is the color for the tooltip box

How to Use Sparkline Control?

Start with selecting the Sparkline control from the Charts section of the Controls Menu.

The Sparkline Control will then appear on the screen in the builder, you can then set all the above properties as per your requirements.

You can use the Data option to bind data to the Sparkline Control.

  1. Static Data: This is the data that does not change over the period of time. Such data is used to assign default values in fields in your application. The static data can be based on the data type i.e. Numeric, Text, and List type data. The Sparkline control accepts an array of numbers for populating the graph.

  2. Sheets: This allows you to fetch data from a sheet and display it in the fields. Select your sheet from the list and then select the columns to be used. You can also add filters and sort data.

  3. Controls: This allows you to get data from one of the App controls.

  4. Variables: This assigns the value of the variables defined in the app.

  5. Query string: This assigns the value returned by the Query string.

  6. LoggedIn User: You can display the properties related to the LoggedIn User like username, usermail, Admin, status, and so on. You can select a single property only. Select column and click Save.

  7. Connectors: This allows you to add a Connector and select the values returned by the respective Connectors. You can select multiple keys to display values in the detail view.

  8. Custom Formula: This can be used to apply formulas and store the output of those formulas in the detail view rows. You can learn more about formulas here.

Now say you want to get a Sparkline graph for a Sales sheet, then, in that case, select the Bind data option as Sheet and then select the column to be used. Add another Text control. To this Numeric control, you can bind the Sparkline control. You would be able to get the value of the data point selected on the graph.

Preview