How to get difference for 2 consecutive days when using pivot table
I want to create a dashboard that has filter condition to check the difference between current value and prior value ie. Increase> 50000000 and Increase% > 0.05. This filter condition does not seem to work.
The dashboard uses a pivot table and is based on a view created in Business schema which has the relevant variables for current value, prior value, Increase and Increase%.
prior value= if( BUSINESS_DATE= addDays( BUSINESS_DATE, -1), amount, 0 )
Can someone help me understand what mistake am I doing here?