Forum Discussion
Contact Tracing
Hi!
We're trying to put together a rudimentary contact tracing visual based on some data extracts. The data source is very simple:
Date;Cargiver Name;Patient Name
Using this I can get the list of all patients for a caregiver or a list of all caregivers for a patient. What I need to do is connect the dots between them. For instance, if caregiver A visits patient A and B and caregiver B only visits patient B, I need the trace on Caregiver A to output patient A, patient B, and caregiver B.
I've been trying for days to wrap my head around this seemingly simple task and haven't been successful. Any help would be much appreciated!
Thanks!
Yes! Exactly this! I will dig in to it. Thank you!
5 Replies
It sounds to me like a Transitive Closure issue. See this link: https://community.powerbi.com/t5/Quick-Measures-Gallery/Transitive-Closure/td-p/783828
Yes! Exactly this! I will dig in to it. Thank you!
Hey Greg_Deckler ,
next to what Greg_Deckler already mentioned, this is my favorite custom visual from the app source:
Tassels Parallel Sets slicer.
This allows to create a visual like this:
Maybe, this will add some new ideas.
Regards,
Tom
Ok, so I got excited and jumped the gun a bit. This is almost what I need. Only in the Input Table, I need the relationship to be bidirectional instead of just from left to right.
So using the example in the link, the output for 1 would be:
1->2;3;4;5;6;7;8
based on all contact of the numbers involved.
I need to find every contact that 1 had, either directly or indirectly.
- Hi there.
What is the logical rule you're trying to implement? I don't think you've covered all possibilities. To calculate something one has to know what to output for all possible inputs. I don't think you've specified the complete rule.
Can you please explain how the calculation should work for all possible arrangements?
Thanks.
Best
D
