Constrain user to selecting single days in a filter?

Is there a clean way to filter a metric set by date, but constrain the user to selecting a single day instead of setting a range of dates?

I have a graph that is only designed to display a single day of data at a time.

One option that comes to mind is creating a dimension with the “name” of each date, but I want the user to be able to see a standard calendar filter “picker” for the date rather than a scrolling through a long list of dates.

Thanks!

Hello,

In the specific screenshot you posted it’s in the dashboard designer itself which cannot be limited beyond what the time dimension allows. However, what is added to the dashboard can be limited. For example, you could add a single calendar filter:

image

Then you could customize the properties to only allow selection at the day level. You can also further restrict it to hide un-selectable levels, but in order to do that you must set a parent member since we can’t display all of them:

The result of this would be this control on the dashboard:

As you can see the control only shows January 2008, and only allows selection of the day level.

If you really want to customize it for the dashboard developer, as mentioned above you can do it by customizing the time dimension itself. In that case you would uncheck all levels except for the day level. It should be noted if you do that and use the time dimension with data, it would only aggregate to the day level as well.

3 Likes

Thanks, that’s what I needed!

1 Like