I have the following data which I am trying to present this visually.
There are two parts.
| PK | slno | date_time_1 | date_time_2 | Type | Country | Name | Status | Action | VSTAT |
|---|---|---|---|---|---|---|---|---|---|
| 123457 | 5555 | 17/1/2021 11:06 am | 29/1/2021 9:45 pm | T1 | USA | ABC | S1 | FSBB | V |
| 123457 | 2487 | 18/1/2021 3:40 pm | 1/2/2021 11:29 | T3 | USA | ABC | S1 | CAC | VG |
| 123457 | 3357 | 18/1/2021 4:05 pm | 1/2/2021 10:53 | T4 | USA | ABC | S3 | PMR | VGG |
| 123457 | 5897 | 18/1/2021 3:42 pm | 7/2/2021 4:40 | T1 | USA | ABC | S2 | NPF | VG |
| 123457 | 8879 | 18/1/2021 4:34 pm | 6/2/2021 22:05 | T2 | USA | ABC | S1 | CAI | V |
| 123457 | 5547 | 22/1/2021 11:23 am | 1/2/2021 15:12 | T2 | USA | ABC | S3 | CAC | V |
| 123457 | 2254 | 28/1/2021 11:12 am | 1/2/2021 14:59 | T3 | USA | ABC | S3 | CAI | V |
| 123457 | 6932 | 28/1/2021 7:21 pm | 1/2/2021 11:10 | T7 | USA | ABC | S3 | NPF | V |
First
Here PK is the primary key and each of the rows need to be indicated as one node/box/entity with the primary key as the primary node.
So how I would ideally like this to look is
primary key
|
slno
|
|
(date_time1 - date_time2) | type | country | name | status| action| VSTAT
Is there a tree based (or dendrogram) or any other similar visualization method that can be used for this purpose?
Sorry if the figure above is a little vague.
Second
is there a library that can help me create a drop down listing all the primary keys and based on the primary key selected populate the visualization? Would this be easier in Shiny (if so any link where I get a tutorial/help)?
Thanks for any help in advance.