How to calculate slope (line_m()) from expression

[#1]

Dear All,

How can I calculate Slope for the table in the "sample.qvw"?

My alternative way is:

- I extract the data from the table "Extraction" from "sample.qvw"

- Then calculate the slope in the "Trendline.qvw"

However, I don't want to do that, I want to do it in "sample.qvw". Is it possible?

Thanks,

Dong

[Gysbert_Wassenaar]

Yeah, you can create the same line chart in the Sample.qvw document.

If you want to calculate the slope then you can use

=LINEST_M(aggr(sum(#Cust.),Month) ,match(Month,'Jan','Feb','Mar','Apr','May','Jun'))

[#3]

Your formula only works when specific province is chosen. When in the clearance mode, there is no data shown.

Could you please check again?

[Gysbert_Wassenaar]

Works fine here.

[#5]

Hi,

Can you please send me your file?

My file cannot show as below picture

[Gysbert_Wassenaar · Accepted solution]

Perhaps you're looking for this:

LINEST_M(aggr( sum(#Cust.),Month,Provinces) ,match(Month,'Jan','Feb','Mar','Apr','May','Jun'))

[#7]

That's what i am looking for.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .