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 史少锋
