Only Show Complete Values

[#1]

Is there a good way to exclude incomplete values?

Example:

Dimension 1:  TimePeriod - Cyclic Dimension with 7 day groupings, 28 day groupings, 54 day groupings, etc.

Dimension 2:  Category - A, B, C, etc.

Expression:  Sum(Pandas)

Date: YYYY-MM-DD

I only want time periods in which I see pandas every day--regardless of category.

if(aggr(count(distinct Date),TimePeriod)=max(aggr(max(Date),TimePeriod)-aggr(min(Date),TimePeriod)+1),sum(Pandas))  doesn't do the trick.

[sunny_talwar · Accepted solution]

You need a TOTAL to get it to work:

=If(Count(TOTAL <TimePeriod> DISTINCT Date)=Max(TOTAL Aggr(Count(DISTINCT Date),TimePeriod)), Sum(Pandas))