The Onedot App provides a powerful set of capabilities for filtering datasets which results in a smoother and more productive workflow in the case of large datasets.
Filtering Datasets
Accessing the filters
The filters can be accessed by right clicking on any of the available columns the selecting the Show Filters menu item.
...
After clicking on the menu item you will be able to see the filter input fields, similarly to the image below.
...
Filtering by the filter input
Once you see the filter input you can enter any text in the input field and only the rows containing that specific text will be displayed.
...
Additionally, by holding the cursor over the filter icon above the table you will be able to see which columns are filtered.
If you want to quickly remove any existing filters you can do that by clicking on the X icon just above the numbers of the rows. If you want to quickly clear only one filter input you can do that by clicking on the X icon on the right side of the filter inputDieses Seite beschreibt, wie Daten wie Produktdatenkatalog einfach bezüglich Qualität analysiert und profiliert werden können.
Datensätze filtern
Einen ersten Überblick ihrer Daten können Sie sich einfach durch geeignete Filter verschaffen.
Filterfunktionalität aktivieren
Klicken Sie mit der rechten Maustaste auf eine beliebige Spaltenüberschrift und wählen Sie das Show Filters Menü aus:
...
Nun wird eine weitere Zeile mit Filterfunktionalität gleich unter den Spaltenüberschriften angezeigt:
...
Eigene Filter definieren
Geben Sie einfach den gewünschten Text nach dem Sie filtern möchten in der entsprechenden Spalte ein. Onedot filtert die Daten bereits während Sie tippen, damit Sie die Ergebnisse ihres Filters gleich sehen.
...
Bewegen Sie den Mauszeiger über einer der Filterikonen in einer Spaltenüberschrift um zu sehen, wie die Spalte gefiltert wird.
Existieren Filter können einfach durch Klicken auf die X Symbole in der Filterzeile entfernt werden, entweder nur einzelne Spalten, oder alle Filter.
Zeigen Sie mit der Maus auf das Trichtersymbol um eine Uebersicht zu kriegen, wie ihre Daten gesamthaft gefiltert werden in dieser Ansicht.
...
You can filter by multiple columns at once too, in the example above you can see that the message contains the names of columns by which the dataset is filtered.
Filtering by the filter dialog
The Onedot App provides another, more powerful filtering feature, the filter dialog. With the help of the filter dialog, you can fine-tune and apply more advanced filtering conditions for the dataset.
Accessing the filter dialog
The filter dialog can be accessed by clicking on the filter icon, right at the end of the filter input. After clicking on it you will see something similar to the image below.
...
Using the filter dialog
The simplest usage of the filter dialog can be done by entering any text to the filter input, after that you will see the results of the filtering and you can select or deselect only the rows you are interested in.
...
The filtering can be applied by clicking on the Apply button on the bottom of the filter dialog.
...
Additional notes
The two types of filters can be mixed and matched freely to get the most out of the filtering capabilities provided by the Onedot App.
Filtering Statistics
Accessing the filters
The filters of the statistics view can be displayed in exactly the same way as you would do for the dataset filters. Just right click on any of the columns and select Show Filters.
...
Filtering by the filter input
The filter input works the same way in the statistics view as in the dataset view, you just enter a value and you will see the rows which contain that given input.
...
Filtering by the filter dialog
In the case of the statistics view, you also have to option to use the filter dialog, however it works a bit different to the dataset view.
...
Each row in the first column represents an attribute of the original dataset, when you apply a filter you will see the statistics for the underlying filtered dataset.
...
Filtering Histogram
The histogram view at the moment only provides filtering by the filter input, you can access that the exact same way as you would do on the other views. Just right click on a column and select Show Filters.
...