In a Looker Explore, we want to display only the data from the latest date for each ID. For example:
| ID | Probability |
|---|---|
| 1 | 0% |
| 2 | 50% |
When we add in the date dimension, then we want to break it down by date:
| Date | ID | Probability |
|---|---|---|
| Feb 5, 2023 | 1 | 0% |
| Feb 4, 2023 | 1 | 1% |
| Feb 3, 2023 | 1 | 2% |
| Jan 15, 2023 | 2 | 50% |
| Jan 14, 2023 | 2 | 45% |
We want to define the probability as a measure for easier visualisation. Is this kind of behaviour possible in a Looker Explore?
