Why is my table card cutting off some of my dates?

I have a table card showing 3 different GM numbers from different sources. Each of the sources is joined by a week_end_date. My first source updates on Sundays for the week prior, and my other two update on Thursday each week. After Thursday, I have all dates available through the end of the previous week, but from Sunday-Thursday, my table card is not including the information from my first data source. (ex. since my second and third datasets haven't updated the date range for QTD is only running through April 5th, while I have information through April 12th on my first dataset). Is this because the table card can only hand complete rows of information? I am not sure if this makes sense, but any help is appreciated.

Best Answer

  • brycec
    brycec Coach
    Answer ✓

    The table card does support incomplete or NULL data, so you have to be filtering it in a way that is removing those rows until they are filled. I'm sure I exactly understand what is going on, but it sounds like you might be filtering the date and those rows don't have those dates yet, so they would be filtered out. If not, it has to be another filter you are applying. Can you share more information?

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

Answers

  • brycec
    brycec Coach
    Answer ✓

    The table card does support incomplete or NULL data, so you have to be filtering it in a way that is removing those rows until they are filled. I'm sure I exactly understand what is going on, but it sounds like you might be filtering the date and those rows don't have those dates yet, so they would be filtered out. If not, it has to be another filter you are applying. Can you share more information?

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!