Overview/Charts Tab: Distinct Counts
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
It would be tremendously helpful if a distinct count of each column, as well as each interval within each column, could be displayed upon request. If there are 1000 rows in a table, I often want to find out how many users are represented in this table. Its easy with SQL, but when your SQL is complex, its extra work to put a wrapper on it to get the distinct counts.
If instead, I could just go to the results: Overview/Charts tab and either mouse over/right click a column or an interval to get the distinct counts per column and/or intervals within a column, that would instantly make that tab much more useful for users.
By the way: Thank you. This tool is very well done.
Is committed to our Git repository will be available in future snapshots and versions.
Here are some details quoted from our change log:
Feature request #501 Overview/Charts Tab: Distinct Counts
- Distinct counts for an Overview as a whole are now displayed right next to the column name
- Distinct counts of Intervals are available as tool tips
as well as a new details window which is accessible through the right mouse menu