Use the minimum and maximum values of the reference field (“Order Date” in this example) or select a range between those values.Select to add the new rows to your existing field or create a new field to preserve your original data.Once you have indicated that a single field and the name of the field will be used, the interface offers the possibility of carrying out the following configurations: In this example, it is required to add rows from a single field: “ Order Date”. The first thing we must indicate is whether the filling of gaps will be taking a range of values from a single field or defining the range with the values of two fields. In the data for days 21 and 25 there are no records, since no sales were made. Let’s try the following data corresponding to the sales made during a week. The new step type: “ New Rows” will help you create the rows to fill in the gaps for the missing days and set the sales value of the new records to zero. You work with a sales data source, where there are only records for the days when sales were made and you require that there is at least one record in the data source for each of the calendar days. (whole numbers) as for date fields, through selecting options among the different available configurations. With the new feature, now filling gaps is within everyone’s reach and is a fairly simple task, since it has an intuitive interface that allows generating the gaps records for a set of sequential data, both for fields with numerical values. Until before version 2021.3.1, you would most likely have to use the “Scaffold” technique, which, although it helped us with the task of filling in the gaps in the critical data, it turned out that not all the people who needed it knew about the technique and how to implement it. When you work with a dataset that has gaps in sequential data, you may require the generation of new rows to fill gaps in critical data, either to facilitate the analysis of your data or detect trends or create certain types of visualizations, as we remember that Tableau will only represent marks where data records exist. The new version of Tableau Prep Builder 2021.3.1 is now available and brings us a very important new feature, a new type of step known as “ New Rows”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |