Forum Discussion

zach_myt's avatar
zach_myt
Data Pipeline
01-17-2024
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...
dashboards & reporting
Data Models
Information Technology Analytics
  • HamzaJ's avatar
    HamzaJ
    01-18-2024

    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

     

     

     

zach_myt's avatar
zach_myt
Data Pipeline
01-18-2024

Hi HamzaJ, thanks for replying but I'm not sure I follow. I have filtered measures enabled. I can also filter but it is on (DUPCOUNT([IP]),[IP]). Currently when I add the filter I am filtering on the count of IP addresses rather than what the IP starts with, such as 174.166.222.xxx.

I also am unable to rename the groups to anything meaningful, it is a list of IP address. I have attached a pie chart of what I am looking to do with 3 groups, there would then only be 3 categories in the legend of the chart to match the 3 groups in the pie chart.

Let me know what you think.

  • HamzaJ's avatar
    HamzaJ
    Data Integration
    01-18-2024

    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