db2 - 将表格数据转换为饼图数据

Question

需要将从表中提取的数据绘制成饼图。

我正在从表中选择数据来计算不同场景的票。我可以简单地选择要在 excel 中绘制的数据。但我需要以这样的方式选择相同的数据，它也可以绘制在饼图中。

SELECT Sum(CASE
             WHEN Date(reportdate) < Date(current timestamp)
                  AND ( status NOT IN (SELECT value
                                       FROM   synonymdomain
                                       WHERE  maxvalue IN ( 'RESOLVED', 'CLOSED'
                                                            ,
                                                            'REJECTED' )
                                              AND domainid IN ( 'INCIDENTSTATUS'
                                                              )) )
                  AND incident.ir IS NOT NULL THEN 1
           end)     AS IMs_Balance_Carry_Forward,
       ( Sum(CASE
               WHEN Date(reportdate) = Date(current timestamp)
                    AND ( status NOT IN (SELECT value
                                         FROM   synonymdomain
                                         WHERE  maxvalue IN (
                                                'RESOLVED', 'CLOSED',
                                                'REJECTED' )
                                                AND domainid IN (
                                                    'INCIDENTSTATUS' )) )
                    AND ( incident.ir IS NOT NULL ) THEN 1
             end) ) AS IM_Added_During_the_day,
       from         INCIDENT

当前结果：

 IMS_BALANCE_CARRY_FORWARD        IM_ADDED_DURING_THE_DAY

         120                            8   

所需结果"

Column1                            Column2

 IMS_BALANCE_CARRY_FORWARD            120
 IM_ADDED_DURING_THE_DAY               8

标签： db2birt

Answer 1

你想要一个不可旋转的能力，这已经在这里得到了回答。以前的问题和答案