Set Analysis using Greater than with Distinct Values

[robertpryde]

So here is the long and short of it.

I have a table with a list of assets (AssetName) and A Chart that I would like to display the count of Distinct Assets by month (regardless of selections.

Count({$<Month=>} Distinct AssetName))

No Problem - Works flawlessly.

Now I would like to count a subset of that population based on the comparison of two other fields for each distinct AssetName

Field One = CycleTime

Field Two = DesignTime

I tried something like Count({$<Month=>,CycleTime={">DesignTime"}>} Distinct AssetName)), but nothing.  I tried a few variations using Aggr, to no avail. 

Can Anyone Help?

[robertpryde]

I tried going this route.  The issue with this solution is the two fields in question (Cycle Time and Design Time) are actually loaded from separate tables (I provided a simplified table of data).  To do this I would have to manipulate the tables more than allowed in our current environment.

[robertpryde]

It would end up being the average of cycle time to the average of design time.  Asset performance is dynamic relative to design.

[sunny_talwar]

Then try this

Count({$<Month, AssetName = {"=Avg(CycleTime) > Avg(DesignTime)"}>} DISTINCT AssetName)