Best Chart to show connection/link between data

[daveesjohn]

Hi experts

I am planning to create a chart for contact tracing to show the link or connection between one user to multiple users.

Currently I am using Network Chart but the schema not fit to my data.

My data requirement fields are

UserOne        UserTwo       Exposure

488                        748                  2mins

488                        442                  3mins

490                        500                   1min

Anyone can suggest the best chart for this type of requirement?

Thanks in advance

[Lisa_P]

Possibly a Sankey chart ?

[daveesjohn]

Thank you Lisa

Can you show the dimension and measures?

[Lisa_P]

This is how I loaded your data:

Data:
Load UserOne,
UserTwo as LinkTo,
Left(Exposure, 1) as ExposureMin;
Load * inline [
UserOne, UserTwo, Exposure
488, 748, 2mins
488, 442, 3mins
490, 500, 1min
];

To get Exposure as a number.

Properties are: