Counting MTD misses

[joshrussin]

Having some trouble think this one through.

Trying to count the number of days where Processed_Dash is less than Daily_Target_Dash

I would assume something like this

=Count({$<Processed_Dash < Daily_Target_Dash}, Month = {"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>} distinct Date_Dash)

[Anil_Babu_Samineni · Accepted solution]

May be create in script like below

If(Processed_Dash < Daily_Target_Dash, 1,0) as Flag

and expression is

Count({<Flag = {'1'}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)

Or, One ugly expression this? But, I don't consider it is use

Count({<Processed_Dash = {"=Processed_Dash < Daily_Target_Dash"}, Month = {'$(=Month(Today()))'}, Year = {'$(=Year(Today()))'}>} DISTINCT Date_Dash)

[sinanozdemir]

Hi,

One solution could be Count(Distinct If(Processed_Dash < Daily_Target_Dash, Date_Dash)). Although, this may affect the calculation time depending on the number of records you have in your data model.

Thanks