Straight Table Manipulation.....Urgent Help Needed...
Hi all...Thanks in advance for answering....here goes my question....
I have a straight table chart with data,source name and no. of rows in source as dimension and average row count(=rangeavg(above(noOfRows,0,30))) as expression......But the real requirement is, I have to find the average of last 30 days no. of rows for a praticular source name.....
What I have done is will just calculate avg of 30 rows above the current row in the straight table chart........
