Gross Sales as of Yesterday

You just need to use Filtered Values to subtract the revenue amount for order date = Today from the total revenue.


This example basically says give me the:

1. Total Ticket Paid Amount filtered to a specific perf date, Performance not containing specific text, and in a specific production season.
2. Subtract the Total Ticket Paid Amount with orders with today's date with the same exact filters.
   
   (sum([Total Ticket Paid Amount]),[Perf Date 3/16/24],[Performance <> Comp/Will Call],[Production Season = ZAHFY24])
   -
   (sum([Total Ticket Paid Amount]),[Perf Date 3/16/24],[Performance <> Comp/Will Call],[Production Season = ZAHFY24],[Order Date = Today])

You just need to use Filtered Values to subtract the revenue amount for order date = Today from the total revenue.


This example basically says give me the:

1. Total Ticket Paid Amount filtered to a specific perf date, Performance not containing specific text, and in a specific production season.
2. Subtract the Total Ticket Paid Amount with orders with today's date with the same exact filters.
   
   (sum([Total Ticket Paid Amount]),[Perf Date 3/16/24],[Performance <> Comp/Will Call],[Production Season = ZAHFY24])
   -
   (sum([Total Ticket Paid Amount]),[Perf Date 3/16/24],[Performance <> Comp/Will Call],[Production Season = ZAHFY24],[Order Date = Today])

To be a bit clearer, you put these on Value within the Formula level (not the widget or dashboard level). It is how you add filters on the formula level. In my example, if the total sales was $1,000 and we sold $100 after midnight (order date = Today) on our website (before the nightly Analytics load), it would display $900.