• Replies 4 replies
  • Subscribers 959 subscribers
  • Views 130 views
  • Users 0 members are here
Related

Exclude Same-Day Sales

Tony Gaughan-Palombi
$organization

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  

Parents
  • $organization

    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.

Reply
  • $organization

    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.

Children
No Data