Expand all | Collapse all

Grouping by attribute, and grouping by 'closeness' RE grid reference data in attributes

  • 1.  Grouping by attribute, and grouping by 'closeness' RE grid reference data in attributes

    Posted Thu October 10, 2019 09:20 AM
    Hi all - does anyone know if it's possible to group your entities by attribute value? I've tried and tried but nothing seems to work, the only thing I can find is how to do it in a timeline.

    Also, can the program tell how close entities are by grid reference/eastings and northings? How can I get it to group entities using this?


    Charlie Hawco

  • 2.  RE: Grouping by attribute, and grouping by 'closeness' RE grid reference data in attributes

    Posted Fri October 11, 2019 05:11 AM
    Morning Charlie
    I think I have potential solutions to your questions, but it does entail you clarifying what you mean by "group." 

    There is a function called Group available in later versions of ANB (added at v8.9.3, is on the Arrange Tab of the Ribbon in v9.x releases), which when deployed to a selection of entities means that if one of the Group is moved, they all move in unison, or if you run a Chart Layout, they stay together.  If this is what you mean, then the solution to the Attributes question is relatively simple.

    You can either
    -use List Items (F11) and sort your table by the required attribute class.  Selecting all entities with a particular attribute value within List Items means those entities remain selected on the chart when you OK the List Items Dialogue Box.  Then whilst selected you can Group them. 
    - using the same principle but with a more modern tool, you can use Bar Charts and Histograms - as it is called in v9.x (it is called Filtering in v8.x)  You can apply a Bar chart/filter against the required attribute class, and it will detail how many records on the chart have each value listed.  Selecting a particular value in the tool makes those entities selected on the chart.  Once selected, apply Group.

    The geographic question is harder, and it depends on (a) what version you're running & (b) whether your install has the mapping interface installed and running.  If you have the mapping interface working and have populated Attributes like Long/Lat, Easting/Northing or Postcode then you can run Add to Map from the right-mouse-click context menu.  Open the Map tool and you get a secondary display showing those entities on the map.  Selecting entities from within the Map should correspondingly select them on the chart itself - thereafter you can group them (I cannot test this as my mapping interface is broken and I'm awaiting my ICT to fix it).

    The alternative is to use Bar Charts and Histograms again, and run Bar Charts against your geo-coded attributes (you can have more than one Bar Chart applied at a time).

    If I've misunderstood what you meant by "group," please reply - but can you in your response also confirm which version of ANB you are running.  Some of the tools that might be useful have only been added in more recent releases.  There's no point instructing you how to use something you don't have access to :-) 


    Anthony Patamia

  • 3.  RE: Grouping by attribute, and grouping by 'closeness' RE grid reference data in attributes

    Posted Fri October 11, 2019 01:26 PM
    Hi Charlie

    Try using bar and histograms and identify your attribute options there. As far as geospatial capabilities I would recommend using ARKHOS Data Fusion, which provides cluster analysis based of lat/long ARKHOS Data Fusion V1.4
    YouTube remove preview
    ARKHOS Data Fusion V1.4
    Bringing multiple data sources together to provide deep insights through a unique user experience.
    View this on YouTube >


  • 4.  RE: Grouping by attribute, and grouping by 'closeness' RE grid reference data in attributes

    Posted Tue October 15, 2019 09:10 AM
    Hello Charlie,
    I agree with Anthony, grouping by attribute value is vague.  In any case, some options for you to look at:
    • Option 1: if you want to group those entities visually, you could use Conditional Formatting based on the attribute value with spectrum, above, below or between or specific.  As an example, if you want to identify certain entities based on a threshold or a key information. It works well with attributes on a link i.e. I have help a fraude analyste setting up a similar approach with banking data and a threshold he needed to see as he gets the data imported on his chart.
    • Option 2: This option can be used to group entities based on the information the attribute value holds i.e member of an Criminal Org, Possession of weapons, Criminal Records (yes or no), type of association.  It is called Selection Set / under Select menu.  Once you have identified your entities based on a certain attribute value (F-11), you can assign a selection set 1 to 10, where each selection set holds a group of entities based on the attribute value.  This option will add a number as an attribute under your entity, yellow in color, with the number of the set the entities belongs to.  If you need to add more entities to the set as they get added to the chart, just select the news ones and added to the appropriate sets, same goes to remove entities as they hold a new value.  With this value added to the entities, you can use other function in ANB using those selection sets such as Bar and Histogram that will display under Attribute Class, how many entities belong to set 1 or 2 etc...or conditional formatting based not only on the attribute value but also based on the selection set.
    Hope this help.

    Eric Niclaes
    IBM i2 specialist
    Necando Solution / IBM Platinum Partner.

    Eric Niclaes