topic Re: Calculate dimension in App Development

Calculate dimension

lord_zeus — Sat, 16 Nov 2024 01:18:00 GMT

Hello!

My colleague has a problem with which I could not help him. Suppose we have a table:

user_id	country	atr1	atr2
1	RU	1	66
2	US	1	55
3	RU	1	55
3	RU	2	77
2	US	2	88

He want to count how many times user_id occurs in table (name it "#frequency"), and after that use the result of it and use like dimention and calculate how many user_id occurs in what #frequency.

Result must be somting like this:

#frequency	#users
1	1
2	2

The problem is: if we select atr1 = 1, the result will be like

#frequency	#users
1	3

So, i cant calculate it in script, because dimention #frequency will change when in choose something.

Maybe I don't see simple solution?

Re: Calculate dimension

lironbaram — Wed, 14 Oct 2020 12:14:08 GMT

hi
short one ,
for dimension use this

class(aggr(count(user_id),user_id),1)

expression:

count(distinct user_id)

Re: Calculate dimension

Taoufiq_Zarra — Wed, 14 Oct 2020 12:28:14 GMT

@lord_zeus if you select atr1 = 1 normaly what is the expected output ?

for me 3 is correct !

in dimension :

=aggr(count(user_id),user_id)

Expression:

=count(distinct user_id)

output:

Re: Calculate dimension

Taoufiq_Zarra — Wed, 14 Oct 2020 12:29:12 GMT

Re: Calculate dimension

lord_zeus — Wed, 14 Oct 2020 14:05:50 GMT

Guys, thanks! Both answers are correct, but for my task, Taoufiq_Zarra will give the most correct answear.