Count of records in a straight table

[Anonymous]

Hi

I am trying to display count of records in a straight table , my table is showing 13 but the expression I have shows 8

Can know the correct expression ?

Thanks

[swuehl · Accepted solution]

Maybe

=Count(

{<CLNDR_DT={'$(=vSelectedDate)'}, [User Friendly Metric Name]=, Date=, [Metric Type]=>}

DISTINCT if(left([Metric Type], 4) = 'TP50', [User Friendly Metric Name])

)

[stabben23]

Hi, Use a aggr in Previous expression, like this:

aggr(FirstSortedValue( { <CLNDR_DT={"<=$(=vPreviousDate)"}, [User Friendly Metric Name]=, Date=, [Metric Type]=>} Value, -Date,1 ), [User Friendly Metric Name])