...
To be more specific, both of the metrics have two formulas: ____ and ____ (Detail)
...
TWhen 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.