2 Replies Latest reply on Jul 29, 2016 4:38 AM by Luciano Vasconcelos

# Issues with LOD Calculations

Hello,

I hope you are doing well. I wanted to share a workbook I have create using dummy date to elicit the issue we are facing. Please find it attached.

For each product, A, B and C, we are trying to aggregate the metric values within a range and plot a trend line for all the points (This range is called Range A)

Similarly, we aggregate the reference metric values (basically the values for another range, say Range B) and plot a trend line for Range B

The issues I am encountering using LOD are:

1. For a large dataset, some data points seem to be missing
2. The aggregate values should be the average of each data point on the trend line

The workbook attached doesn’t clearly encapsulate the issue but it would give you a clear perspective about what issues we’re facing.

Could you point out the possible reason for discrepancy, that is why would the the numbers on the trend line not average out at the aggregate level and what would be the reason why certain data points seem to be missing.

Would be great to have any workarounds that could help achieve the result. Thanks.

• ###### 1. Re: Issues with LOD Calculations

Hi Ashwin,

Just one question why're you using LODs here. You can easily get it without LODs. Here I've used your original measures.

A-B(Copy): [Value in Range A]-[Ref. Value in Range B]

Let me know If you've any query.

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: Issues with LOD Calculations

Simple answer:

Your application is fine but your data no.

See:

You have missing values and that's why some points disappear. Your average is always the same because you the values per week is the same.