Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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