Optuma Forums › Optuma General Discussion › Twitter Charts 2 › Reply To: Twitter Charts 2
May 4, 2022 at 9:08 pm
#68097
- Topics: 70
- Replies: 790
- Posts: 860
Day of the Week formulas: https://twitter.com/Optuma/status/1520384472356560896
The DAYOFWEEK() function assigns a value to each week day, with Sundays assigned a 1, Mondays = 2, etc. As such, to mark all Fridays on a chart use DAYOFWEEK()==6 in a Show Bar. This will show all Fridays with a fall greater than 3%:
1 2 3 4 |
DAYOFWEEK()==6 and CHANGE()<-3 |