Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey!!
I would like to plot the following expression:
For that I need the average of all preceding values. My dimension is a column with dates (days).
I tried: lambda*avg(L_Z1V1)+(1-lambda)*avg({1-$}L_Z1V1)
But it didn't work.
Thank you very much!!!
Eduardo
Hi.
To write iterative expressions you should use inter-record functions like above() or before() depending on the table structure.
Set analysis ({1-$}) that you've used operates with sets of data.
{1-$} means just 'all data excluded by user selection'.
Thank for your help! But I don't understand how to use above and before in this case. In my chart I want a value for each day. So for each day I need the average of L_Z1V1 (avg(L_Z1V1)) and the average of all preceding days... How can I calculate this??
Thank you very much!!!
Eduardo
Thank for your help! But I don't understand how to use above and before in this case. In my chart I want a value for each day. So for each day I need the average of L_Z1V1 (avg(L_Z1V1)) and the average of all preceding days... How can I calculate this??
Thank you very much!!!
Eduardo
Hi.
You could try something like this (similar as manual accumulation).
=rangeavg(above(Sum(Value), 0, rowno()))
Hey!
Thank you for your help! But I still have some problems... In my chart I use as dimension: "days". The thing is that I have more than one value per day. So my rangeavg(...) should take all the values preceding the day in which I am calculating.
Datum | L_Z1V1 |
2012.01.03 16:03:55 | 0,41 |
2012.01.03 20:31:43 | 0,434 |
2012.01.03 23:13:58 | 0,42 |
2012.01.04 13:56:06 | 0,431 |
2012.01.04 16:21:06 | 0,455 |
2012.01.04 22:14:28 | 0,45 |
2012.01.04 22:20:31 | 0,437 |
2012.01.04 22:26:45 | 0,448 |
2012.01.04 22:35:22 | 0,437 |
2012.01.04 23:16:09 | 0,449 |
2012.01.11 10:10:07 | 0,449 |
2012.01.11 10:37:04 | 0,422 |
For the first value rangavg should deliver 0. For the second value, rangavg should deliver the average value of all the values of 2012.01.03. I dont konw if I am explaining properly my doubt...
Thank you for your help!!
Eduardo
In this case you could use aggr() function.
But it uses loading sort-order.
You could perform the calculation in script.
At the beginning I wanted to use aggr functions. I tried 1-$ but it is not what I need... I runned out of ideas..
Thank you for your effort!!
Eduardo
There is aggr() function that you could use to iterate over all your values during a day.
While at the begining you've tried aggregation functions (avg) with set analysis expression.
Thank you very much for your time but I still don't know how to express that I want the average of the previous days...
Thank you!
Eduardo