count of dimensional value with if condition against expression measure

[qs123]

Hi,

Within the License Monitoring App, I have created a table with one dimension and one measure.

• Dimension  = User Name
• Measure = If user has never logged in, then count number of days since the License was allocated and today's date... Else count the number of days since the User was last logged and Today's date

The expression I use is as this...  if([User Access Last Used] ='Never', floor(date(now())) - floor(date([User Access Created])) , floor(date(now())) - floor(date([User Access Last Used])) )

The above expression is giving me expected result in the table. But I want to use a single value in KPI to show total number users who have been inactive since more then 90 days..

so.. how do I count total number of users, which has this measure value > 90 ?

[forte]

Hi @qs123 

Just try this, using aggr

sum(

aggr(

if(

if([User Access Last Used] ='Never', floor(date(now())) - floor(date([User Access Created])) , floor(date(now())) - floor(date([User Access Last Used])) )

> 90,1,0)

, [User Name]

)

)

Hope it helps

Regards