Jump to content
  • 0

Separate Line Graph for each Record



I have a table that contains the average and mean KPI for my unit as a whole, as well as each person in my unit. 

I can create a report DataPage that shows lines for each individual (too many lines).  And I can create a report DataPage that shows the graph for just one person. I want a report DataPage that outputs one separate graph for each person. If I have 30 people in my tables, I want 30 separate line graphs. Is this even possible? If so, could I also overlay the data for the unit with the person's chart?

I appreciate your help in advance.

Sample data looks like this:


I want to create a line chart for each person showing the person's average and median for the past 6 month.

On the **SAME** chart, I would like to show the average and median for the entire unit. In essence, I would like the chart for the unit to overlay the chart for each person. Here is a mockup (does not match the sample data - it's just a sample output).




Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...