Forum Discussion
Multiple tables
I have 2 tables that I want to incorporate into 1 combo bar/line graph that can be maniplulated using slicers for date ranges and particular User IDs. My intent is to have bars showing counts for eac...
I did this but the problem is the line for goals is just the sum of all for the month (so the bars show the actual entries person but the line is just straight across). I want the line to show the value per User ID. How do I make it reflect that?
This is what it looks like filtered for 1 month. Se ehow the goal line is a sum of everone's goal instead of going up and down to show each person's specific goal?
I want it to look like this, but keep in mind each month the goals change for each person. I tried doing a table for a single month's goals but then there is no historical data captured: