I'm trying to recreate a chart I made in Tableau (see attached) which illustrates variation among divisions and the teams within those divisions and shows the relative size of the teams.
I managed to do this by choosing a line chart with the division and team as dimensions and rate= sum(numerator)/sum(denominator) as the expression. Then I used a symbol rather than a line.
But have TWO pieces that don't work:
1) The size of the symbol should reflect the denominator (sum(denominator)) for each team - I can do this in a scatter chart, but I can't get text on the x-axis in a scatter chart and I can't seem to change the size of the symbols based on an expression in a line chart.
2) the black squares represent the mean for each division- in Tableau I did this with a dual axis - I tried doing this with a second expression and used set expression to include all the teams, but it wiped out the symbols for the individual teams that I created with the first expression.
.png "Former Employee"){kind=icon}
