$__interval is too small/short views greater than 7 days

Grafana
1

When viewing time frames greater than 7 days, my graphs show data points that are too close together to be legible.

In a 30 day view, Grafana sets the interval to 1h. This is the case when I do not set a minimum interval in my data source and when I set the minimum interval to 1h.

I attempted to use an interval and custom variable, but using template variables cause alerts to be disabled.

Is there any way to limit each graph to show only 30 data points?

small_interval
small_interval1842×941 533 KB

My example query.

  WITH table_data_epo AS ( SELECT
        event AS metric,
        cast(count(*) AS int) AS value,
        $__timeGroup(created_at, $time_interval, 0) AS epo 
    FROM
        public."Metric"  
    GROUP BY
        metric,
        epo  
    ORDER BY
        epo DESC),  
  table_data_timestamp AS ( 
    SELECT
        metric,
        value,
        to_timestamp(epo) AS time 
    FROM
        table_data_epo) 
    SELECT
        metric,
		value,
		time
    FROM
        table_data_timestamp 
    WHERE  
        $__timeFilter(time)