Forum Discussion
SOS4
4 years agoFrequent Visitor
Difference between dates in 2 different tables based on a third column
Hi, I was hoping somone could assist me with an issue I'm having. I want to track how quickly people are actioning and subsequently closing work 'tickets' I want to calculate the difference between...
lbendlin
4 years agoSuper User
Please explain how these tables are linked together.
SOS4
4 years agoFrequent Visitor
Hi,
The field MemberID in Table 1 Workflow logs is joined to the field EHMemberID in Table 2: Work. Cardinality is many:many and cross filter is both directions.
I added a simple subtraction measure outside of the transform data section I believe the values are showing as days. eg. every value is 1, instead of 00:30:35