Side by side line chart

Question

I have data on online purchased items and their feedback along with sales, profit, etc. I want to show the number of votes for each feedback option on bar and the count for each feedback and show the avg of feedback using line chart. Can someone help me.

Answer 1

Hi Nidhi,

Follow the below steps:

1. Add the feedback column in column shelf and the product in row shelf.

2. Make the aggregation on the feedback column as count.

3. Now create a calculated field to find the average for each product using AVG([Feedback]).

4. Now drag and drop the calculated field for average in the shelf.

5. if avg field is not a line chart, make it as a line chart

6. Now make a dual axis chart using both the avg field and the feedback field.

Now you can get the graph you wanted.

Hope it helps you.