Support Board
Date/Time: Wed, 05 Feb 2025 16:01:48 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-02 13:34:17] |
| Sawtooth - Posts: 4167 |
|
Yes, I tried the top formula on an intraday chart, but it sets the K cell to 1 in every row.
That would mean one or both of the these: 1) You need more spreadsheet rows to allow for more than one day of data (each spreadsheet row is a chart price bar). Increase the 'Number of Rows' in the spreadsheet settings. 2) You need more than one day of data to load. Increase the Chart Settings' number of 'Days to Load' to a value greater than 1. |