topic Re: Count distinct dates in App Development

Count distinct dates

satishkurra — Wed, 23 Oct 2024 18:01:12 GMT

Hi Team

I'm having an expression in straight table as Count(distinct SalesDate). This is producing me the count I need. Also, the Sales Date is of MM/DD/YYYY format.

Now I'm trying to filter the table to show the records that the count of above expression is >= 300.

Can someone help me with this?

Re: Count distinct dates

Kushal_Chawda — Wed, 23 Oct 2024 18:12:25 GMT

@satishkurra try below

=sum(aggr(if(Count(distinct SalesDate)>300, Count(distinct SalesDate),Dim1,Dim2)) // Dim1 & Dim2 are staright table dimensions. You need to include all dimensions. or Count(distinct {<Primary_Key={"=Count(distinct SalesDate)>300"}>}SalesDate)

Re: Count distinct dates

satishkurra — Wed, 23 Oct 2024 18:34:27 GMT

@Kushal_Chawda : Below expression is working but it is showing the value with 0 as well in the table

2nd expression did not work

sum(aggr(if(Count(distinct [Sales Date]) >= 300, Count(distinct [Sales Date])),[Actual Name],[Product Name]))

Re: Count distinct dates

Kushal_Chawda — Wed, 23 Oct 2024 18:38:01 GMT

@satishkurra You need uncheck "Include zero values" option

Re: Count distinct dates

satishkurra — Wed, 23 Oct 2024 18:41:01 GMT

@Kushal_Chawda

Yes it is unchecked. The issue is I have some other measures which are 0 and it is not working