Hello, I have a query which returns Planned_Sprint, Total Hours,Actual Hours,Team,Type. Now i want a stacked bar and line chart , in which the stacked bars are split by Planned_Sprint,Type and the l...
See more...
Hello, I have a query which returns Planned_Sprint, Total Hours,Actual Hours,Team,Type. Now i want a stacked bar and line chart , in which the stacked bars are split by Planned_Sprint,Type and the line is only Split by Planned_Sprint. The X-axis as Planned_Sprint, the Y as (Total Hours)stacked bar and (Actual Hours)line. Planned_Sprint Total Hours Actual Hours Type Team Sp_1 10 20 A WWW Sp_1 15 10 B DDD Sp_1 5 10 B RRR Sp_2 10 15 A WWW Sp_2 20 5 A DDD Sp_2 10 10 B TTT Sp_2 5 8 C RRR Sp_3 20 20 B TTT Here is my code for the chart: | chart sum(Total Hours) AS PLANNED_Hours,sum(Actual Hours) as AC by Planned_Sprint,Type But in this even the AC gets split by Type. I do not want this, i want something like this: | chart sum(Total Hours) AS PLANNED_Hours by Planned_Sprint,Type, sum(Actual Hours) as AC by Planned_Sprint Any suggestion how this can be achieved?