A Data Analyst has the following chart that shows the sum of sales made in different cities.
The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?
Right-click on SUM(Sales) in the Columns and select Include in Tooltip.
Drag Sales to Tooltip on the Marks card and change Aggregation to Average.
Drag Sales to Tooltip on the Marks card and modify the Tooltip text.
Right-click on SUM(Sales) in the Columns and change Aggregation to Average.
Submit