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 important, the TRAINNING TITLE. After the slicers selection, I have a table with the people who have finished the trainning and the date where they've done it.

I need to get the most recent conclusion date and compare it to the hiring date on ANOTHER table.

Is it possible?

 

Just to remember, the conclusion date is a variable! Trainning dates may vary from one area to another

Need Help

4 Replies

  • Padycosmos's avatar
    Padycosmos
    Solution Sage
    3 years ago

    Is there a common column between the two tables containing unique values? This is required to create a relationship between both the tables

    • 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)