...
When pivoting by your data by day or machine, it is highly recommended to be using use the Detail “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. If the “Detail” formulas are not used in a case like this, it will result in incorrect results (often overstated and exceeding 100%). The same Detail formula is required if the widget is pivoted by Machine.
...
Whereas when analyzing at a larger scope of time, such as months, we leverage the base variants. This can be seen below:
...