You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by "陈雷雷 (JIRA)" <ji...@apache.org> on 2016/04/27 08:18:12 UTC

[jira] [Created] (KYLIN-1630) how to get the rate value

陈雷雷 created KYLIN-1630:
--------------------------

             Summary: how to get the rate value
                 Key: KYLIN-1630
                 URL: https://issues.apache.org/jira/browse/KYLIN-1630
             Project: Kylin
          Issue Type: Bug
          Components: General
    Affects Versions: v1.5.1
            Reporter: 陈雷雷


I want to get a value which is defined as sum(a)/sum(b), how can I
do this kind of anlysis.

       Now I build a cube which have sum(a) and sum(b), when I execute
“select sum(a)/sum(b) from table1 group by c” ,the result is wrong.
sum(a)/sum(b) the result is all 0 and sum(b)/sum(a) result is all 1.

      MMENE_NAME    SUCC   ATT    SUCC/ATT
      CSMME15BZX   336981   368366   1
      CSMME32BZX   338754   366842   1
      CSMME07BZX   687965   747694   1
      CSMME03BHW   703269   747623   1
      CSMME12BZX   705856   764656   1
      CSMME16BHW   1962293    142173   1


      MMENE_NAME   SUCC   ATT   ATT/SUCC
      CSMME15BZX   336981   368366   0
      CSMME32BZX   338754   366842   0
      CSMME07BZX   687965   747694   0
      CSMME03BHW   703269   747623   0
      CSMME12BZX   705856   764656   0
      CSMME16BHW   1962293    142173   0



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)