Get the latest time data

1.1 Version

1.2 Expected effect

With the information of the same store ID, the user only wants to keep the latest time data of the same store, that is, the data of 2020-10-15. As shown in the following figure:

1.3 Implementation ideas

Use Group Summary to set the summary basis to "Latest time".

2. Operation steps

Sample data: 120.Sample Data.xlsx

Upload  sample data to FineBI.

2.1 Create a self-service data set

Create a self-service dataset and select all the fields under "Sample Data", as shown in the following figure:

2.2 Get the latest time

Add "Group Summary", drag "New Store ID" and "Region" into the Group column, drag "Date" into the Summary column and set the summary method to "Latest time". As shown in the figure below:

Name and save the self-service dataset.

2.3 Effect display

See section 1.2 of this article for details.