[00:00] The row selector component acts like a visual filter for datasets. It is located in the reporting section of the component palette. I have one on my window here on the left hand side along with two table components. This raw data table here contains some query data from my database. I can filter the dataset with the row selector. To do so, we need to make use of the data in and data out properties of the row selector. The component will filter the data in dataset and push the filter results to the data out property. The data in property provides the input for our row selection tree, so I'll bind it to the data property for the raw data table. Next, I'll bind the data property of our filtered table below to our row selector's data out property. Now, if I go into preview mode, we'll see the row selector tree has our dataset filtered by month and year.

[01:05] Clicking on the folder places the entire data out dataset onto my filtered table, which would be the results for the month of January. If I expand the folder, the filtering drills down by each day and even down to the hour, we can see my filtered table results are updating based on the filter selection within the row selector. The results represent the specific combination of our day and year filtering. Let's take a look at how the data is being filtered. I'll go back into design mode and right click on the row selector. Then go down to customizers and row selector tree customizer. Within the customizer, we have the available filters that we can apply to the data in dataset. Currently the component is filtering with the timestamp column, I can reorder how the filters are being applied. Additionally, I can change the icon path, so instead of having a folder, I can click on this folder and drill down to another icon like a calendar.

[02:06] The timestamp display string can be changed with the format string option. I can choose a built-in format by clicking on the pencil icon, or I can type it in directly. I could add the rest of the year so the filter matches up with the table results. I'll click okay to see the changes. It's important to note that you don't have to filter by the timestamp. I'll go back to the customizer to see this. I can just delete all these filters and filter Instead by equipment, I can move the equipment string over by clicking on the arrow, and I'll filter by the cause as well. I'll click on okay to see the new filters being applied. The row selectors grouping our data by piece of equipment. Now going back to preview mode, I can drill down to each cause for the piece of equipment or by the equipment itself. Lastly, I wanted to note that you don't need both tables on the window here. The raw data tables really just show you what the data looks like before it's filtered.

[03:03] Really. You could take the query that's on the data binding for the raw table and just move it to the data in property on the row selector.