Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table value as a filter

Hello everyone!   I have a problem to solve, but I have no idea on how to do this!   Here's the situation:   I have a report with a lot of slicers, like COMPANY AREAS, POSITION and, the most im...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Padycosmos, thank you for your time!

 

Unfortunately, this database is a mess... I have a many to many relationship. Is it possible to work around this situation?

 

I was trying to save something like a "snapshot" of a card value to another table and use it as a filter... but I wasn't able to store it as a variable. When I did that, I got a table with the latest date for every colaborator, not a single one for all of them.

Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

I am quite skeptical about many to many relationships. It would be a good idea to create a table with Training ID ( containing unique values), Training Name and link it to both the tables)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your support.

     

    I solved the situation with a copy of the TRAINNING table, sorting by the first conclusion date, removing duplicates.

     

    After that, applied a formula to change the value according to the rule of hiring date and then, created the relationship.

     

    Again, thank you for the support and the ideas