Eric.P Member

Comments

  • @ArborRose I tried using that logic on mine but still am not seeing proper PoP numbers CASE WHEN Time Comparison = 'YoY' THEN CASE WHEN Time Range = 'YTD' THEN SUM( CASE WHEN YEAR(event_date) = YEAR(DATE_ADD(CURRENT_DATE(), INTERVAL -1 YEAR) AND event_date <= DATE_ADD(CURRENT_DATE(), INTERVAL -1 YEAR) THEN transactions…
    in Dynamic Date Range Comparison Using Variables Comment by Eric.P July 30
  • @jrudd Yes, my fields are Country, event_date (Jan 1, 2023), revenue, and total_transactions. Do I need to extract the quarter, week and period data in my dataset?
    in Dynamic Date Range Comparison Using Variables Comment by Eric.P July 30
  • @jrudd That wouldn't be YTD though, right? You're only getting from July 15th 2023 onwards, so you're not able to compare the beginning part of the previous year to this one. I've tweaked the code some so I'm able to properly capture the YTD YoY data, but outside of that I still haven't had any luck with other periods
    in Dynamic Date Range Comparison Using Variables Comment by Eric.P July 24
  • Is there any updated link? Looks like the reference link expired and I'm also trying to build this out in my own dashboard. Thanks!
    in How to use variables for time comparison? Comment by Eric.P July 17
Default Avatar