Displaying a selected value and the next 6 values in the series
I have a simple table with about 100k rows. The dimension is date and I just want to plot a simple line/trend chart. Specifically I want to select any row # (auto-numbered) and display it and the next x values where for now x=6. So if I pick row 101 - and it represents 10/1, the plot would plot values for 10/1 thru 10/6 only. How would I do that?
Specifically I want to select any row # (auto-numbered)
Autonumbered in the script as a field? Then you can use that field in a set analysis expression. For example if your chart has an expression sum(Amount) you can change it to sum({<DateField=, RowID={">=$(=max(RowID))<=$(=max(RowID)+6)"}>}Amount)
