Getting Forecasting error while generating trend line chart series in ASP.NET

Question

Getting Forecasting error while generating trend line chart series in ASP.NET

BeUnique 2,332

I am trying to pull Trend Line chart in my application. I tried many ways to bring the Trend Line chart. But, Got Failed.

I tried the below code to bring Trend Line chart. But, I am getting Error.

If the below error solved, then my trend line chart working which is using in-build asp.net control.

Also, if the error clears, then i am going to use this Trend Line Chart many places inside my application.

Can anyone help us to bring this chart without any problem in my application....?

below id error :

Forecasting Error - There are two data points for this regression type. A minimum of 2 data points are required.

Chart1.DataManipulator.FinancialFormula(FinancialFormula.Forecasting,"Linear,1,false,false",chart1.Series[0], Chart1.Series["TrendLineSeries"]);

below is code

<asp:Chart ID="Chart1" runat="server">
<Series>
<asp:Series Name="Series1" ChartArea="ChartArea1" XValueType="Int32" ChartType="FastPoint" YValuesPerPoint="2" Color="Red" IsVisibleInLegend="true" IsXValueIndexed="true"></asp:Series>
<asp:Series BorderWidth="1" Name="TrendLineSeries" ChartType="Line" BorderColor="Blue"></asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
<AxisX Title="Weight" Crossing="Auto"></AxisX>
<AxisY Title="Price (Euro)"></AxisY>
</asp:ChartArea>
</ChartAreas>
</asp:Chart>

BeUnique 2,332 Reputation points

2022-03-10T10:59:20.62+00:00

Any one can update this..

This is urgent requirement in our projects...

Accepted answer

0 additional answers

Your answer

BeUnique 2,332 Reputation points

2022-03-10T10:59:20.62+00:00

Any one can update this..

This is urgent requirement in our projects...

Answer 1

Yijing Sun-MSFT 7,096

Hi @BeUnique ,
First, the syntax of the predict function is:

Chart1.DataManipulator.FinancialFormula (FinancialFormula.Forecasting, "1,40,true,true", "Series1:Y", "Series2:Y,Series3:Y,Series3:Y2");

And then, I need you check if you have more than 2 data points in your binding. If you make sure that you have bind more than 2 data points, you need to move the Financial Formula code below where the data is bound.

Best regards,
Yijing Sun

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our  documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.

BeUnique 2,332 Reputation points

2022-03-11T06:53:31.76+00:00

I am struggling to get the Trendline chart past one week. we tried many ways. but, no proper solution for this chart.

We are using two series to get the trendline chart. But, it is failed.

below is our data.

can you give us the working code to enable the trendline chart with the above sample data.

pls. give more assitance to close this issue.

BeUnique 2,332

Getting error in the below line.

below is the complete code

protected void Button1_Click(object sender, EventArgs e)  
{  
	DataSet dataSet = GetDataSet();  
            if (dataSet != null)  
            {  
                 Chart1.DataSource = GetDataSet();  
                 Chart1.DataManipulator.IsStartFromFirst = true ;  
  
                Chart1.DataManipulator.FinancialFormula(FinancialFormula.Forecasting, "1,40,true,true", "Series1:Y", "Series2:Y,Series3:Y,Series3:Y2");  
  
                Chart1.DataBind();  
            }  
}  
  
  
 private DataSet GetDataSet()  
        {  
            SqlConnection connection = new SqlConnection(Conn);  
            SqlDataAdapter adapter = new SqlDataAdapter("select Kilogram, Price   from tableMeasure", connection);  
            DataSet dataSet = new DataSet();  
            connection.Open();  
            adapter.Fill(dataSet);  
            connection.Close();  
        }

Yijing Sun-MSFT 7,096 Reputation points

2022-03-11T09:03:05.22+00:00

Hi @BeUnique ,
You need to change the value for "Series1:Y", "Series2:Y,Series3:Y,Series3:Y2" using your data in your binding.
Best regards,
Yijing Sun
BeUnique 2,332 Reputation points

2022-03-11T09:19:26.09+00:00

Thanks for your reply.

But, I don't understand where want to change in my code. Because, whatever you mentioned same thing will be there in my code..

You need to change the value for "Series1:Y", "Series2:Y,Series3:Y,Series3:Y2" using your data in your binding.

below is the same.

Chart1.DataManipulator.FinancialFormula(FinancialFormula.Forecasting, "1,40,true,true", "Series1:Y", "Series2:Y,Series3:Y,Series3:Y2");

pls. give us the correct code to move forward for this issue.

Still struggling...
Yijing Sun-MSFT 7,096 Reputation points

2022-03-14T02:48:49.08+00:00
Hi @BeUnique ,
You have post the codes on the first thread. You need bind data on chart1.Series[0] and Chart1.Series["TrendLineSeries"].

Chart1.DataManipulator.FinancialFormula(FinancialFormula.Forecasting,"1,40,true,true",chart1.Series[0], Chart1.Series["TrendLineSeries"]);

Best regards,
Yijing Sun
BeUnique 2,332 Reputation points

2022-03-14T04:25:56.16+00:00

can you pls. update my queries and error..?
Yijing Sun-MSFT 7,096 Reputation points

2022-03-14T06:56:13.233+00:00

Hi @BeUnique ,
Now,your problem is binding data. Right? Don't you bind data？You have used dataset on above.
Best regards,
Yijing Sun
BeUnique 2,332 Reputation points

2022-03-14T13:03:47.793+00:00

can you pls. updated and working code...?
Yijing Sun-MSFT 7,096 Reputation points

2022-03-15T02:51:42.42+00:00

Hi @BeUnique ,
If you have errors with your codes,you could post to us.More experts will help you.
BeUnique 2,332 Reputation points

2022-03-15T04:35:39.167+00:00

can you pls. updated and working code...?

Share via

Getting Forecasting error while generating trend line chart series in ASP.NET

0 additional answers

Your answer