Solved
Widget Custom Grouping
I have a pie chart of IP address that is counting logins. I would like to group the IP address that are similar into one group. So if the IP starts with 172.168.243.xxx then that would be group 1 th...
Hey zach_myt ,
I will give you an example based on the Sisense sample cube called Sample Healthcare.
There is a field named RoomID in a table called Admissions. This RoomID ranges from 1 till 60. I want to group those RoomIDs into 3 groups of 20. 1-20 , 21-40, 41-60. Afterwards I want to show those in a piechart;
The basis:
What I will do now, is create 3 Measures (remove the Room_id from categories) and filter those measures to create the needed groups.
I created 3 measures, each filtered differently:
After doing this, I can rename those measures by double clicking on it or using the 3 dots to rename:
If I am not mistaken, this is what you are looking for? Correct?
Hamza
