The code provided below demonstrates how to calculate the mean value for a given set of data directly within an ASP.NET application. I am seeking guidance on how to integrate this calculated mean value into a Chart control by utilizing C# in the backend of the application. I still haven’t found the solution.

 <asp:SqlDataSource ID="SqlDataSource20" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:BuyoffAndMonitoringConnectionString11 %>" 
                                SelectCommand="
                                        WITH NumberedRows AS (
                                        SELECT *, 
                                        (ROW_NUMBER() OVER (ORDER BY DateTime) - 1) / 3 AS GroupNumMean
                                         FROM [DEMUX]
                                          ),
                                 MeanValues AS (
                                         SELECT 
                                            GroupNumMean,
                                            AVG([RX1_Gap1]) AS Mean
                                            FROM NumberedRows
                                            GROUP BY GroupNumMean
                                            )
                                        SELECT 
                                            L.[DateTime],
                                            L.[Shift],
                                            L.[ID_No],
                                            L.[SN],
                                            L.[RX1_Gap1],
                                            L.[RX1_Gap1_Min],
                                            L.[RX1_Gap1_Max],
                                            L.[Result],
                                            ROUND(M.Mean, 4) AS Mean
                                            FROM NumberedRows L
                                            JOIN MeanValues M ON L.GroupNumMean = M.GroupNumMean
                                            ORDER BY L.[DateTime] DESC;"
                                        FilterExpression="Shift Like '%{0}%'">
                                 <FilterParameters>
                             <asp:ControlParameter ControlID="DropDownList14" Name="Shift" PropertyName="SelectedValue" Type="String" />
                            </FilterParameters>
                        </asp:SqlDataSource>

I have tried for the below code

if (dv != null && dv.Count > 0)
{
    DataTable dataTable = dv.ToTable();

    int numberOfValuesToShow = Convert.ToInt32(ddlNumberOfValues.SelectedValue);

    // Group the data by Mean and calculate date ranges
    var meanData = dataTable.AsEnumerable()
    .Where(row => row["Mean"] != DBNull.Value && float.TryParse(row["Mean"].ToString(), out _))
        .GroupBy(row => Convert.ToSingle(row["Mean"]))
        .Select(grp => new
        {
            Mean= grp.Key,
            StartDate = grp.Min(row => row.Field<DateTime>("TestTimeStamp")),
            EndDate = grp.Max(row => row.Field<DateTime>("TestTimeStamp"))
        })
        .Take(numberOfValuesToShow) // Only take the first 5 groups
        .ToList();

    string[] c = new string[meanData .Count];
    float[] d = new float[meanData .Count];

    for (int i = 0; i < meanData .Count; i++)
    {
        c[i] = meanData [i].StartDate.ToString(); 
        d[i] = meanData [i].Mean;
    }

    Chart8.Series[3].Points.DataBindXY(c, d); // Assuming Series[3] is for Mean
}
if (dv != null && dv.Count > 0)
{
    DataTable dataTable = dv.ToTable();

    int numberOfValuesToShow = Convert.ToInt32(ddlNumberOfValues.SelectedValue);

    // Group the data by Mean and calculate date ranges
    var cpkData = dataTable.AsEnumerable()
    .Where(row => row["Mean"] != DBNull.Value && float.TryParse(row["Mean"].ToString(), out _))
        .GroupBy(row => Convert.ToSingle(row["Mean"]))
        .Select(grp => new
        {
            Mean= grp.Key,
            StartDate = grp.Min(row => row.Field<DateTime>("TestTimeStamp")),
            EndDate = grp.Max(row => row.Field<DateTime>("TestTimeStamp"))
        })
        .Take(numberOfValuesToShow) // Only take the first 5 groups
        .ToList();

    string[] c = new string[meanData.Count];
    float[] d = new float[meanData.Count];

    for (int i = 0; i < meanData .Count; i++)
    {
        c[i] = meanData [i].StartDate.ToString(); // or cpkData[i].EndDate.ToString() depending on your requirement
        d[i] = meanData [i].Mean;
    }

    Chart8.Series[3].Points.DataBindXY(c, d); // Assuming Series[3] is for Mean
}