Signals - 'consider using a date field with correct granularity message' in UI instead of just logs

Richard Wolters shared this idea ago

Idea Logged

Here you can see in the catalina.out what happens if we run a signal. We receive a lot of these:

[Background] [TASK_RUNNER] Duplicate entry found for 2019-09-01. In-memory aggregation is required. This can affect system performance, consider using a date field with correct granularity.

This occurs when there's a mismatch between the granularity of the field at the View-level vs. the selected granularity in the Signal setup.

For example, if you have Invoiced Date at the View level and its default Chart Granularity set to Week:

/6e2233137ac61a895541e746f4aa222a

But set the corresponding fields' Date Granularity to say 'Month' in the Signals setup:

/9557fdfb033aaf32ccfb769818aba1b7

You'll then see this message.

From a user’s perspective however one could argue that if a granularity mismatch is causing issues, either a warning should displayed or the option to set the granularity in the signal definition should not appear at all.