Skip to content

Control the options shown in the Time Grouping Filter based on the Date Filter or trigger an event on Date Filter change that sets the time groupingΒ #51626

Open
@Tony-metabase

Description

Is your feature request related to a problem? Please describe.

Right now if you have a combination of Time Grouping with Date Filter it can make extracted results confusing if output values exceed 10000 limit on dashbaord. Take the following example where you have 2 filter:

Image

Let's take the above example and have Filter to Day and a Time Grouping by minute a max of 60*24 points will be shown. but if a user changes that date to past year, the time grouping is still set to minute, suddenly that smashes through to 365*24*60, which is way above 10k limit to display in a chart

So the graph is trimmed to 10k rows and its not really obvious because theres no warning like you get on a Question level:

Image

Describe the solution you'd like
To the very least there would be a warning somewhere about the truncated data. Or a more complex approach would be to control the Time Grouping based on the Date Filter. So that if you select a Year worth of Data then you will only give Day grouping or Month Grouping as options in the Time grouping filter

Describe alternatives you've considered
None that I can think of

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions