Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
davoud-jelodar
Contributor II
Contributor II

Line chart : Average value from start until value of point

I have a table with these fields Symbol,Code,Value:

 

SymbolCodeValue
S1A1110
S1A2100
S1A5105
S1A6108
S2B3120
S2B5

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?

1 Solution

Accepted Solutions
sunny_talwar

Something like this?

Capture.PNG

View solution in original post

3 Replies
sunny_talwar

Do you mean to have Code as your dimension?

sunny_talwar

Something like this?

Capture.PNG

davoud-jelodar
Contributor II
Contributor II
Author

Thanks. You help me alot.