I'm trying to add a pie chart to a report that I've been working on and im at a loss. The chart itself is great, my problem is the Legend. Its showing the wrong column and I cant figure whats wrong with it. I have a query that returns 3 rows and two columns. The query results look something like this:
Category | Amount
--------------------------
Chats | 51
Phone calls | 379
Emails | 2602
When I create the pie chart in the report designer, all the slices are the right size and labeled with the correct percentages. However in the legend, it just has "Amount" shown as the key for each item in the legend. I want it to display the actual category, but cannot seem to get this to work. I followed the documentation listed at https://docs.telerik.com/reporting/graphhowtocreatepiechart, but it still shows "Amount" in the legend instead of the actual categories. I have attached a screenshot of the report designer to show what the pie chart looks like as of now.