Chart By Numeric X

The "Chart By Numeric X" dashboard widget is a powerful tool that visualizes charts with numeric values on both the X and Y axes.

Overview

The "Chart By Numeric X" dashboard widget is a powerful tool that visualizes charts with numeric values on both the X and Y axes. This versatile widget not only displays precise and clear charts but also has the capability to perform R-squared prediction if needed, making it an ideal choice for advanced data analysis and visualization. With its robust features and intuitive design, the "Chart By Numeric X" widget is perfect for uncovering insights and trends in numeric data.

R-squared

In statistics, the coefficient of determination, abbreviated as R2 or R2 and pronounced "R squared", represents the proportion of variation in the dependent variable that can be predicted from the variation in the independent variable.

"Scatter with fit" is a tool that allows you to generate the best fit for the scatters. You will be able to see the best fit line as well as the formula on the screen.

Use case

• Visualizing scientific data,

• Displaying performance metrics,

• Predicting continuous outcomes

Configuration

This widget requires two columns to be configured: a Number or Formula widget for the X axis that returns a numeric value, and a Number or Formula widget for the Y axis that also returns a numeric value. To set this up, click the Edit button to configure the widget and define the X and Y axes with the required numeric values.

• Table - Select a table to update the filter dropdown.

• Filter - You can specify a filter to limit the results. The default setting will use the complete data set if the filter is not specified.

• X axis - Choose a column for the X axis.

• Series - Choose one or more columns for the data series. Number or Formula widgets must be used in the column.

• Data aggregation - Data aggregation is the process where raw data is gathered and expressed in a summary form.

  • None

  • Average

  • Max

  • Median

  • Min

• Chart title - Please provide the title of the chart.

• Height - Chart height in px. Default to 250px.

Interface

The widget displays the scatter chart with a filtering method for the numeric columns selected for the x-axis and y-axis. You have the flexibility to change to other chart types as needed. Additionally, there is a Download button that allows you to download the source data. This feature provides a quick and easy way to extract the dataset you are currently working with for further analysis or record