sum of count?

[#1]

Hello everyone!

I have troubles with such expression (in chart http://s017.radikal.ru/i408/1505/cd/9aa79ad6c971.png) :

measure  - count of such values, groupped by different ranges (dimension, formed by huge bunch of "IF"s, like

if ([uniq_city.avg_metr] > 150000, '> 150',if ([uniq_city.avg_metr] > 140000 and [uniq_city.avg_metr] <150000,'140-150'...etc)

I want to count a rate by total sum of counts(without breaking by ranges which i pointed out above), smth like this (instead real values):

count({$}[uniq_city.avg_metr])/sum(aggr(count([uniq_city.avg_metr]),"smth_i_dont_know"))

could u help me with the expression?

thanks in advance!

[crusader_]

Hi,

I'm not sure that understand you properly but  check my example.

Do you want find a ratio of this week to total or previous week to total or both?

PFA

Hope this helps you.

Regards,

Andrei