In Sisense, how can you "group by" in ranges?

Hi leo82 ,
I would do this on Elasticube level. It depends how your data structure looks like and what are the table names, but you can try implementing following logic:

First I would create custom table, let's call it team_size_count. It will calculate the number of users in each group with following query:

select a.[Team_id], case when count(a.[uesr_ID]) <= 5 then '0-5 member per team'
when count(a.[user_ID]) > 5 and count(a.[user_ID]) <= 8 then '6-8 member per team'
when count(a.[user_ID]) > 8 and count(a.[user_ID]) <= 12 then '9-12 member per team'
end as Team_Size
from [Users] a
group by a.[Team_id]

Then you can create a team_size custom column on Teams table with following query:

lookup([Team_Size],[Team_Size_Count],[id],[team_id])

In next step you can achieve desired view by using this column in pivot table widget in rows section and as value simply count the number of teams

--
Konrad Wróblewski
QBeeQ