Retrieving Data of the Latest Time

Version

Preview

You want to only keep the data with the latest time for the same store (the data of 2020/10/15).

• Before

• After

Implementation Method

You can set the summary basis to Latest Time through Group Summary.

Example data: Example Data.xlsx

Upload the example data to FineBI.

Creating a Subject

Create an analysis subject and upload the example data downloaded.

Retrieving Data of the Latest Time

Add the Group Summary step, drag New Store ID and State into the group, drag Time into the summary column, and set the summary method to Latest Time.

Save and update the analysis subject.

Demonstration

For details, see section "Preview".

For details about how to calculate the latest time in the dashboard, see MAX_AGG.