Count No of days based on 2 dimension

Question

Dear Community members,

I need help to find no . of days.

I have field Customer Name,Date and Sales

I have tried LOD expression:

{include [Customer Name],[Date]:IF (SUM([Sales]))>=1 THEN 1 END}

Answer 1

Hey, @Ravi,

You can go through this to get a broader view https://www.edureka.co/community/934/use-lod-count-distinct-number-records-based-some-condition