Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
When you are looking at this in your line chart, have you selected Continuous Axis?
Check this
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.
Super
Thanks for sharing this. Please close the thread by marking correct and helpful responses.
Best,
Sunny