Hi everyone! I seem to be stuck with trying to get advance sales numbers plotted in Analytics. I want to see sales only for future dates- so I just need to exclude same-day sales. I tried working with some formulas, but am not getting anywhere. I currently have this as a line graph, but it doesn't have to be this design. Unfortunately there is no other filter I can think to use, such as MOS. Does anyone have a handy trick for this?
Thanks in advance!
Tony
You could try it in a pivot table and use the Date Difference function.
First, add your basic filters (production season, season). Then add Order Date and Performance Date. Next, add another row, click on the “fx” button and pick use the DDIFF function using Order date and Performance date as the arguments. You should also wrap it within the MAX function to avoid it counting it multiple times.
MAX ( DDIFF ( [Days in Date] , [Days in Date1] )
Then, add a Value filter to only show DDIFF values of < 0.
In my version, it initially showed > 200k rows. Upon using the DDIFF function and filtered to < 0, it dropped the number of rows to ~ 4k.
Hi Tony,
This might be as simple as a filter on the [Performance Date].[Date] field, setting it to a Time Frame of Next 360 Days... which equates by default to tomorrow and the 359 days after that.
Best,Chris
Hi Chris, would this function the same for filtering [days in date] order date to last 360 days? When I add an order date field to the rows section, it's showing a value for today's date.
Edit the filter and click Advanced. Then change the offset from 0 to 1 and it will exclude today's date.For example, if I change it to a count of 3 with an offset of 1 and click Test, it will include the last 3 days without today's date.