Charting

Charting

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

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

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

    1. CASE WHEN DAYOFYEAR(yourdatefield) > DAYOFYEAR(DATE_SUB(CURRENT_DATE(), INTERVAL 2 day)) THEN 'Exclude'
    2. ELSE 'Include'
    3. 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.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In