Forum Discussion

Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago
Solved

Best Solution for Month to Month Analysis without Causing Duplicate Data Errors.

Hi,  I'm trying to do a month to month analysis of data that does not have unique values on the key column. Now that I have to add another month on, I've come across a snag. I can't add the data bec...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Lenihan,

     

    What I was suggesting is that with the calculated table you can get all the unique CI Identifier across all your tables.

     

    Then from tables you would create a relationship to the Calculated table.

     

    What that then means is you could then use the Calcualted Table as a filter. And it will filter all the other tables?

     

    Here is a blog post explaining how to create the Calculated Table - Connect any number of tables together via a common column

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi Lenihan,

 

What I was suggesting is that with the calculated table you can get all the unique CI Identifier across all your tables.

 

Then from tables you would create a relationship to the Calculated table.

 

What that then means is you could then use the Calcualted Table as a filter. And it will filter all the other tables?

 

Here is a blog post explaining how to create the Calculated Table - Connect any number of tables together via a common column

Lenihan's avatar
Lenihan
Icon for Helper III rankHelper III
9 years ago

Hi guavaq, 

That sounds possible to help. I'm going to start over from scratch because I've just tried so many different things, that I can no longer document what I've been doing!  I'm going to start by doing this and see what happens. Thank you for the info.