Forum Discussion
How to create a line graph with grouped data.
I have data that looks similar to:
How would I create a line graph that shows the heart rate by intensity for each first name, last name and gender group, as so:
To solve this problem, first off I would combine the names, as there doesn't seem to be any reason to split by surname or first name, you would always be splitting by full name, right? This can be done in PowerQuery - please ask if you're unsure.
Then, I would create a Line Chart visual, have intensity as the Axis, Heart Rate (as a Sum) as the Values, and then your new "Combined Name" field as your Legend.
I think this would give you the data you're trying to visualise. If gender after the name is critical, then you can combine the gender into the new name field.
5 Replies
Anonymous
Try using Small multiples in Line Chart
To solve this problem, first off I would combine the names, as there doesn't seem to be any reason to split by surname or first name, you would always be splitting by full name, right? This can be done in PowerQuery - please ask if you're unsure.
Then, I would create a Line Chart visual, have intensity as the Axis, Heart Rate (as a Sum) as the Values, and then your new "Combined Name" field as your Legend.
I think this would give you the data you're trying to visualise. If gender after the name is critical, then you can combine the gender into the new name field.
Yes. Wasn't quite what I had in mind but that would also work, and even gives you more flexibility than what I suggested.
