Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Return (Blank) after replacing data table

Hello,   I replaced a Sales data table. After replacing (loading, transforming, cleaning, formatting etc.) the Sales table seemed to work as well as the old Sales table. However when I managed the...
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

I see in your screenshot that you have applied a FILTER for 2020.

Do you have data for 2020 in both if your tables?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Pragati,

 

Thnx for your reply.

 

In both tables/columns I do have 2020 dates. 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    The relationship between 2 tables is single directional. From which table are you using your DATE filter?

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Pragati11 

       

      The all-pages filter is from my calendar table.

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        On what column have you created the relationship? DATE column in both the tables?

         

        Thanks,

        Pragati