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
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.