Forum Discussion

jellyjoe's avatar
jellyjoe
Helper I
5 years ago
Solved

Issue with creating a table visual from related tables.

Hello,   I have an issue with creating a relationship between three tables. First let me introduce you to the data model. We have 3 tables: (Please note Primary keys are used for something e...
Need Help
Kumail's avatar
Kumail
Impactful Individual
5 years ago

jellyjoe May be you can share that from google drive.

  • Kumail's avatar
    Kumail
    Impactful Individual
    5 years ago

    Hello jellyjoe 

     

    There are a few questions;

    -What is the key to relate records between tables 'dbo.Conv_Stops' and 'dbo.MC_Stops'? If we take "Line+ConveyorConnection" then it is common between all the records in both tables.

    -Is this logic correct for ConvStopCausedByMachine?

     

     

    Regards

    Kumail Raza

    • jellyjoe's avatar
      jellyjoe
      Helper I
      5 years ago

      Hello Kumail 

      The key is Line+Conveyor connector and Machine which are matched to each other using the Conv_MC_Relations table.

      The logic is that we know that machine X and conveyor Y have a relation, then we get times of stops from conveyors and time of stops of machines and compare them looking for certain events.

       

      The measure i wrote is correct, those are the events that I'm looking to see 1 being the event happened, 0 being the event didn't happen.

      My main issue is i don't know how to display that data in a form of a table showing something looking like that:

       

      line + Conveyor connectorConv stop startConv stop endCaused by Machine
      AM1 CONV122021-06-24 09:00:442021-06-24 09:03:04MC1 (or blank if no match)

       

      The way of determining ..caused by machine" would be the measure 1 being caused by machine and 0 not being caused by it.

      Sorry if my explanation is a bit chaotic, if You have any more questions please let me know.