VC Team,
My scenario is like this.
I have a KPI where there is a Keyfigure for Production Cycle time. I want to show this Keyfigure in the Pie Chart with two shades. One with value >30 and the other less than 30.
I mean, User has to see the % records less than Threshold value and % more in Pie chart. And when he clicks on Threshold %, the records related to the % should be displayed in the table.
For that I took the Query, then i used 2 filters, one for >30 and <30 . For Filters, I added Group By to get the 'count' for no of records of each type. Then i used the 'Union' operation, to show the data in Pie Chart. But while compiling i am getting the warning message, "Expected exactly 1 data series in Chart1chart. Extra data series ignored. "
Am i doing it in wrong way ?
I really appreciate your patience in reading my question. Will wait for your reply.
Regards,
Sonti.