Hi all,
Looking to build a dashboard that only shows movement from the previous day, but I would like all selected performances to stay as a row, regardless of whether there was a sale or not. I'm been looking around and cannot find any options to retain "0". Anyone happen to know how?
Thanks!
Loccy
If Gawain's suggestion doesn't get you there, and if you have a filter limiting the results to orders dated yesterday, remove that filter and instead use a filtered value formula such as
( [Total Ticket Count] , [Days in Order Date = Yesterday] )
Thanks! That did the trick.