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).
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.
Question
Bourenane
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.