Support Board
Date/Time: Sat, 08 Feb 2025 15:05:28 +0000
Post From: based on slope
| [2020-07-03 17:44:55] |
| Sawtooth - Posts: 4173 |
|
You need to combine the formulas that reference each line with the AND( function, and add a condition when the other line is already sloped. =AND( OR(AND(SG1[0] > SG1[-1],SG1[-1] < SG1[-2],SG2[0]>SG2[-1]), AND(SG1[0] < SG1[-1],SG1[-1] > SG1[-2],SG2[0]<SG2[-1])), OR(AND(SG2[0] > SG2[-1],SG2[-1] < SG2[-2],SG1[0]>SG1[-1]), AND(SG2[0] < SG2[-1],SG2[-1] > SG2[-2],SG1[0]<SG2[-1]))) -where SG1 is one line, and SG2 is the other line. -you may want to separate upslope and downslope alerts to keep is simple. -if both lines are not is the same study, you'll need to include their respective ID#s. -this formula uses the Example #8 formula. Example #8 will not find any flat segments, example #9 will only find one flat segment. If there are more than one sequential flat segments, you'll need to use a modification of this formula in the Formula field of the Spreadsheet Formula study: Spreadsheet Example Formulas and Usage: Formula that Matches the Slope Coloring of a Study Subgraph Line If you want to pursue this more accurate solution, post again and I'll share the many details. Date Time Of Last Edit: 2020-07-04 03:59:39
|