aggregate and count the port occurrences

nuno

Hello,

I have a dataset that gives me something like:

Destination Port

---

8080
8081
9090
8080
9090
1200
8888
9090
8888


and I would like to make a bar chart displaying Top Destination Ports, imagine top 3. After aggregating data I would like to have:


Destination Port | Count

---

|

---

8080 | 2
8081 | 1
9090 | 3
1200 | 1
8888 | 2


Making a top 3 with 9090, 8080 and 8888

filter only the Top 3 of the aggregation?

Virgil Dodson

Hi nuno, since you need to do some processing to consolidate your port information, you can either do that yourself prior to passing BIRT the data... or you can do some processing in BIRT. One way to do this is by adding a table to the report, even if you don't intend to show the table. The table will help you with grouping and aggregrating the data, It will also help with sorting the largest items... and allows you to provide a filter like Top N to get the top 3 items.

Once you have your table created, name it in the General table properties... This allows it to be visible to the chart wizard so you can choose the table as the chart data source.

I created a simple example with BIRT 2.3.2 using your data.