Line Chart:

A line chart is generally used to display trends over a time period. The variable that is analysed is on the X-axis and a numeric value is aggregated on the Y-axis. To analyse multiple numeric values, a Multi-line chart is used.

Steps to build a line chart using HappyFox BI:

Basic Settings

• Click on the Add Visualization button.
• Name your visualization.
• Choose Line chart from the Visualisation Type dropdown.
• Select the preferred dataset and date range for which you want to build your visualization.
• X-Axis: Fields of different data types can be chosen under X-axis:
  • Time Period fields: Time ranges like week, month are generally chosen on X-axis for a line chart. For eg, If you want to see the first response rate trend across months, then Created On- Month should be brought on X-axis here. 
  • Categorical fields: Fields like Status, priority and so on can also be chosen for X-axis.
  • Numeric Fields: If a numeric field is chosen, it needs to be grouped into buckets.
• Y-Axis: Now choose a numeric field for Y-axis. For the above example, the first response rate should be brought on the Y-axis. 
• There are different ways to aggregate the field that you choose for Y-Axis. Some options are Count, Sum, Average, Percentile, Distinct Count.    

Advanced Settings

• Benchmark: Benchmark is a special feature that allows you to compare the values against the set benchmark.
• Filter: You can choose to add the required filter conditions.
• Sort: You can also sort the visualization as required.
• Label Name: You can edit the Label (name) of your X and Y axes under the Visualisation settings tab. You can also set the Min and Max value for your axes.
• Show Values: Enable Always Show values toggle to display the bar values all the time as opposed to the values being displayed only when hovered over.
• Connect empty values: If you want the empty values to be connected on the graph to display a seamless chart, you can enable this toggle.