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 for your help. I was able to get the imported value by using max ( ). However, on the x-value I want the months in chronological order but I noticed for the values where I use the slicer for certain locations if February values are greater than January, it flips the order of the months on the x-axis. How can I overcome this?