...
When pivoting by your data by day, it is highly recommended to be using the Detail version of the formula, whereas in any other scope of time, the regular formula will suffice.
For example, in the chart analyzing the last 7 days of data, we leverage the Detailed variants, as seen below:
...
Whereas when analyzing at a larger scope of time, such as months, we leverage the base variants. This can be seen below:
...