Hi, I'm creating a Period Over Period card that displays number of tickets created as a week over week comparison. I'm running into an issue:
I don't want to include the current week since the results are incomplete.
Is there a better way to exlucde the data from the incomplete current period from these PoP cards?
I'm not sure how I would do that?
I tried the following with no luck:
My apologies, you're correct in saying that approach doesn't work. It seems like your data starts with a date table and then joins in the ticket responses. Would it be possible to join the date to your responses so there are no blank dates?
I'm not actually joining any data here. I'm just pulling in tickets with x= "Created Date" and Y= Count of "id". Both values are always present. Even so, my date filter is already ignoring empty dates by only pulling in data for a specified range.
The standard table is fine, it's just the "1 Week Ago" data that Domo is dynamically pulling that is suspect.
CASE WHEN CONCAT(YEAR(`Date`),WEEK(`Date`)) = CONCAT(YEAR(CURRENT_DATE()),WEEK(CURRENT_DATE())) THEN 1 ELSE 0 END
Then use this as your filter. Hopefully I'm understanding right haha!