Dieses 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.
Additionally next to each line, you will see the number of rows containing that specific filter input.
A more advanced use case of the filter dialog is introducing additional filter conditions. You can do that by clicking on the split filter icon, similar to the image below.
After you split the filter, you can enter your condition. In the example image below, you can see that we want to filter the row to contain both the “Keramik“ and “Glas“ texts.
Please note that the splitting of the conditions is not limited by any means, you can split any conditions even more to provide a more granular and detailed filtering condition.
The filtering is not limited to only the contain condition, you can also use more methods, similar to the image below.
An example for another filtering condition is the case when want to filter the rows which are between two numbers, for example between 2 and 7.
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.
At the end of each row in the first column you have the filter icons which can be used to open the filter dialog, as opposed to the filter icons at the end of the filter inputs.
This works different than the filter dialog of the dataset view, in the case of statistics you can use the filter dialog to filter the original dataset which is used to display the statistics.
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.
The filters in the histogram view behave a bit differently than the others, here if you enter a value only the column in which you entered that will be filtered, the other columns will remain the same.
