thanks for the reply. I was asking how to use AVG in measures when we create the cube, not during querying the cubes.
Basically , *Step 3. Measures* http://kylin.apache.org/docs15/tutorial/create_cube.html On Mon, Sep 26, 2016 at 5:01 PM, ShaoFeng Shi <[email protected]> wrote: > You're right, there is no "avg" measure in GUI. "AVG" will be translated > to "SUM"/"COUNT" in kylin in the query time, so if you have pre-defined the > two measure, it will work. Just take a try with the sample cube, > e.g: select avg(price) from kylin_sales > > 2016-09-26 14:05 GMT+08:00 Ashika Umanga Umagiliya <[email protected]>: > >> >> I cannot find average (ABG) measure in the UI as well as in the >> documentation: >> >> In the documentation I cannot find average as well : >> >> "There are 5 different types of measure according to its expression: SUM, >> MAX, MIN, COUNT and COUNT_DISTINCT. Please be carefully to choose the >> return type, which is related to the error rate of the COUNT(DISTINCT)" >> >> I use the latest 1.5.x version of Kylin >> > > > > -- > Best regards, > > Shaofeng Shi 史少锋 > > -- Umanga http://jp.linkedin.com/in/umanga http://umanga.ifreepages.com
