WAD: Chart Issue
I want to diplay the results of a query in graphical format using the chart type - Stacked lines. Now my query has One char (0CALYEAR) and two key figures. So how can I configure the chart web item to display the two KFs as two lines with values on the Y-axis and the Calendar years on the X-axis ( I mean to ask how do we assign the KFs and the Chars to the series and the category)
Furthermore, Is it possible to just have the Calendar years on the X-axis in the initial display with the ability to drill down further.
Amith Kumar Jada replied
i can help in your case. now i am doing the same chart things in my project.
so u want keep the calyear in the x axis and two keyfigure in the y axis.
by creating the view u can achive this.
first u create the view on the query then keep the calyear on the column and two key figures in the row so that once u assign the graphs it will take automitically x axis calyera and y it will take the key val.