Quick response please-Taking average of summed value (LAC A/LAC W)

Question & Answer
, , , ,
2

Hi @Awan,
If your calculation is working with LAC-A, what is the reasoning for having to use LAC-W? When using LAC-A vs. LAC-W, the order of calculation will slightly differ which is where you may encounter a slight variance (like the one you’ve received).
Have you tested separately to confirm which mean is more accurate?

A couple things you could potentially try:

  • Remove the ‘avgOver’ aggregation and instead apply the average aggregation at the field well level.

image

  • Try using ‘truncdate’ to day for your order date; while your timestamps all look to be the same in the example, if by chance there’s a small variance in the time, it may not include.

  • Try just using a regular ‘avg’ calculation instead of ‘avgOver’

  • Try switching the PRE_AGG to PRE_FILTER to see how that alters the outcome.

Let me know if any of these suggestions help at all or if you have any additional questions. I’ll include an article below that has helpful hints when working with LAC-A and LAC-W functions.