Thanks for the update. The overall image looks good in terms of the columns and rows (grid). What I am trying to accomplish is to display any weight values associated with a patient (the Data ID field identifies the patient) into one box. For example, patient with Data ID #1 has five weight data values. This data should appear in the first box with five circles (so to speak). The five circles will represent the weight values for that particular patient.
The next box should show patient with Data ID #2 with two weight values (two circles). And this process continues throughout the panel charts for the remaining patients in a column/row grid-like fashion. The first row would display individual patients per column with their weight values. Overall, I should be apply to view several patients growth charts at a time on the screen.
Does that make sense? Any help is appreciated. I've been working on this for some time and still cannot get it to work.
Thanks so much.
I understand you goal, but fundamental problem is you have so wide range across all the data ID.
It's from 5 to 5000 days as "Age in Days" .
By the way on data ID on 1 chart can be achieved by using Data ID itself in calculated field.
I tried using Log scale, but it's till not enough to show different data point for example Data 1.(2399~2421 as day = 22/5000)
So, Without grouping the Data ID by "Age in Days" you can not accomplish what you want.
SampleData_2_SM_10.1.twbx 73.6 KB
Thanks so much for attempting to assist me. So do I need to set up the data in a different way or format? I've seen so many examples of panel charts that were done successfully in Tableau that use similar data I'm using. Do I need to have an actual date instead of using Age In Days or Age In Months? I do see where Age In Days tend to give the actual count of the weight values.
I'm still looking at some examples that have been put together by members of this user group. So many beautiful and complex examples at that. In the meanwhile, I still need further assistance with setting up the panel charts to display patients weights.
That's really depends on what do you want to show thru chart / from what kind of data.
One idea to normalize the data is using the "days' from first date of each ID.
And change the color by "Age in days" brings this chart.
Seems little better.
SampleData_2_SM_10.1_V2.twbx 77.2 KB