There is a topic that looks for 1 year of data. While it performs well and handles adding new columns as expected, I’ve encountered an issue with data filtering.
When applying a new filter and trying to pick a value, Omni appears to ignore any existing dashboard filters. Instead, it retrieves filter values based solely on the initial “always_where_sql” setting of one year. This doesn’t make sense to me, especially since I have already limited the dashboard view to two days, as shown in the image below. The filter continues to query the full year regardless of those active constraints, but it never loads the values.
Regardless of the filters applied on the dashboard, the query Omni executes to fetch filter values remains structured like this:
Thank you.