Hello, I am working on creating a line and clustered column chart for custom service rankings by month and site.
The problem I run into is the columns only allow me to select the "count" of the number of rankings, average, median etc... however, in the data I imported (see example below), I already have the values I want for rankings and score. However, the chart is averaging the rankings and score OR counting the number of distinct values I have. How can I get the chart to display exactly the values I have in the chart I imported?
Is it also possible to add a second line for a target rank?
Thank you in advance!