Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe create a calculated second dimension, like
=[User ID] & ' - ' [Name]
or if you want repeating names
=Dual( [Name], FieldIndex( 'User ID', [User ID]) )
YOU ARE THE BEST