Support Board
Date/Time: Fri, 28 Feb 2025 13:45:51 +0000
Post From: Overlaying Pivot Points
| [2021-08-13 21:40:23] |
| Botan626 - Posts: 294 |
|
I don't see any inefficiencies, but you could remove the overlay study from the range chart.
Right, missed it. the Line draw style would work the same in your particular case
When draw style is Dash, pivots cover the whole width of corresponding bars, I changed draw style of PP to Line, you can see the difference in the attached files. To find all of today's rows we compare the max count in column K with only the latest value in column K ($K$3).
Looks like I don't need the K3 formula, since I do this: AND(INTDATE(Sheet2!$A$3)=TODAY()=INTDATE(A3)) Am I wrong? I found a drawback. The pivots on the destination chart don't update, until I press Recalculate. In the attached files in the source chart you can switch from 'Use Number Of Days To Load' to 'Use Date Range' back and forth and see, that pivots on the destination chart won't update, though values in the spreadsheet update correctly. I noticed, that calculation time for Spreadsheet Study on the source chart was e.g. 42ms and on the destination chart 34ms (visible in Studies To Graph after study name). Probably that is the reason. I removed the overlay study from the destination chart and now it updates faster, than the source chart. Do you know, how this could be resolved? Date Time Of Last Edit: 2021-08-13 21:41:53
|
 02.Cht - Attached On 2021-08-13 21:40:08 UTC - Size: 12.75 KB - 305 views Pivots.scss - Attached On 2021-08-13 21:40:18 UTC - Size: 40.24 KB - 228 views |