problem to caculate aggrgeate value

[davoud-jelodar]

I have a problem to caculate aggrgeate value.

I have an inline data set that includes: date, price.

LOAD * Inline [

Date    ,Price

13961030,0.672

13961101,0.682984

13961101,0.677617

13961101,0.661068

13961102,0.597959

13961102,0.617007

13961102,0.602065

13961101,0.083422

13961101,0.083526

13961101,0.080666

13961102,0.071412

13961102,0.072685

13961102,0.070975

];

I have a line graph with dim=Date and expertion is avg(price), that trendline slope is -0.1666 but if I use this expression "LINEST_M(aggr(avg(Price), Date),Date)" that show me -0.00439.

If I remove first line of inline data, everything will be OK.(remove date=13961030 and price=0.672). I do not know why? and I do not know how to fix it?

[sunny_talwar]

When you are looking at this in your line chart, have you selected Continuous Axis?

[sunny_talwar]

Check this

[davoud-jelodar · Accepted solution]

Thanks for your attention.

selected Continuous Axis is not useful for my project. But your answer help me to understand what is my problem and now I solved it. I use an ID number for distinct Date, and I use "= LINEST_M(Aggr(avg(Price),ID),ID)" instead of "LINEST_M(aggr(avg(Price), Date),Date)".and now everything is OK.

[sunny_talwar]

Super

Thanks for sharing this. Please close the thread by marking correct and helpful responses.

Best,

Sunny