Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Within the License Monitoring App, I have created a table with one dimension and one measure.
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 ?
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