Period over Period Visual, YTD, 2 Day Delay with Current Date Data

Domomon
Domomon Member
in Charting

Hi all,

I'm leveraging the period over period charts and comparing the year to date progress with the progress from a year ago. Unfortunately, there's a two day delay in when the data comes in, and the historical period data isn't reacting to that. Is there a way to address that while still using the period over period functionality and not permanently filtering out that historical data? I know we can address this with the custom date columns/table schema, and we've done that before, but I'd love to take advantage of the native period over period functionality as our clients have grown fond of it.

image.png


Tagged:

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited April 2023

    Create a beast mode like this might work for you to exclude the prior year entries are excluded if they are from the 2 days that aren't yet in the current year data.

    CASE WHEN DAYOFYEAR(yourdatefield) > DAYOFYEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 day)) THEN 'Exclude'
    
ELSE 'Include'
    
END

    You would drag this beast mode into your filter and filter to Include.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories