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

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

Thought of a possibly solution.. but hoping there is something better.

 

I could concatenate the CI identifier field with the Month Field.  This would give me a unique value each month for the CIs - but, this would mean I'd have to do that for every table (create a concatenate field) else I wouldn't be able to use it for the relationships. (Hopefully this helps explain what I'm trying to do)