I'm in AGOL. I have an indicator set with an SQL query for a date to be on or before a date. This gives me a running total of things over time. I have another indicator that queries just for a single day, giving me a total for the day.
Now when I add a date picker, set to a single date, set actions to update indicators. When I do this, the total indicator no longer respects the on or before SQL.
Is there a way to get 2 indicators, one showing a running total and one showing a single day?