You poured data into a pivot table. Now what? Make them smarter. Here's how to use Summarizing Data and Calculated Fields in order to get a different perspective on your marketing data through the ...
with cte as ( select * ,(x > 2) exceeded_2 ,(0 = all(array[ x ,lag(x,1,0)over w1 ,lag(x,2,0)over w1 ] ) ) as should_switch from have window w1 as (order by n) ) ,cte2 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback