So one way that might help will be to use a UNION, with a twist!
In the below GIF I've unioned 2 files (heart rate and blood-pressure) and then used the "Merge Fields" so that I get all the Vitals into a single measure. The Table Name/Sheet (with csv this will be the File Name) can then be used (as a dimension) to split up the different values. If the TimeStamp is also called a different name in each file, you'll also need to merge these so you get a single column of all the datetimes.
I've attached a quick example of this plotted out in Tableau. You may also want/need to normalise the values if they are of very different scales, if you want to plot them on a single axis, or you can bring the Table Name/Sheet onto the Columns and create an axis per measure.
Hope that helps,
Vitals_Unions.twbx 17.1 KB
Simon - I am a newbie and a student so your animation definitely helped me grasp the concept very quickly! I'll try this later today and let you know.
Simon - Many thanks, the Union worked as you expected. I created different sets using TableName and that works for creating individual charts, SPO2 set example below.
My goal is to create a series of charts as you see below. My method likely is crude and won't work I am not sure how to assign different sets/filters for each chart. Note the chart below is not accurate as only takes the subset of timeframe as I described above so only including it as an illustration.
What would be the optimal way to:
The Table Name/Sheet (with csv this will be the File Name) can then be used (as a dimension) to split up the different values?
Glad it helped.
So with regards this there are 2 ways you can go here.
On the first way (shown in the GIF) I combined both the Heart Rate and Blood Pressure measures into a single column, called values. I can then use the Table Name to split up the measures into separate charts (in my example I just brought this onto the colour shelf to get a colour per Sheet Name, but just add it to the columns to get a chart per Sheet Name)
Another way, with Unioning the data, but without merging the fields (so I get a measure for each Vital), is shown on "Option 2". Here I've used the (Tableau generates) measure names/ measure values to split the charts up (these a psudo-dimensions and measures that Tableau creates for plotting multiple measures)
If the scales of the different measures are very different you can also use this option
So each chart uses it's own Axis range (or you could normalised the measures, say between 0 and 1)
Hope that helps
Vitals_Unions_2ways.twbx 29.3 KB
Once again, thank you for your assistance and appreciate your patience and coaching.
That worked perfectly! Thanks!