topic Re: Group by in measure expression (#1 KPI) in App Development

Group by in measure expression (#1 KPI)

gadwinjer — Thu, 25 Feb 2016 10:43:14 GMT

Hello,

I would like to group by a count expression and get the max of the values but I don't know how :

In #1 KPI there is no dimension (that makes sense for only 1 value ) Could someone tell me how can I do something like this:

MAX(COUNT(DINSTINCT [colonneA]) GROUPBY [colonneB])

Thanks

sunny_talwar — Thu, 25 Feb 2016 11:10:53 GMT

May be this:

Max(Aggr(Count(DISTINCT colonneA), colonneB))

gadwinjer — Thu, 25 Feb 2016 13:25:00 GMT

Why did I suppose that would be harder ? Thank you !