This is a simplification of my predicament, but I am having some problems making things aggregate correctly without losing human readability. I guess the question I am asking is how I could either have better control of my aggregation or axis/legends.
Suppose I am trying to make a line graph of 4 users with this data:
User ID
Name
Sign-up Date
X-axis (first dimension)
Y Axis Expression
AMK292732A
Steve
1/2/2016
1
10
MK23554642A
John
1/1/2016
1
20
TW335454
Steve
1/3/2016
1
30
CD34542SSgfz
Pat
1/1/2016
1
40
AMK292732A
Steve
1/2/2016
2
10
MK23554642A
John
1/1/2016
2
20
TW335454
Steve
1/3/2016
2
30
CD34542SSgfz
Pat
1/1/2016
2
40
The correct graph for this, theoretically, should be 4 parallel lines, but i am having difficulty controlling the details so that it is logical for the human to know what they are looking at. This is what I have tried so far:
1. Using Name as second dimension (no good):
This will only make 3 lines, as the two people who are named Steve will be aggregated with each other
2. Using the Sign-up Date as second dimension (no good):
This isn't much better, although the two Steves have different sign up dates, this will together Pat and John because they signed up on the same day.
3. Using the User ID as second dimension (functional, least readable): This will give us with our intended result, our legend will point to "CD34542SSgfz" as a user, which is not readable.
I could theoretically create another column that concatenates the sign up dates with the name, but that isn't that much more readable and my actual data also has very long strings as names.
Ideally, I would like the key to have repeating values ( like, the key would have has a green steve and a blue steve)
Anyone have any suggestions or point me to a solution?
