We have a requirement to show a count of distinct users. The customer also wants to be able to select dates from a date range.
Typically, this wouldn't be a problem, you would just say, count(distinct user_id). However. The size of our data is such that loading all user_ids per day is absolutely not plausible.
Is there a way that we can have a user select multiple days (and other selections) and hit a button that queries the db for the specific distinct user_id count, and presents it on the dashboard?
In a perfect world, this would not impact the cache of the rest of the dashboard, and would be somewhat surreptitious (not needing the user to wait for an unresponsive dashboard to come back).
