Date selector: use last known values for dates without data

OllyTsimosh

Hi.

I'm building a dashboard that tracks vacant properties based on property surveys that are conducted every month. Usually each survey is completed in a single day. I want to add a date selector that could be used to select a single or a range of dates to display data for. Right now data only shows up if you select a specific date on which the survey was recorded and I was wondering if there was a way to populate the following days with the data from last recorded survey.

Eg:

Survey #1 recorded 21 current vacant properties in the region on 21st of April, 2024
Survey #2 recorded 18 current vacant properties in the region on 24th of May, 2024

I want every date between these two surveys to show the data from Survey #1, while every date after 24th of May to show the data from Survey #2 (until the next survey is conducted).

Is there a way to achieve this without creating records for every single day?

Thank you.

JillianStanford

Hi,

I can't think of a way to do this with simple Actions and Filters.

You could create a data expression that includes a record for each day. This would not require you to actually create extra records in your data but depending on the amount of records it can really slow your dashboard down.

Jill