Problem making dashboard

User_SM827

Hello I am a beginer in obiee. I have a table in which the entry and exit moves. I have another one of locations where I also have classified the department to which it belongs.

My movement table has date and time, movement type and location. When I do a query with the two tables to get the input or output moves by departament, the value of the department field that gives me as a result is that of the entry movement. Check-out date and time is the same as check-in. What I need is to compare if the department of origin is the same as the one of destination. I am a BI user and I do not have access to modify the repository. Thanks

[Deleted User]

https://community.oracle.com/tech/apps-infra/kb/articles/4-how-to-ask-questions-in-developer-community-spaces

Please provide pertinent information according to community standards. Full and exact version of the product you're using. Full and exact version of the platform you're running on and browser. Etc. Etc.