Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with these fields Symbol,Code,Value:
Symbol | Code | Value |
S1 | A1 | 110 |
S1 | A2 | 100 |
S1 | A5 | 105 |
S1 | A6 | 108 |
S2 | B3 | 120 |
S2 | B5 | 150 |
I want to show a line chart with dim="Symbol" and exp="Value/AVG", that AVG is average of value before current value. for example for symbol=S1 and Code=A5 the AVG is 105=(110+100)/2 and for Symbol=S1 and Code=A6, AVG is 105.75=(110+100+105+108)/4.
How I can do this?
Something like this?
Do you mean to have Code as your dimension?
Something like this?
Thanks. You help me alot.