/

The Line Chart—the most effective way to visualize changes and trends over time—transforms complex data into readable trend reports in seconds for all time-series scenarios, from daily active users to financial fluctuations.

Start by creating the table in the “Tables” section of the “Data Sources” module, as shown on the screen. Click the plus sign in the “Actions” section and select the “New SQL Action” button. Type the “InsertAppPerformanceStats” action, which adds sample data; when applying it, delete “AppPerformanceStats” and retype it, then press Enter. This step ensures that the correct schema name is prepended to the table name. Next, click the Test button. Repeat the same steps for the GetAppPerformanceStats action, which retrieves and filters the data.

Switch to the UI Design module and connect the GetAppPerformanceStats action to the screen using Initial Action; set the StartDate and EndDate fields to Default null. Add a Label, Line Chart, and DateRange element to the page and configure them as needed. Type “Application Metrics” into the Label element’s Value field and select Heading 2 from the Text field in the Styling panel. Connect the action to the DateRange element using Add Action and following the steps: OnChange, Custom, Managed DB, GetAppPerformanceStats; define the startValue and endValue in the StartDate and EndDate fields, respectively, via Components > DateRange1. Add the GetAppPerformanceStats action from the Line Chart’s DataSource field, and fill in the Data Label, Data Field, Data Background Color, Second Data Field, Second Data Background Color, and Third Data Field, Data Background Color fields in the appropriate order.

When you click the Preview button, you’ll be able to clearly see the trend of the data, as well as its peaks and troughs, based on the selected date range.