-
Re: Calculate linest_b function per row
Sunny Talwar Mar 1, 2018 3:15 PM (in response to Florian Klostermeier)Is year a dimension or is it created using 5 different measures
-
Re: Calculate linest_b function per row
Florian Klostermeier Mar 1, 2018 3:25 PM (in response to Sunny Talwar )Hi Sunny,
thank you very much for your quick reply!
Actually, each column is a different variable.Variable 1: XXX_2012
Variable 2 XXX_2013
Variable 3: XXX_2014
Variable 4: XXX_2015
Variable 5: XXX_2016
(XXX stands for a variable title)
Meaning that the variable name has a decription tag followed by the year. In each row, I have the number of events.
If you look at the screenshot and take "Aalen" as an example. I want to calculate the trend between 2012 and 2016.
The x values would be 2012 - 2016, the y values would be 5, 5, 5, 7, 7.
Unfortunately, I don't want to calculate the trend using a set of rows but a set of columns, each a different variable.
Thanks and have a great evening - it' evening in Germany and I will go to bed soon.
Florian
-