Overview
Version
| FineBI Version |
6.0 |
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.
Procedures
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".
Notes
For details about how to calculate the latest time in the dashboard, see MAX_AGG.
Previous：Merging Same Values into One Group
