Preset Feature Feedback
What is the problem or goal the end user is trying to solve or accomplish?
The end user needs charts ((including line, bar, and mixed charts) to display zero values on all dates for specific categories, even when there are no records for these categories in the dataset. This is essential in cases where they are monitoring metrics by category (e.g., user counts by country) and require the chart to reflect inactivity explicitly as zero values. Currently, if there is no record for a particular category on a given date, the chart appears as if there’s no data, which can be misleading—especially when monitoring recent days where data absence could imply non-updating.
How are they solving it currently?
Currently, they are using the existing "Resample Rule" and "Fill Method" options to fill null values with zeros within the range of dates where data exists. However, this does not address cases where specific categories have no records on certain dates (e.g., when no data is present for a given country on a specific day, or all relevant data is zero up to the most recent date). As a workaround, they are modifying their SQL view to ensure that there’s a row for each date and category, even with a zero value. This workaround is not scalable for larger datasets and requires manual effort.
What is the recommended solution by the Customer?
The customer suggests an enhancement that would allow Preset’s time series chart types (including line, bar, and mixed charts) to automatically populate zero values for any date-category combinations missing in the dataset. Ideally, this option would extend beyond simply filling within existing data ranges and would support the creation of zero-filled points for any category not represented on a given date, even if no records exist for that combination. This would ensure consistent date representation across categories, improving clarity in tracking inactivity alongside activity.
