0 Replies Latest reply: May 8, 2018 8:59 AM by Dan Green RSS

    Loosen Tables?

    Dan Green

      I am running into an issue with my Completion Times table. I want it joined to BPMProduction on the ReceivableID which joins to the AssignedWorkflows table on the WorkflowID. The issue is QueueName is common filter throughout the application. To get accurate counts of assigned workflows, the QueueName field needs to be in the AssignedWorkflows table. I want to see completion times by Queuename too but that creates the issue in the model below. I didnt want to alias the field name because then the filter would not work across all sheets. Is there a way to break the join between CompletionTimes and AssignedWorkflows but still have the common filter of QueueName?