Column chart only displaying totals and not individual numbers

[kioshi43]

Hi all,

I've been trying to wrap my head around where I'm going wrong but I'm having trouble trying to get a table to reflect the data displayed in the way I want.

I have two documents - one that displays how many issues resolved by each team in a specific month. The second table displays how many people are in each team (generic example: 

What I am trying to do use a line / column chart that displays the total number of issues resolved against the total number employees but for whatever reason, I'm having some trouble displaying it and I've tried different combinations but I'm at a loss.

Here's a screenshot of what it currently looks like: 

with these in visualizations: 

The columns are showing the total number of members for all teams rather than them individually based on the team number.

Feels like there is something simple that I am overlooking but Friday afternoons don't exactly leave me with a lot of mental brain power haha

Any help would be sincerely appreciated!

[Anonymous]

HI @kioshi43,

You can change your chart design to use date fields on the 'share axis' and use the 'team' field on 'column series', then your chart will show the graph based on the date axis and group by team values.

Regards,

Xiaoxin Sheng

[amitchandak]

@kioshi43 , No access to the files

[kioshi43]

Apologies - link should be good now.