## Bug description

Monthly Active Users metric seems wrong when choosing "# Number" as chart type.

Number: 
![image](https://user-images.githubusercontent.com/513669/201980874-be7d9c0d-5c9c-4c1e-955c-ea4143c84061.png)

Line chart: 
![image](https://user-images.githubusercontent.com/513669/201980986-b17af929-84e5-4f6a-b7f8-23b7ac8bedbc.png)

**490 != 70**

## How to reproduce

1. Create a new insight using any event and the "Monthly active users" metric
2. Date range = This month + Grouped by = Day
3. Choose chart type as Number => remember value
4. Change chart type as Linear => check last data point

=> the 2 values do not match
=> in other words there's a diff between a total aggregation and an aggregation per bucket of time ?

## Environment

- [x] PostHog Cloud
posthog/queries/test/test_trends.py
import json
from datetime import datetime
from typing import Dict, List, Optional, Tuple, Union
from unittest.mock import patch
from django.conf import settings
from django.core.cache import cache
from django.utils import timezone
from freezegun import freeze_time
from rest_framework.exceptions import ValidationError
from posthog.constants import (
    ENTITY_ID,
    ENTITY_TYPE,
    TREND_FILTER_TYPE_EVENTS,
    TRENDS_BAR_VALUE,
    TRENDS_LINEAR,
    TRENDS_TABLE,
)
from posthog.models import (
    Action,
    ActionStep,
    Cohort,
    Entity,
    Filter,
    GroupTypeMapping,
    Organization,
    Person,
)
from posthog.models.group.util import create_group