I have a dashboard which shows the Gasconsumption for every temperature. It is displayed in a scatter chart. The user has the option to refine the dataselection up to 4 times and compare them to eachother (by making use of comparative analysis / alternate states) So I have 4 scatter plots in total.
For every scatter-plot I want to calculate the regression line. I'm aware of the fact that I can select a "Linear Trendline" under the tab Expressions. But I want to calculate the line myself, and show it in the chart. I also have a table where some statistic data must be displayed.
I want to calculate the following values for every line:
value when x = -10 (Temperature = -10)
I know that there are Linest_m, Linest_b functions. But I dont know exactly how to apply these functions in my context. Can someone help me out? Thanks in advance!